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

  How cost of box is evaluated in lookup table

Cost of box is determined by looking up value in a lookup table. Shipping cost also is determined by looking up value in a lookup table. Use table at cells H23:J28 with a VLOOKUP function to determine cost of a box.

  How many bit comparisons are made

How many bit comparisons (both successful and unsuccessful) are made by the brute-force string-matching algorithm in searching for the pattern 11001 in a binary text of 500 ones?

  Accordance to the recommendations

Write a report in accordance to the recommendations of the links on the study desk. The word-count limit for the introduction, body and conclusion of this report is set at about 3000 words

  Lettuce is used with several types of hamburgers

Q8. Farmer Bob, Farmer Jane and Farmer Jose run a cow farming co-op. For every cow they keep the cow's name, age (or date of birth), breed and numbered plastic ear tag. The each of the three farmers own many cows and share some of the cows wit..

  What happens when you assign

What happens when you assign 340,282,343,598.33 to a Single variable? Assuming that the variable in question is named sngNumber and you execute the statement MessageBox.Show

  How these models would facilitate a company in the country

Review the IT diffusion models, select two models, then compare and contrast how these models would facilitate a company in the country and business sector of your choice. Be sure to state your business sector. Then, explain how the IT diffusion m..

  What is probability that one of students will beliving

What is the probability that one of the students will beliving on campus given that he orshe is from out of state?

  Use demorgan law write the expression for the complement

Use DeMorgan's law write the expression for the complement.

  Marie program that will input a variable

To develop a MARIE program that will input a variable number of user entered Decimal whole number grades, validating each one (0-100) in a subroutine

  Decimal ascii number with an implied decimal point

Write a procedure named WriteScaled that outputs a decimal ASCII number with an implied decimal point.

  The two main forms of documentation

The two main forms of documentation of program design are flowcharts and pseudcode. Based on this week's text chapter and some relevant web resources, discuss the differences between flowcharts and pseudocode, as well as their merits and faults.

  How "direction" can be used in an effective publication?

What are four examples of how "direction" can be used in an effective publication?

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