BIS-320: Managerial Relational Database System
This assignment uses the The Queen Anne Curiosity Shop case study in Chapter 4. At this point, the usefulness of converting the sample data into a properly structured database will clarify. It is usually very encouraging to see how producing the database creates the potential for the success of the business.
Upon successful completion of this assignment, you will be able to:
Identify candidate keys.
Identify primary and foreign keys.
Identify assumptions made and plan for validation of those assumptions.
Produce entity-relationship diagrams.
Explain the content of these diagrams.
Working through the case study allows you to practice your skills on a problem with data and the relationships needed.