Design a database to hold all this information

Assignment Help Database Management System

Reference no: EM132116065

Assignment Website.

The Somerdon High School PTO is creating a website that will allow students to quickly look up their homework assignments.

Functional Requirements:

The database supporting this website will keep track of departments, teachers, classes, and assignments. Each department has a name such as "math", "science", or "English", and each teacher is a member of a single department.

For each teacher, the database should store a title ("Mr.", "Ms.", "Dr." etc.), first name, middle initial, last name, office phone number, and e-mail address.

Each class is taught by one teacher; for each class, the database should store a name, description, meeting period (for example, 7th period), and room number. Finally each class has multiple assignments.

For each assignment, the database should store the date assigned, the date due, and a text description of the work assigned.

Obviously, the database also needs to remember which class each assignment is for, and which teacher teaches each class.

Design a database to hold all this information. Hand in a database design outline and an ER diagram. Additionally create all the necessary tables for this database, and choose a reasonable data type for each attribute. Create all necessary relationships between the tables and enforce referential integrity. You do not have to enter any data or create any forms.

Delivery Requirements:

For the database design I expect the following:

A one to two paragraph description of the database you are designing.

A listing of all the tables required to design the database.

A listing of fields, sorted by table, for each table.

With each field, you must list the data type for the field.

Each table must have a defined primary key.

Please provide a bulleted list of all relationships.

In addition to the table information, you must create a high level ERD diagram showing the tables within Visio.

When the Visio diagram is complete, cut and paste the diagram into Microsoft Word and name the document after your last name and Question 1

Reference no: EM132116065

Questions Cloud

Energy problem in wireless sensor networks used : Write an essay :- Energy problem in wireless sensor networks used in traffic management system

What is the probability that less than 80 of the orders : Consider a random sample of 150 orders for Valentine's Day flowers. What is the probability that less than 80% of the orders in the sample are for roses?

Write down the relevant portion of the main function : Write down the relevant portion of the main function of this program to implement the state machine (only the first and the last state).

Solve a business problem using a theoretical framework : BUS101 - Business Analytics Report Assignment, University of the Sunshine Coast, Australia. Solve a business problem using a theoretical framework

Design a database to hold all this information : Obviously, the database also needs to remember which class each assignment is for, and which teacher teaches each class.

Design the entity as well as the test bench for a 4-to-1 : A multiplexer is a device that selects one of several analog or digital input signals and forwards the selected input into a single line.

Estimate the probability of the given documents : Estimate the probability that the above documents are relevant to the query. Use a contingency table. These are the only three documents in the collection.

How many students have grades below 80 : In a large class of 3000 students, the mean and standard deviation of a final exam are 70 and 10, respectively:

Do you think that business use of the internet has changed : How should a business store, access, and distribute data and information about its internal operations and external environment? Explain.

User Account

All Pages