drawdesign er diagram actual drawing no text stellar is an auditing firm your database is requir

As an AI, I'm unable to create actual drawings, but I can guide you through the steps to create

Question

Stellar is an auditing firm. Your database is required to keep track of all employees, projects, departments and suppliers (hint: this statement should give you an idea about the entities you are working with) Every Employee has a unique number (Employee ID) assigned by the firm and must also store their Name, Date of Birth and Job Title. o Some employees act as supervisors. A supervisor must supervise at least one employee; however, they usually supervise more. If an employee is a supervisor, you must store their Supervisor ID. (hint: does this statement tell you anything about type of relation and the cardinalities? (Check CH 2 slide #4, #25, #26 and #29) • Every employee is assigned to work at least one Project. However, there may be projects not worked on by any employee. And a Project must store the Project ID and Estimated Cost. • Every employee must belong to only one Department. A Department can have one or more employees. Each Department has a Department_ID and Phone Number. • A Supplier usually supplies each department with their necessary work items. You must store a Suppliers’ Vendor ID and Address. o A department may not rely on any supplier or multiple suppliers for their items; however, a supplier must supply items to at least one department. o If a supplier provides items to a department, you must store the date the transaction took place ▪ Hint 1: what entity is best suited to capture information only if it takes place. check Ch 2 slide #37 and #38. ▪ Hint 2: What are the cardinalities for this relation ▪ Hint 3: Given the cardinalities what is the representation style of this particular entity. auditing firm. Your database is required to keep track of all employees, projects, departments and suppliers.

Stellar is an auditing firm. Your database is required to keep track of all employees, projects, departments and suppliers (hint: this statement should give you an idea about the entities you are working with)
Every Employee has a unique number (Employee ID) assigned by the firm and must also store their Name, Date of Birth and Job Title. o Some employees act as supervisors. A supervisor must supervise at least one employee; however, they usually supervise more. If an employee is a supervisor, you must store their Supervisor ID. (hint: does this statement tell you anything about type of relation and the cardinalities? (Check CH 2 slide #4, #25, #26 and #29) • Every employee is assigned to work at least one Project. However, there may be projects not worked on by any employee. And a Project must store the Project ID and Estimated Cost. • Every employee must belong to only one Department. A Department can have one or more employees. Each Department has a Department_ID and Phone Number. • A Supplier usually supplies each department with their necessary work items. You must store a Suppliers’ Vendor ID and Address. o A department may not rely on any supplier or multiple suppliers for their items; however, a supplier must supply items to at least one department. o If a supplier provides items to a department, you must store the date the transaction took place ▪ Hint 1: what entity is best suited to capture information only if it takes place. check Ch 2 slide #37 and #38. ▪ Hint 2: What are the cardinalities for this relation ▪ Hint 3: Given the cardinalities what is the representation style of this particular entity. auditing firm. Your database is required to keep track of all employees, projects, departments and suppliers.

Added by Tammy J.

Question

Please give Ace some feedback