Computer Science Homework Solutions
Problem
#192335

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

Solution
What is this?
By OTA - Overall OTA Rating
Purchase Cost Now
$2.19 CAD (was ~$39.90)
Included in Download
  • Plain text response
  • Attached file(s):
    • Normalized_Database_Solution.doc
$2.19 Instant Download
Add to Cart
Why you can trust BrainMass.com
  • Your Information is Secure
  • Best Online Academic Help Service
  • Students find real academic Success
Related Solutions
  • E-R Diagram - Assume that at XYZ company each product (described by Product No., Description, and Cost) is comprised of at least three components (described by Component No., Description, and Unit of Measure) and c ...
  • Example of Database Relationships - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
  • Create an IDEF1X digram - The Jefferson Dance Club teaches social dancing and offers both private and group lessons. Jefferson charges $45 per hour per student (or couple) for a private lesson and charges $6 per hour per stude ...
  • Entity Relationship Diagram - 2. ERD (Entity Relationship Diagram) You will develop the entity relationship diagram (ERD) for your project database based on the initial data requirements. The company that we are working on ...
  • Give examples of the following Database relationships: one-to-one one-to-many many-to-many - Look for an example of a one-to-one relationship, an example of a one-to-many relationship, and an example of a many-to-many relationship in a newspaper, magazine, book, or everyday situation you enco ...
Browse