User Account

All Pages

Design a database to keep track of all the students

Assignment Help Database Management System
Reference no: EM13949758

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

Reference no: EM13949758

Questions Cloud

Determine the dew point temperature of the products : 1. Acetylene (C2H2) enters a torch and burns completely with 110% of theoretical air entering at 748F, 1 atm, 50% relative humidity. Obtain the balanced reaction equation, and determine the dew point temperature of the products, in 8F, at 1  atm...
Calculate break-even units and the break-even sales revenue : Calculate the break-even units and the break-even sales revenue. Calculate the margin of safety in sales dollars. Calculate the margin of safety in units.
Earnings before interest and taxes : If Earnings Before Interest and Taxes (EBIT) is $93,000, calculate Operating Cash Flow if  Sales is $350,000 Cost of Goods Sold (COGS) is $140,000 Fixed costs is $43,000
Income statement will flow through to the statement : Net income from the income statement will flow through to the Statement of Retained Earnings.
Design a database to keep track of all the students : 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.
Determine the dew point temperature of the products : 1. Acetylene (C2H2) enters a torch and burns completely with 110% of theoretical air entering at 748F, 1 atm, 50% relative humidity. Obtain the balanced reaction equation, and determine the dew point temperature of the products, in 8F, at 1  atm...
Determine the dew point temperature of the products : A gaseous fuel mixture with a specified molar analysis burns completely with moist air to form gaseous products as shown in Fig. P13.20. Determine the dew point temperature of the products, in 8C.
A letter to the president of staley company : Staley uses a periodic inventory system. The inventories at January 1, 2008, and December 31, 2009, are correct. However, the ending inventory at December 31, 2008, was overstated $5,000.
Calculate the break-even number of units : Calculate the break-even number of units. Calculate the break-even sales revenue. Calculate the margin of safety in units. Calculate the margin of safety in sales dollars.

Reviews

Write a Review

Database Management System Questions & Answers

  Show all the columns from the orders table

Show all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

  The purpose of this assignment is to give you practice with

the purpose of this assignment is to give you practice with creating database structure using sql and using the insert

  Create structurally sound relational database schema

Create a structurally sound relational database schema showing the minimum number of fields, tables, and relationships between the tables.

  Designing of database

a. Discuss the degree to which you believe the Visio diagram reflects the database design. b. Describe any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.

  As a dba it is vital that you understand in detail how a

as a dba it is vital that you understand in detail how a query is processed by the dbms. since team retail is using

  Draw a context diagram for new system for baigs auto rental

Draw a context diagram for the new system for Baig's Auto Rental business. Create fully normalized 3NF table designs for the system.

  Find all non-trivial dependencies

Compute the closure sets of R, find all non-trivial dependencies and what are the candidate keys of R?

  Compose conceptual data modeling techniques

Explain the fundamentals of how data is physically stored and accessed and compose conceptual data modeling techniques that capture information requirements - design a relational database so that it is at least in 3NF.

  What amount would the company have to charge

what amount would the company have to charge for the Ericson wedding cake to just break even - what would be the overall margin on the order?

  Create database to keep information of movies

Create a database for Ray. He is interested in movies and wants to keep information on movies, actors, and directors in a database. The only user is Ray, and he needs to produce reports.

  Choose a data storage problem of storing data in database

You should choose a data storage problem of your interest and identify the different pieces of data that should be stored in database.

  Write down sql dml statements which address the given

write sql dml statements that address the following requirements 1 update the employees table and give all employees

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd