Take the data below and create a Model with functional dependencies.

profileFrenchienoire

 

  1. In a text/word file, write out the “Model” of your tables in the following format:
    TABLE_NAME(Key, otherElements, etc.) (if there is a foreign key, italicize it)
    1. You might want to add extra fields to make your database make more sense.
  2. Create a MySQL Model using MySQL Workbench of your tables & be sure to include the relationships and enter the data below.
    1. Please Call your Database LastNameFirstNameAssignment2
    2. Each table created should have a Primary Key, and data types for each element.
  3. Submit text/word document and database creation script (SQL) through Assignment link on Canvas. Upload separately, not in a zip file.


  • Posted: a year ago
  • Due: 
  • Budget: $7