Assignment: DATABASE SYSTEMS - CLASS PROJECT
DETAILS
• You will design, create and populate a database in MySQL
• It can represent any kind of data and any kind of relationships (check with me if you feel your topic may be inappropriate for class)
STEPS TO FOLLOW:
1) Come up with a concept. You have great freedom here. Examples:
a. Household items by category & container & who stuff belongs to
b. Your own store or restaurant (inventory, items, sales)
c. Your own music/movies business (titles, studio, media, etc.)
d. Personnel or inventory from your real-life job
e. Sports teams/leagues/players
2) Minimum number of tables (5)
3) Each table must have a defined primary key
4) Each table must have a relationship with at least one other table (through primary/foreign keys)
5) Each table must have depth of attributes sufficient to warrant a database (just lists of names, or tables with one or two attributes is not a useful database - find a topic that has enough detail to be able to make productive queries)
6) No minimum number of records per table, but the entire database must contain a minimum of 70 records.
[If your design is lacking in any of the above areas, I will ask you to improve it]
DESIGN YOUR DATABASE:
• MILESTONE 1
o Define your database so that you understand it. Use whatever notations, or representations you want so that you have a complete understanding of what you want to build, what it will contain, and what records will be in it (ungraded, this is just for your own self- edification).
o Author a set of business rules that define how the relationships work, and any other rules, such as a customer must be entered before they can buy something, etc.
o Create a simple ERD with just the entity (table) names and the relationship types between tables noted in Crow's foot notation.
• MILESTONE 2
o Author an ERD with the type of relationship and cardinality represented, and the primary keys and all attributes listed for each table.
o Make sure your database is in third normal form (3NF), and explain why it is in 3NF.
• MILESTONE 3
o Create the database structure in MySQL.
o Populate the database with live values that work.
o Prepare a script file that I can use to recreate your database on my machine (I will show you how to do this).
o Once your database is complete, I will give you an assignment to perform on it to complete your project.
Format your assignment according to the following formatting requirements:
1. The answer should be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides.
2. The response also includes a cover page containing the title of the assignment, the student's name, the course title, and the date. The cover page is not included in the required page length.
3. Also include a reference page. The Citations and references should follow APA format. The reference page is not included in the required page length.