The task of this assignment is to design the structure of the database for start
ID: 3750804 • Letter: T
Question
The task of this assignment is to design the structure of the database for startup company that would allow to store user’ preferences. Submit a Word document with tables (one for each database table) that lists the following: Field name Field type (use MySQL data types (Links to an external site.) Links to an external site. ) 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 once that would store ID values om other table in order to ensure relations between tables. Please use arrows to identify the relations between table fields.
Explanation / Answer
Database design-
Tables-
User Table with fields-
Username – varchar
ID- int(10) auto increment [PRIMARY KEY]
Age – int(10)
Sex- varchar
Phone- int(10)
Interest Table with fields-
Item_ID- int(10) auto increment [PRIMARY KEY]
Item_Name- varchar
User_ID- int(10) [FOREIGN KEY]
User
ID
Username
Age
Sex
Phone
1
Alex
25
Male
33339999
2
Billy
30
Male
88877559
Interest
Item_ID
Item_Name
User_ID
1
Camera
2
ID
Username
Age
Sex
Phone
1
Alex
25
Male
33339999
2
Billy
30
Male
88877559
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.