Question

We have been asked to analyze the data requirements and develop a database system to keep information for equipment hiring companies in the country The aim of this system is to monitor the hiring of equipment to dients. There are many companies in the country, and each company has at least three branches across the country. Where each branch has staff including the branch manager who is responsible for the overall work in the branch Each company has a unique code, unique name and an owner (CPR, name). A staff can work in more than one branch. However, a manager manages only one branch. For each staff, we store staff CPR, name and office telephone number. Each company also has senior technicians who are responsible of supervising the work of allocated groups of staff Each branch has a number unique within the company, address, and telephones). Each branch has a stock of equipment for hiring. Each equipment is identified by its number and the branch it's located at has a description, and number of items of this equipment in the branch It is important to store the data of current clients in the database, where each client has a unique client ID, name, address, country and country international code. Current clients can hire as many equipment as they wish. For each hiring agreement between the company and the client of a given equipment, the date need to be recorded. Deadline: Sun 10 May Tasks to be done: Task No. Description Use the above information to build an E-R diagram. Note that there is some missing information in the scenario. To complete the task, you can make reasonable assumptions about the missing information. All the assumption made by you must clearly be mentioned in the report before making the ER diagram.

this is database course please draw the ER

by this way

Answer 1

solution - The we can teen Entities which questions are 10 company cleaning from 11.) Branch 111.) Equipment !) client V.) staff. + Primam keys of these entities are ; (1) company unique code and unique Name: 111) Branch & Branch Number 1) Елшpmen-"- Eqщpmл+ Num losh IN.) Client in Unique Client ID r.) stafft Staff CPR. Othen attributes of the entities are : 1.) company & Ownen (CPR) Hame, (1) Branch & Addnest and Telephone Numben. 11.) Equipment branch addret description Numben a items q this equipment in branch IN.) client's Name Address, country and country Intennational Coole. (N.) staff Name and office telephone Number

(115 Each company Relationship and Mapping Cardinalty. ech company had at least three branches is MiN) relationship. (1) A staff con work ton more than one branch So, t 's olpo Ng relationship. nhee branches sont (1) (IV.) A managen manages only one branch (11) helationships. Each branch har stock q equipment (ling relationship . Cunnent cliente con hine as many equipment as they wish (min) melationship.

(Code Name (Ownen Name y company] Office Telephone Number hos Branch Number Addreht (Name) Staff Works Branch staff Telephone CPR technic an l'ab Aire dake Equipment Equipment M Client branch tacak on client ID Dercriolan Nom (Address