Introduction (U6)

Relational database design process includes the process of identifying the tables, and the fields (columns) with associated types. The types of fields may differ from one database management system to another.

For example, MySQL database field types are given in this document: Data Types (https://dev.mysql.com/doc/refman/5.7/en/data-types.html.). They include text, numerical (data or ID) date and other field types.

Some of the fields could also be used to store IDs of records from another (related tables) to provide relations between the records. For example, if the one tale lists classes, another one lists students, we can create a table to record student enrollment. Then the enrollment table should have student IDs and class ID as its fields to record enrollment of the particular student into a particular class.

A new startup company is planning to build the system that would allow to collect user preferences over different venues (restaurants, movie theaters, museums, etc.). The company utilizes a continuous scale of rating between zero and five to describe users preferences.

Directions

The task of this assignment is to design the structure of the database for the startup company that would allow to store user preferences.

Submit a Word document with tables (one for each database table) that lists the following:

a) Field name

b) Field type (use MySQL data types (Links to an external site.)Links to an external site.)

c) A comment on the role of the field

In order to complete the assignment, you will need to identify the number of tables that would efficiently store data collected by the startup company; and design the fields including the one that would store ID values om other tables in order to ensure relations between tables. Please use arrows to identify the relations between table fields.

Here is an example of the design for the student enrollment database:

Students student_id student_first_name age ID of the student INT VARCHAR First name of the student INT Age of the student Enrolment student_id class id INT INT ID of the student ID of the class Classes class id INT s tile VARCHAR ID of the class Title of the class