Making a erd using constraints and entities

Assignment Help Database Management System

Reference no: EM132077766

Need help making a ERD using Constraints, Entities, Relations, and Attributes for this problem.

A Bookstore has several branches throughout Champaign, and employees may be assigned to work at any of the branches at different times.

Employees are identified by an ID and have a full name, date of birth, SSN, address, multiple phone numbers, a gender, and a hire date.

A manager runs a branch and is responsible for all operations at that branch. Cashiers sell books to customers.

All purchases should have a date/time and receipt number recorded.

Books are identified by an ISBN number and have a title, one or more authors, a published date, a publisher, a price, and an edition number.

Books are stocked on shelves by stockers.

Each shelf has a location, a capacity, and ID.

The manager orders stock books from suppliers.

The system must capture the date and invoice number of all orders.

Suppliers have an ID, a name, a contact person, a website, an address, and a phone number.

Employees have exactly one mentor who helps them with any issues they may face. An employee may mentor more than one employee.

Reference no: EM132077766

Questions Cloud

Work out the cost of the glass and frame separately : Express the total cost C in terms of the height h in meters. (Hint: work out the cost of the glass and frame separately.)

Find the volume of the solid bounded by the cylinder : Find the volume of the solid bounded by the cylinder x^2 + y^2 = 4, and the planes y=z, x=0, and z=0 in the first octant.

Suppose a cylindrical glass with a diameter : Suppose a cylindrical glass with a diameter of 8 cm and a height of 10 cm is fully filled with a 400-Cal milkshake.

Development of any proposed improvement strategies : ICT709 ICT Industry Project - Development of WK Ashman web-based secure client interaction space - client collaboration space will utilise customised variants

Making a erd using constraints and entities : Employees have exactly one mentor who helps them with any issues they may face. An employee may mentor more than one employee.

Find z-coordinate of the center of mass of the solid : Find Z-coordinate of the center of mass of the solid of given density ?(x,y,z)=kz bounded by the graphs of the equations: z = 96 - x^2 - y^2 and z=0

Create a gpa calculator : How to makea gpa calculator using visual basic Create a GPA calculator. Ask the user to input a list of classes and the number of tests per class.

Find an equation of the tangent line to the graph : Find an equation of the tangent line to the graph of: f(x)=x/x^2+1 when x=0 Simplify as much as possible. Using formula Y-Y0=f'(X0)(X-X0)

Find the tangent line to the curve : Question 1: Find the tangent line to the curve 3 + cosm = y5 + '94 - 1 at the point (0, 1).

User Account

All Pages