Relational data model
I would like to see a T diagram for this one created in Word along with a written explaination. This will help me to understand these identifications.
Assignment:
Your contact at the University has given you a set of tables. (see attachment). What tables are you are going to use in this project, what are the appropriate fields and size for each field, and why? Specify the primary and foreign keys for each table and the links between the tables.
Define the relational data model and, given a problem description and a representation of the associated database, determine if the database satisfies the properties of a relational database
References and in-text citations in APA format
© BrainMass Inc. brainmass.com December 15, 2022, 7:57 pm ad1c9bdddfhttps://brainmass.com/computer-science/searching/relational-data-model-261493
Solution Preview
Hi
** Please see the attached file for the complete solution response **
The following tables that you are going to use in this project:
1.Student:
2.Student_Type:
3.Class_Registered:
4.Class_Type
What are the appropriate fields and size for each field, and why?
Specify the primary and foreign keys for each table and the links between the tables.
1. Student:
This table has three columns.
a.Student_id (PK): This column of integer data type and this will be the primary key
for this table to uniquely identity a student record.
By looking at the data given for the student records the data type integer for student_id .
b.student_name: This column has data type varchar(50) due to the fact student name is of text.
c.student_type(FK): this column of data ...
Solution Summary
This solution provides detailed explanations to the computer science questions.