Entity relationship modeling

Assignment Help Basic Computer Science
Reference no: EM13686736

Entity Relationship Modeling


A company that sells and installs tiles needs a database with the requirements specified below. Your task is to present an Entity-Relationship model that meets the stated requirements. Try to ensure that your model has no many-to-many relationships. If you need any clarifications on the stated requirements, please let me know by our next class meeting.

Requirements:
The company has several branch offices. Each branch is identified by a branch_number. The name, address (street, city, ZIP), and revenue_target of each branch office are maintained. Each branch has one manager and the manager's employee_ID is maintained.

Each employee has a unique employee_ID. The company maintains the name, designation, starting_date, branch_number, salary, and supervisor's employee_ID for each employee.

Each product sold by the company is identified by a unique Product_code. The description, unit price, and stock_level of each product are maintained.

Each type of installation performed by the company is identified by a unique installation_type. The description and the billing_rate per hour for the installation_type are maintained.

Customers are identified by unique customer_ID. Information is maintained on each customer's address (street, city, ZIP) and phone_number.

Customer orders are identified by unique order_numbers. Each order is placed by a unique customer on a specific date. An employee is responsible for the order.

A customer order may include orders for multiple products and installations. For each product in an order, the quantity_ordered is recorded. For each installation_type ordered, the estimated number_of_hours for installation is recorded.


i prefer use this website to grow the entity with the relationship

Reference no: EM13686736

Questions Cloud

Evaluate where is the image formed by the objective lens : An insect 1.1 millimeter tall is located 0.8 millimeter beyond the focal point of the objective lens of a compound microscope. Find where is the image formed by the objective lens
Computer science and engineering communication : Computer science and engineering communication
What will be boeings profit if it decides first : Airbus and Boeing compete in the market for big airplanes. Presume each produce only one type of airplane and the airplanes are identical.  What will be Boeing’s profit if it decides first?
Determine the power consumption of electric heater : A current of 15.5 Amp flows through an electric heater operating on 120 Volt. Determine the power consumption of electric heater
Entity relationship modeling : Entity Relationship Modeling
Find what current flows in the resistor : A 760 Ω resistor is connected to a variable-voltage power supply. Find what current flows in the resistor when the voltage is 16 Volt
Customer surplus when the price is set to marginal cost : A natural monopoly has a cost function c (q) = 400 + 25q and market demand D (p) = 200 - 2p. What are the monopoly's profit, output, and customer surplus when the price is set to marginal cost? Average cost?
Obtain what the speeder speed with respect to the ground : A speeder is pulling directly away and increasing his distance from a police car that is moving at 29 meter per second with respect to the ground. Obtain the speeder speed with respect to the ground
What are the equilibrium quantity and price in this market : Presume demand and supply are given by Qd = 50 - P and Qs = 0.5P - 10. What are the equilibrium quantity and price in this market? Decide the quantity supplied, the quantity demanded and the magnitude of the surplus if a price floor of $48 is imposed..

Reviews

Write a Review

Basic Computer Science Questions & Answers

  What is an evil twin access point and a rogue twin access

What is an evil twin access point and a rogue twin access point?

  Eliminate unit productions from the following

Eliminate unit productions from the following CFG S->AB A->a B->C/b C->D D->E E->a

  Which following statements correctly sets a dog weigh

Assume you have created a class named Dog that contains a data fi eld named weight and an instance method named setWeight(). Further assume the setWeight() method is public and accepts a numeric parameter named pounds

  Create a time trial program to compare the average execution

Create a time trial program to compare the average execution times of the Formula Node and the native LabVIEW Math Functions. This program will rquire a For Loop, a Flat Sequence structure, and a Case structure. The For Loop is required to run the ti..

  Discuss any two major security flaws in us or anywhere

Discuss any two major security flaws in US or anywhere, one of which is a violation of Integrity, while the other is a violation of Confidentiality, with clear explain.

  Focus on the function and how it is secured by the use

Explain two or three uses for Microsoft Certificate Services. Focus on the function and how it is secured by the use of a PKI.

  Display the converted expression

Spaces between tokens are allowed but not required. The program will convert the expression to postfix (RPN) form and display the converted expression.

  What are some of the challenges associated with implementing

What are some of the challenges associated with implementing an EA governance framework?

  Determine integer to divide maximum number of partial sums

Now, given sequence, can you determine the integer M (L ≤ M ≤ U) which divides maximum number of partial sums of the sequence?

  The dash cell phone company chargs customers a basic

The Dash Cell Phone Company charges customers a basic rate of $5 per month to send text messages. Additional rates are as follows:

  Why can i only see up to the index of this book

Why can I only see up to the index of this book? I understand it's a large book and you may only want to give the reader access to part of the book, but if it's read only until I get my book in the mail, why can't I see the whole book

  Describe three ways to handle missing field values

Describe three ways to handle missing field values

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd