To characterize fully the data needs of the prospective database users. method: questionaire, chatting, Result: requirements of database users
Database Design phases---step2
The needs of the users play a central role in the design process.
We focus on the design of the database schema in this chapter.
Database Design phases---step1
Chooses a data model and translate those requirements into a conceptual schema. method: E-R model or E-R diagram Result: E-R diagram
Database Design phases---step3
E-R model consists of:
Entity sets Relationship sets Attributes constraints
Entity sets
A database can be modeled as: a collection of entities, relationship among entities.
Incompleteness, eg:
student(student_id, select_course, grade) What happened when you insert a student who didn’t