New semester, new subjects, new goals and new challenge are coming. In week 1, the class is cancelled because of the public holiday (most of my course-mates weren't back to UTP yet actually) and Ms Emy had some important stuff to do. I'm expecting to have a great semester with this course, Data and Information Management because I do like something that is related to data management and what's interesting is Miss Emy! Our FOP1 lecturer back then when I was in foundation first semester.
In week 2, well actually this is my-kind-of-hectic week because I was involved in iFest. But I managed to come to the class in the midst of my hectic-ness. As usual, the first class was all about introduction. From the course outline to Chapter 2, Database Environment. We were introduced about database, how does file-approach works and database-approach works, the DBMS which stand for Database Management System, the Pros and Cons of using DMBS. The way that Miss Emy taught us is quite easy to understand, Alhamdulillah. I managed to grasp the difference between file-approach(which is not an efficient way due to data duplication) and database-approach(shared data).
Fast forward, we learned the next chapter which is Database Environment. Miss explained about what is ANSI-SPARC architecture, which consist of three levels, External Level, Conceptual Level and Internal Level. She did taught us about the difference between these three levels, data model, database language, data independence and conceptual modeling.
Short Biodata
Name: Nuraina Fathinie Bt Fahrurrazi Known as: Fathinie or Thinie DOB: 19th of MayStat: Negeri SembilanCountry: MalaysiaFav. Colours: Green, Blue & Pastel colourLanguage: Malay and English Study: Universiti Teknologi PETRONASCourse: Information & Communication Technology Ambition: Software Engineer or Software Architect
Goals & ExpectationGoals: Aiming to achieve A for DIM subject and to grasp the idea and concept of managing Data and Information and implies it into my carrier work.
Expectation: Able to understand on how to manage the data & info effectively and efficiently.
Likes:
♥ Drawing♥ Anime & Manga♥ Digital Art♥ Green Stuff♥ Spicy food♥ WACOM Intuos Tablet♥ Naruto♥ Coding & Hacking
✿The purpose of this blog is actually for Data and Information Management subject. Here, where I'll share my views, summaries and some sharing about this course. It may not as good as the others, but I'm hoping it might help to those who came here for some references. This is actually my old blog. I've been blogging since I was 13 years old and went hiatus when I was 16 years old. May Allah bless our days and giving success to all of us, Amin. Have a nice day :) ✿
Week 1 & 2
Assalamualaikum and hello earthlings :)
New semester, new subjects, new goals and new challenge are coming. In week 1, the class is cancelled because of the public holiday (most of my course-mates weren't back to UTP yet actually) and Ms Emy had some important stuff to do. I'm expecting to have a great semester with this course, Data and Information Management because I do like something that is related to data management and what's interesting is Miss Emy! Our FOP1 lecturer back then when I was in foundation first semester.
In week 2, well actually this is my-kind-of-hectic week because I was involved in iFest. But I managed to come to the class in the midst of my hectic-ness. As usual, the first class was all about introduction. From the course outline to Chapter 2, Database Environment. We were introduced about database, how does file-approach works and database-approach works, the DBMS which stand for Database Management System, the Pros and Cons of using DMBS. The way that Miss Emy taught us is quite easy to understand, Alhamdulillah. I managed to grasp the difference between file-approach(which is not an efficient way due to data duplication) and database-approach(shared data).
Fast forward, we learned the next chapter which is Database Environment. Miss explained about what is ANSI-SPARC architecture, which consist of three levels, External Level, Conceptual Level and Internal Level. She did taught us about the difference between these three levels, data model, database language, data independence and conceptual modeling.
That's all for today. Bye and Assalamualaikum :)
Chapter Summary
Hello there. Here are some of the summary for every chapter :D
Chapter 1
Chapter 2
ANSI-SPARC: American National Standards Institute, Standards Planning And Requirements Committee
: an abstract design standard for a Database Management System
Three Levels: External Level
: Conceptual Level
: Internal Level
Reasons of the architecture: Allows independent customized user views
: Hides the physical storage details from users
: Able to change the database storage structures without affecting the users’ views
: Unaffected by changes to the physical aspects of the storage
: Able to change the conceptual or global structure of the database without affecting the users
Data Independence: Logical Data Independence
: Physical Data Independence
Database Language: Data Definition Language (DDL)
: Data Manipulation Language (DML)
: Fourth Generation Languages (4GLs)
Data Model: Object-Based Data Models
: Record-Based Data Models
: Physical Data Models
Conceptual Modeling: A model made of the composition of concepts, which are used to help people know, understand, or simulate a subject the model represents
Chapter 3
Entity Relationship Diagram(ERD): a pictorial representation of a database structure
Components: Entities
: Attributes
: Relationship
Entity: Refers to entity set and not to single entity occurrence
Attribute: Characteristics of entities
Relationship: Associations between instances of one or more entity types that is of interest
Cardinality: minimum and maximum number of instances of one entity that can associated with each instance of another entity.
Steps to draw ERD
- identify the main entities(draw rectangle)
- identify the relationships among the entities(draw diamond)
- identify the cardinality
- identify the attributes of each entity(underline the primary key & draw oval)
- revisit the ERD
