In: Computer Science
Company X database
Create an ER Diagram using UML notation for the following tables, then write out in the Relational model.
Company X is a manufacturing company that binds and sells books. They have hired you to create database to track their Employees, Products, customers and their orders. All employees work with book Binding, Only some are designated as Reps for customers. Reps may have many customers.
But each customer can only have 1 rep. They count to record each Books author, title, price, published year, publisher, and ISBN#
UML diagram
I have drawn two database models please pick relevant one.
Crows Feet is model 1
Relational Model
Fee free to ask any query further.