Database design
What each database design question is really asking, how to structure the answer, and where the marks are likely to sit.
Core Database Design Principles Discussion Guide
Database design
Three concepts that only make sense together, and the assignment asks you to build your own example rather than describe the textbook's. Get the business rule right and the cardinality follows.
DNP 805 Topic 4: choosing database elements
Database design
Required versus optional is the graded distinction, and it is really a question about what the database cannot function without versus what would be useful if someone had time to enter it.
DNP 805 Topic 5: locating your data in the database
Database design
Pinpoint means naming a table and a field for every component, and the useful discovery is usually the component you cannot locate at all.
Database normalization: dependencies through to 3NF
Database design
The percentages next to each section are the grading scheme in plain sight. Reproduce the numbered outline exactly, and copy the normal form definitions from the text with page numbers — those are marks you cannot lose by knowing the material better.
Y2K, 640K and lessons for database creation
Database design
The two examples point in opposite directions — one is a limit that was hit, the other a limit that was assumed and never real — and reconciling them is what the answer is actually about.