Design adatabase to keep track of all students at university

Assignment Help Data Structure & Algorithms

Reference no: EM1380273

Question: Discuss how you would design a database to keep track of all students at a university. Explain tables, relationships, attributes, Primary Keys, Foreign Keys, Candidate Keys. Explain 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

Reference no: EM1380273

Questions Cloud

Create the entity relationship diagram : Create the entity relationship diagram for your project database based on the initial data requirements.

Analyzing the use of database in an organization : Examine the use of databases in your company. Include what database applications are used. Conclude through proposing improvements.

Describe specific steps in the hiv life cycle : How could these three cell types be clearly and simply distinguished from each other in an experimental laboratory and how and where do these different cell types differentiate to their mature functional characteristics?

Find capacity of a particular airplane type : Consider the entities and their attributes. You should 1st determine what entities want to track. Next determine what attributes are required for each entity, and what relations exist between these entities.

Design adatabase to keep track of all students at university : Discuss how you would design a database to keep track of all students at a university. Explain tables, Primary Keys, Foreign Keys, relationships, attributes, Candidate Keys.

Database design process : A college course may have one or more scheduled sections, or may not have a scheduled section. Attributes of COURSE include Course_ID, Course_Name, and Units.

Question about trigger : What are triggers used for, and why are they important in database systems? Give an example of a situation where a trigger would be appropriate.

Test the database management system functionality : In a report that less than half of all companies validate the in their databases and test database management system's functionality. Explain your answer.

Dbms and data mining to imporve customer service : Discuss how a database management system and data mining can help motor vehicle maintenance center improve its services, and what tables would be required in such a database.

User Account

All Pages