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.

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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!

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