Explore BrainMass
Share

# 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
track gpa and major gpa

Assistance would be greatly appreciated. Thanks

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
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