NA Textword File: Write Out The Model Of Your Tables

N A Textword File Write Out The Model Of Your Tables In The Follow

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) You might want to add extra fields to make your database make more sense. Create a MySQL Model using MySQL Workbench of your tables & be sure to include the relationships and enter the data below. Please Call your Database LastNameFirstNameAssignment2 Each table created should have a Primary Key, and data types for each element. Submit text/word document and database creation script (SQL) through Assignment link on Canvas. Upload separately, not in a zip file.

Paper For Above instruction

This assignment involves designing a database model based on a specified set of tables, their relationships, and sample data. The primary task is to create a clear representation of the tables' structure in a textual format, then translate this model into a MySQL database using MySQL Workbench, including all relationships and constraints. Finally, students must submit a text or Word document containing the model and the SQL scripts used to create the database.

The initial step requires students to write out the table structures in a specified format: each table's name followed by a parenthesis, listing the primary key, other elements, and foreign keys (italicized). This format aims to clearly identify the key fields and relationships in the model. It is advisable to incorporate additional fields where necessary to improve the database's clarity and functionality.

Once the textual model is formulated, students should proceed to create the actual database in MySQL Workbench. This involves defining each table with appropriate data types, primary keys, and foreign keys, establishing the relationships as indicated in the model. The visual model in MySQL Workbench helps ensure the integrity and correctness of the relationships.

Students are also required to input sample data into tables to facilitate testing and validation of relationships and constraints. Proper data entry can help demonstrate that the model supports realistic data scenarios and functions as intended.

The final deliverables are twofold: a Word or text document that details the table models in the specified format, and the SQL script used to create the database in MySQL. These should be submitted separately via the designated assignment link in Canvas, emphasizing that the files should not be compressed into a zip folder.

Overall, this assignment combines conceptual database design and practical implementation, requiring understanding of normalization, relationships, and SQL scripting. It helps develop skills in translating theoretical models into functioning databases while ensuring clarity and correctness in design documentation.

References

• Elmasri, R., & Navathe, S. B. (2015). Fundamentals of Database Systems (7th ed.). Pearson.