Explore BrainMass
Share

Explore BrainMass

    Relational data model

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 October 9, 2019, 11:36 pm ad1c9bdddf
    https://brainmass.com/computer-science/searching/relational-data-model-261493

    Attachments

    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.

    $2.19