Hi, i need help building a database based on something like video store rentals, online shopping orders. Help would be appreciated.
I need to develop a UML class diagram for the system.
diagram can be hand drawn at this stage (but must be in electronic form for the final handup (try Excel or Visio))
Develop a Scheme based on the class diagram
with reference to your scheme, identify and describe, candidate key, primary key, foreign key, referential integrity, surrogate key and (if relevant) external keys
4.( notepad ++ is used here) write the SQL commands to create the database, create and populate tables, query individual tables. (You must include the SQL script in your document - cut and paste queries and results from mysql). Be prepared to defend your choice of data types for selected fields, and any 'not null' fields.
Your design must include at least one many-to-many (M:M) relationship, and one 1:M relationship. However, you need only implement the 1:M relationship at this stage. THANK YOU FOR YOUR HELP!