Draw erd with key attributes

Assignment Help Basic Computer Science

Reference no: EM13834913

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: EM13834913

Questions Cloud

Which of the following is a way to practice safe science : Which of the following is a way to practice safe science

Discuss how encryption relates to storage, network traffic : The command office has asked for a presentation on security mechanisms including access control models, authentication, authorization and encryption. Describe differences between them and identify situations where appropriate. Discuss how encryption ..

Where does nikki derive her source of power : Compare and contrast the power differential between the parties. Where does Nikki derive her source of power? Identify whether Michelle has a source of power

What was the magnitude of the rockets acceleration : What was the magnitude of the rockets acceleration

Draw erd with key attributes : 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..

Income statement for melanie mielke construction corporation : Melanie Mielke Construction Corporation is considering the appropriate accounting for two unrelated events during the year. The first event related to the effects of a labor strike that resulted in a work stoppage on a major construction project.

Common characteristics among the various nattive cultures : Native Cultures. Examine the history of native cultures in three different parts of North America before the 1600s. What common characteristics do you see among the various native cultures. In what ways were native cultures different from each ..

Analyze an operations process in a local organisation : To briefly describe and analyse an operations process in a local organisation in your country or region, and to explore this process by applying at least one of the core concepts you have learned in this subject.

Discuss set of metrics to use by feets : Using SCOR Level 1, discuss and recommend a set of metrics to use by Feets, the class scenario company. You will want to discuss the effect the metrics you choose will have on the company and the order in which you would implement the metrics

User Account

All Pages