Draw erd with key attributes and data dictionary

Assignment Help Database Management System

Reference no: EM13834756

Message : Every School has many teachers and many students. Each student is assigned to one school and each teacher works for one school only. Each teacher teaches more than one subject but a subject may be taught by more than one teacher. The database should store the number of hours a teacher spent teaching a subject. Information held on each teacher includes his/her tax file number, name (first and last), gender and qualifications. The data held on each subject includes subject title and type. Each student can study more than one subject and a subject may be studied by more than one student. Data held on each student includes the student number, name (first and last), gender and date of birth. Each school is managed by one of its teachers. The database should keep track of the date he/she started managing the school. Data stored on each school includes the school's code, name, address (town, street and postcode) and phone.

For the above scenario, you need to perform the following tasks:

1. Draw ERD with key attributes. You can use any notation to draw the ERD. Must include legend.

2. Data dictionary for the above scenario

3. Implement the database and populate with sample data for every table.

Reference no: EM13834756

Questions Cloud

Media assignment : Whichever stance you take, you must justify the argument and highlight to the author that you understand what each of the three theories isand how it can be applied to the video. Draw from literature in the pdf articles to support analysis and argume..

Present a synthesized meaning of conflict and power : Present a synthesized meaning of conflict and power - Determine how power can constrain or exacerbate conflict.

Explain how you will implement and monitor the action plan : Explain how you will implement and monitor the above action plan. Explain the documentation that is required for each identified risk.

Outline why the account is at significant risk : Problem 1: From your business risk analysis, identify three (3) accounts to be at significant risk. For each of the accounts you identify:

Draw erd with key attributes and data dictionary : Draw ERD with key attributes. You can use any notation to draw the ERD. Must include legend - Data dictionary for the above scenario

Some of the worst con artists practice their craft based : Some of the worst con artists practice their craft based on meteorological events

Maria hernandez-associates : In June 2004, Maria Hernandez found herself out of a job for the second time in six months. As she left the building that had housed her failed dot-com employer, carrying a small box of personal belongings, her mind was already embracing a plan th..

Create a document retention policy for your college : Create a document retention policy for your College that complies with all state and Federal regulations

Principles that govern labor relations in the public sector : Discussion question responses should be at least 200-300 words. Your Module 7 discussion is to describe and analyze one of the following: A) Principles that govern labor relations in the public sector

User Account

All Pages