Database Systems Term Project (Terminal)

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.

(continued)

• 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.