Draw an ER diagram using MS Visio and upload the file in D2L. There is a shoe manufacturing company. The company has many customers. Customers have a unique customer ID and name and phone number. The company also offers many products. A product has a product ID, price and description. Customers can place orders but there are new customers who are yet to place orders. An order can be placed for one and only one product, by one and only one customer. But one product can appear in many orders. Orders have Order number, order date.

Draw an ER diagram using MS Visio and upload the file in D2L. There is a shoe manufacturing company. The company has many customers. Customers have a unique customer ID and name and phone number. The company also offers many products. A product has a product ID, price and description. Customers can place orders but there are new customers who are yet to place orders. An order can be placed for one and only one product, by one and only one customer. But one product can appear in many orders. Orders have Order number, order date.

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Many of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…
Draw UML class diagram according to descriptions given below. Please include appropriate labeling and multiplicity in your diagrams. You do not need to include the attributes and operations for the classes. A Rectangle object is composed of exactly four Line objects A Customer object is able to initiate zero or more Transaction A Student Object must enrolls in at least one, at most five Subject A Mouse object is kind of a Rodent A Rodent object is a kind of Mammal Object.
Create UML diagram for this: Layers of gasses are given, with certain type (ozone, oxygen, carbon dioxide) and thickness, affected by atmospheric variables (thunderstorm, sunshine, other effects). When a part of one layer changes into another layer due to an atmospheric variable, the newly transformed layer ascends and engrosses the first identical type of layer of gasses over it. In case there is no identical layer above, it creates a new layer on the top of the atmosphere. In the following we declare, how the different types of layers react to the different variables by changing their type and thickness. No layer can have a thickness less than 0.5 km, unless it ascends to the identical-type upper layer. In case there is no identical one, the layer perishes.
Please! can you help me doing Conceptual Analysis for this scenario. I have attached another screenshot to followup with data
Consider a model of an airport with planes, models of planes, a test of planes, and technicians. Draw an ER diagram to represent these entities and the following attributes.Planes have a unique registration number. Airplane Models are each identified by a model number (e.g. DC-80), and each has a capacity and a weight. A number of technicians work at the airport. You need to store for each the name, phone number, address, and salary. The airport has a number of tests that are used regularly to ensure that airplanes aresafe. Each test has a unique FAA number, a name, and a maximum possible score.Extend your ER diagram with relationships to represent the following information.(a) Each airplane is of one specific model.(b) Each technician is an expert on one or more plane models. His or her expertise may overlap with that of other technicians. (c) Transport Canada requires the airport to keep track of each time a given airplane is tested using a given test. For each testing event, the…
Question 1 Draw an activity Diagram in draw.io and screenshot it for me. Scenario (please alert is in Draw.io) Each semester the student will need to register the subjects that they need to take. The student needs to login to the system by inputting their student ID and password. The system uses that student ID to retrieve the intake of the student and based on their study plan, the system will display a list of subjects the student can register. The student can now click on the subject they wish to register. When the student is satisfied with the subjects chosen, the student will click the register button. The student may register more than 1 subject but the total credit hours for the subjects cannot exceed 20 credit hours. If it exceeds, the student has to choose all over again the subjects to register. If successfully registered, the student’s status in the system becomes “Active – Registered”. If the student does not register any subject for the semester, the status is…
Imagine that a piece of a primary key is also a potential secondary key. Can you tell me what your reaction would be?
Given the following UML diagram: Student - studentID: String + getStudentID(): String + toString(): String Person - lastName: String - firstName: String - dateOfBirth: Date - address: Address + getName(): String + getDOB(): Date + getAddress(): Address + toString(): String Professor - employeeID: String +getEmployelD(): String +toString(): String Write an implementation for the class Professor. DO NOT include or implement any constructor for this class. There are no abstract methods/classes in this example. toString method will return any simple String that contains firstName and employeelD only; no less, no more!! Assume firstName was defined as protected in class Person. You are not allowed to add implementation for any class or methods other than what is listed in the question statement.
3. Consider the following tables and then provide a pipe diagram for the requested output. ID Age ID Gender ID Name ID Friend_ID 15 3 M Bob 6. 3 31 F 6. Maria Sally George Maria 8 45 F 8 8 11 11 33 11 F 2 11 8 19 2 11 8 ... ... ... ... ... ... a. The average age of users b. The name of the user with the most friends. c. The pairs of user ID for those that follow one another (e.g., if 3 is a friend of 6 and 6 is a friend of 3 then (3, 6) would be listed as one of the pairs). d. The 10 most common names for users under the age of 20. 4. As discussed in class, what are some advantages of functional programming? 5. Explain how parallel programing can be accomplished using Streams and functional programming in Java 8. 6. What aspects of functional programming align well parallel programming?
Imagine that a piece of a primary key is also a potential secondary key. Can you tell me what your reaction would be?
You are asked to do some modelling development of a Bank accounts management system using the methods in lectures. The description of the system is as follows: This system provides the basic services to manage bank accounts at a bank called LUBank. LUBank has many branches, each of which has an address and branch number. A client opens accounts at a branch. Each account is uniquely identified by an account number; it has a balance and a credit or overdraft limit. There are many types of accounts, including: a mortgage account (which has a property as collateral), a checking account, and a credit card account (which has an expiry date and can have secondary cards attached to it). It is possible to have a joint account (e.g., for a husband and wife). Each type of account has a particular interest rate, a monthly fee, and a specific set of privileges (e.g. ability to write checks, insurance for purchases, etc.). LUBank is divided into divisions and subdivisions (such as Planning,…
Despite their importance, selection structures cannot complete the job on their own. All of us have to deal with the circumstance of having to repeat a succession of statements for various customers or transactions, or for online clients, at some point. To what extent do these jobs need certain types of frameworks? In what way are they different?