Question: - no chatgpt answer (will downvote immediately if it was a ChatGPT answer / let the experts answer plz) - no handwritten answer - only

- no chatgpt answer (will downvote immediately if it was a ChatGPT answer / let the experts answer plz)

- no handwritten answer

- only unique answer

- the drawing part is important

in terms of databeses

- no chatgpt answer (will downvote immediately if it was a ChatGPT

The French Bakery is a new business project, the owner of the bakery needs a database to keep the essential data and transactions regarding his business. The following requirements of the bakery have been collected: - There are different departments in the bakery business, each department has a name, department number, the number of employees, and manager. - The database will keep the start date and the end date for each manager. - The bakery needs to keep Employee's name, ID number, Phone number, address, sex, position, and the salary. - Each employee work for a specific department. - Each employee has a supervisor. - Some employees have more than one position. - To keep contact with customers and provide customer services and marketing, the bakery requires customer's name, address, Cnumber (which is unique for each customer), email, and the phone number. - The bakery sells many products, each product has a name and a price, and the calories' amount. - The manager will be responsible of products. - Also, the Quality Department will control the products. Based on the above requirements, draw each entity with the relative attributes

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!