Answered: DATABASE SYSTEMS A language school…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Question

DATABASE SYSTEMS A language school having branches in different cities provides courses in English, Arabic, Chinese and German languages. It is required to know when each course started to be given in each branch. Teachers can be Turkish or foreigner. Turkish teachers must be graduated from related language department of a university to be able to give intended course. Foreign teachers must have at least 5 years-experience. It is also needed to know his/her home country. Apart from Turkish teachers, all other teachers get their salary in Dollar. In language school there are beginner, intermediate and advanced level classes. It is requested to know which course is orginesed and between which dates. Draw ERD for above given scenario. Show the following requests on the diagram. i. Having changes on entities, attribute and relationships correctly. If there are missing attributes, add them. Definitions must satisfy normalization ii. Defining arc structure and also convert it to supertype/subtype ( iii. Defining M:M relationship and resolving it. iv. Keeping the history of salaries of teachers

Expert Solution

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions