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