What This Document Is
This is the first assignment for CMPS 180 - Database Systems I at the University of California, Santa Cruz. It’s a project-based assignment focused on database design, specifically requiring the creation of an Entity-Relationship (E-R) diagram. The scenario presented involves designing a database to support an online music store. This assignment challenges students to translate real-world requirements into a structured database model.
Why This Document Matters
This assignment is crucial for students learning the fundamentals of database systems. It’s particularly beneficial for those who are new to database modeling and need practical experience applying theoretical concepts. Students enrolled in CMPS 180 will find this assignment essential for demonstrating their understanding of E-R diagrams and their ability to represent complex data relationships. It serves as a foundational step for subsequent project phases, building upon the design created here.
Topics Covered
* Entity-Relationship (E-R) Diagramming
* Database Design Principles
* Data Modeling for Business Applications
* Requirements Analysis
* Attribute Domains and Data Types
* Key Constraints and Participation Constraints
* Weak Entities and Identifying Relationships
* ISA Hierarchies
What This Document Provides
* A detailed project description outlining the requirements for an online music store database.
* A scenario involving customers, songs, artists, albums, and transactions.
* Specific instructions for creating an E-R diagram, including guidelines for notation and constraints.
* Clear expectations regarding the level of detail and completeness required for the diagram.
* A note emphasizing the importance of saving the diagram for future project stages.
