Explore BrainMass
Share

Explore BrainMass

    Designing a database for university

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

    Describe how you would design a database to keep track of all the students at a university. describe tables, relationships, attributes, Primary Keys, Foreign Keys, Candidate Keys. Describe minimum and maximum cardinalities for each relationship. Make sure the database is normalized.

    Items to keep track of in database:

    first name
    last name
    middle name
    city
    state
    zip
    phone1
    phone2
    email
    gender
    birthdate
    major(s)
    minor(s)
    club(s)
    organization(s)
    honor(s)
    classes taken
    grades in each class taken
    track gpa and major gpa

    Assistance would be greatly appreciated. Thanks

    © BrainMass Inc. brainmass.com June 1, 2020, 6:28 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/designing-database-university-192335

    Solution Preview

    Database
    Describe how you would design a database to keep track of all the students at a university. Describe tables, relationships, attributes, Primary Keys, Foreign Keys, and Candidate Keys. Describe minimum and maximum cardinalities for each relationship. Make sure the database is normalized.

    Items to keep track of in database:

    first name
    last name
    middle name
    city
    state
    zip
    phone1
    phone2
    email
    gender
    birthdate
    major(s)
    minor(s)
    club(s)
    organization(s)
    honor(s)
    classes taken
    grades in each class taken
    track gpa and major gpa

    Solution:

    First Normal Form

    A table is in First Normal Form when each field contains the smallest meaningful data and the table contains no repeating fields. Another way the table needs to be changed is to eliminate repeating data groups.

    The above set of tables has fields that contain the smallest meaningful data. For example, the name field has already been split into three sub fields: first name, middle name and last name.

    There are no other fields that have to be split to contain smallest meaningful data. ...

    Solution Summary

    This in-depth solution of 650 words describes database design for first normal form, second normal form, and third normal form. All characteristics of the database are listed.

    $2.19

    ADVERTISEMENT