Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inductive Databases And Constraint Based Data Mining

Authors: Saso Dzeroski ,Bart Goethals ,Pance Panov

2010th Edition

ISBN: 1489982175, 978-1489982179

More Books

Students also viewed these Databases questions