[Solved] CMSC 508 Database Theory

Phase I: Problem Definition and Database Design

## Objective

The main aim is designing a database that satisfies the information and functional requisites extracted from the analysis of the problem statement, in order to demonstrate your expertise and proficiency on the use of database design methodologies to create an accurate and faithful database. The design must reflect all expected information, scenarios, and functionality.

## Deliverables

Problem statement: a 2-3-page document with the definition of the real-world problem, providing contextualization, scope of the system, and listing all expected information and functionality. This should include 20 distinct queries that could be asked of the database written in plain English statements. The problem statement must be a Markdown document stored in this repository.

> Note: distinct queries are those that are entirely different. Counterexample: Display a list of student last names in alphabetical order is not distinct from Display a list of student names and email addresses. However, Display a list of student last names in alphabetical order is distinct from Who are the five students with the highest GPA?

Entity-relationship diagram (ERD). Created using proper software tools and consistent notation. Note: your design should consist of at least 4 major entities. This may be uploaded as an image (.png preferred).

Translation of the ERD into the relational model as relational schemas. **Listing of relations, their attributes, types, domain, and constraints, identification of the primary key and foreign keys.**

Identification of the Functional Dependencies that exist for each relation, **based on the real-world domain of the database.**

Normalization of the relations according to BCNF/4NF. A description, in a text format, of the process of decomposing the tables extracted from the ERD translation into relations satisfying BCNF/4NF **that includes a justification of the normalization claim.** Decomposition via BCNF/4NF must be lossless.

Sample data for each relation that could be used to populate the database to illustrate the behavior and interrelationships among data.

*Important! You must verify that the solution can reflect all data scenarios and information requisites identified in the problem statement.*