Design a relational database based on a case scenario. (a business, company, organization, etc.)
Requirements:
The project would typically go through the following phases:
1. Introduce the case scenario, business needs, requirements, functions, activities, entities and the purpose of the development of the database for your selected environment.
2. Specify a set of business rules for your case scenario.
3. Identify entity types and their relationship, using relationship matrix.
4. Draw a complete ER/EER diagram for your conceptual design by showing keys and attributes of entity types, relationship types, cardinality and participation.
5. Transfer the ER/EER diagram to a relational database and show the tables in a relational schema.
6. Set up all the referential integrity constraints in the relational schema after the transformation.
7. Display the functional dependency diagram for every table in the relational schema.
8. Indicate what normal form each table is.
9. Normalize tables in the relational schema to the 3 rd normal form.
Develop and query the database based on part 1, using SQLite.
Requirements:
1. Create the database with necessary constraints in appropriate tables. Include the database creation SQL scripts in your project report.
2. Insert appropriate data into the database tables. Include the insertion SQL scripts in your project report.
3. Set up 10 query questions and their SQL statement. Include the query question, the corresponding SQL script and the screen shot of the output for all queries in your project report. SQL statements must include variety of Select statements, Subqueries and Joins.
Note: the project report must be in Word document.
• Combine Part 1 and 2 and make sure they are consistent.
• Email the project report (Word document) along with the SQLite database file by May 10. (One email per group).
• Email subject line: IS441 - Group Project - Group number
• Each group will be required to present the project in 15 minutes, beginning May 3.
• All group members must participate in the presentation. Not showing up for the presentation will result in zero point for the project.