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

profileFrenchienoire
  1. n 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.
  • 8 years ago
  • 10
Answer(2)

Purchase the answer to view it

blurred-text
  • attachment
    models.txt
  • attachment
    script.sql

Purchase the answer to view it

blurred-text
NOT RATED