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

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
Get step-by-step solutions from verified subject matter experts
