Identify dependencies. 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.
BIS-320: Managerial Relational Database System
Getting Started
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 dependencies.
- 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.
Background Information
Working through the case study allows you to practice your skills on a problem with data and the relationships needed.
Instructions
- Review the rubric to make sure you understand the criteria for earning your grade.
- You will be asked to produce some diagrams. You are not expected to use any special software for these diagrams. While the content is important, the format is not important.
- Study The Queen Anne Curiosity Shop section of Chapter 4 in Database Processing: Fundamentals, Design, and Implementation.
- Complete items A through C, recording your resultant work in a Microsoft Word document.
- Submit the document using the Assignment submission link by the end of the workshop.
