Relational data model
Not what you're looking for?
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
Purchase this Solution
Solution Summary
This solution provides detailed explanations to the computer science questions.
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 ...
Purchase this Solution
Free BrainMass Quizzes
C# variables and classes
This quiz contains questions about C# classes and variables.
Java loops
This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.
Word 2010: Table of Contents
Ever wondered where a Table of Contents in a Word document comes from? Maybe you need a refresher on the topic? This quiz will remind you of the keywords and options used when working with a T.O.C. in Word 2010.
Basic UNIX commands
Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.
Word 2010: Tables
Have you never worked with Tables in Word 2010? Maybe it has been a while since you have used a Table in Word and you need to brush up on your skills. Several keywords and popular options are discussed as you go through this quiz.