Designing a database for university
Not what you're looking for?
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
Purchase this Solution
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.
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. ...
Purchase this Solution
Free BrainMass Quizzes
Basic Networking Questions
This quiz consists of some basic networking questions.
C++ Operators
This quiz tests a student's knowledge about C++ operators.
Inserting and deleting in a linked list
This quiz tests your understanding of how to insert and delete elements in a linked list. Understanding of the use of linked lists, and the related performance aspects, is an important fundamental skill of computer science data structures.
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.
C# variables and classes
This quiz contains questions about C# classes and variables.