Database

Please answer all 3 questions below within 300 words in total, then do the next practical session.
———————————————————————————————————-
1. Toyota car company has 80 employee and uses MS-Access software to store the information. Some tables of the data are shown in 2 tables shown in the attached image file. How many fields and records are there in these 2 tables? Which ones are the Primary and Foreign Keys? What and how do you create this relationship between these 2 tables?
     
2. What is ER diagram? How many types of entities in ER diagram, give me example and explain for each. What is the meaning of Calculated/derived attribute in ER diagram (use example for your explanation)? Why ER diagram is important?

3. Please explain about Distributed Database and the use of it (in what situation). Why distributed database is better compared to other configurations. Is there any draw back of this distributed system?