Database design begins by understanding what information a system needs and how that information is connected. This lesson introduces conceptual data modeling, requirements analysis, data dependencies, and ER diagrams—the foundation for later stages of database design.
A database designer determines what information a database must store. Designers often understand database technology better than the subject area the database serves, such as finance, biology, or healthcare. They therefore work with domain experts, who understand the meaning and use of the information.
All flashcards
What is conceptual data modeling?
It is the theoretical representation of the information a system must store and the interrelationships among that information, made before detailed storage implementation.
What role does a domain expert play in database design?
A domain expert explains the meaning and use of information in a subject area, helping the designer identify and accurately represent the required data.
What is a data dependency?
A dependency exists when one data value determines another within a defined context. For instance, if each person has one address, a person's name can determine that person's address.
What is a conceptual schema?
A conceptual schema formalizes the information gathered during requirements analysis, describing data and its interrelationships without focusing on detailed physical implementation.
What does logical data modeling do?
It organizes data and relationships into a logical structure that can be mapped to storage objects supported by the DBMS.
Quiz questions
What is the main purpose of conceptual data modeling?Answer: To represent the data a system needs and the interrelationships among that data before detailed implementation.
Why should a database designer collaborate with domain experts?Answer: Domain experts understand information's meaning and use, helping translate needs into data elements.
Which task belongs to physical database design?Answer: Selecting indexes and specifying replication and recovery choices.
In an ER diagram, what does an oval commonly represent?Answer: An attribute connected to the entity or relationship it describes.
A library wants to model members borrowing books and record each member's identifier. What fits the conceptual design stage?Answer: Represent Member and Book as entities, borrowing as a relationship, and MemberID as an attribute.
Based on the Wikipedia article Database design, licensed CC BY-SA 4.0. Adapted into a summary, flashcards and quizzes.