Use the following two user views for phase 2 of the project. Your task is as...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the following two user views for phase 2 of the project. Your task is as follows: 1- Convert each local conceptual design to logical 2- Produce the global logical design The ERDS may contain some mistakes. Details and restrictions will be added soon. User view 1: Online Customer buying products addedBy Categoryld Address Name Userid User included in Category UserName Password belongs To Cartid Has Shopping Cart ownedBy DateCreated Percentage StartDate Discount ReducedPrice Mailing Address OrderDate EndDate Billing Address Product addedTo Contains Order OrderAmount Price Productid Name Quantity Date Added OrderNo FirstName Empld User view 2: Sales/Data Manager who is keeping track of purchases (inventory) Supplierld Name LastName Employee SupplierName Supplier sentTo Paid Payment Date Orderid Role Has Order OrderDate Installment installment Date RoleDescript Roleld Installment Amount ProductName User Approves Contains Product Product Category UserName Password Price Quantity Productid Use the following two user views for phase 2 of the project. Your task is as follows: 1- Convert each local conceptual design to logical 2- Produce the global logical design The ERDS may contain some mistakes. Details and restrictions will be added soon. User view 1: Online Customer buying products addedBy Categoryld Address Name Userid User included in Category UserName Password belongs To Cartid Has Shopping Cart ownedBy DateCreated Percentage StartDate Discount ReducedPrice Mailing Address OrderDate EndDate Billing Address Product addedTo Contains Order OrderAmount Price Productid Name Quantity Date Added OrderNo FirstName Empld User view 2: Sales/Data Manager who is keeping track of purchases (inventory) Supplierld Name LastName Employee SupplierName Supplier sentTo Paid Payment Date Orderid Role Has Order OrderDate Installment installment Date RoleDescript Roleld Installment Amount ProductName User Approves Contains Product Product Category UserName Password Price Quantity Productid
Expert Answer:
Answer rating: 100% (QA)
Step1 Im ready to assist with converting the ERDs to Crows Foot notation addressing the identified i... View the full answer
Related Book For
Principles of Operations Management Sustainability and Supply Chain Management
ISBN: 978-0134181981
10th edition
Authors: Jay Heizer, Barry Render, Chuck Munson
Posted Date:
Students also viewed these programming questions
-
Critique the subject area of "Technopoly" and its most critical points in Neil Postman's book, Technolopy: The surrender of culture to technology. Please place quotation mark around what is...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
(4) (1.5 pts) A Delta flight from ATL to PUJ (Punta Cana, Dominican Republic) has a capacity of 100 passengers and fills up quickly for the Thanksgiving holiday. Delta does not want any seats to be...
-
An air-filled X-band rectangular waveguide has dimensions a = 2.286 cm and b = 1.016 cm. If the waveguide has copper walls ( = o , = o , = 5.8 x 10 7 S/m), find the attenuation in dB/m due to the...
-
The following trial balance was prepared from the books of Cross Corporation at its year-end, December 31, 2015. After the company's bookkeeper left, the office staff was unable to balance the...
-
The Focus Problem at the beginning of this chapter asks you to use a sign test with a 5% level of significance to test the claim that the overall temperature distribution of Madison, Wisconsin, is...
-
Kigga Corporation issued $2,000,000 in 10.5 percent, ten-year bonds on February 1, 20x7, at 104. Semiannual interest payment dates are January 31 and July 31. Use the straight-line method and ignore...
-
The Bakery produces cupcakes. It uses a process costing system. In March, its beginning inventory was 450 units, which were 100 percent complete for direct materials costs and 10 percent complete for...
-
The Foundational 1 5 ( Algo ) [ LO 7 - 1 , LO 7 - 2 , LO 7 - 3 , LO 7 - 4 , LO 7 - 5 ] [ The following information applies to the questions displayed below. ] Diego Company manufactures one product...
-
By the year 2021, the European Union will have a database of fingerprints, photographs for facial recognition, passport numbers and birth dates of all its 350 million citizens. Data that are...
-
Your company has purchased a large new trucktractor for over-the-road use (asset class 00.26). It has a cost basis of $174,000. With additional options costing $13,000, the cost basis for...
-
Starfish T-shirts makes trendy t-shirts and sells them for $10 per t-shirt. Trends change fast in this industry. Recently, the sales manager decided that the company should make a final batch of...
-
DE ENGLISH (CANADA Question: ABC Co. deducted $988.00 for QPIP on insurable earnings of $200,000 Calculate total QPIP remittance to RQ.
-
You are running a major tech company, Technology Innovation Inc. ( TIC ) , and are thinking about investing in electric vehicles ( EV ) through a new solely owned start - up , TIC 2 . The new...
-
There is about a 1 in 45,000 probability that the potentially hazardous asteroid named Apophis will impact Earth in 2036. Based on observations, the asteroid is estimated to have a mass of 2.1 1010...
-
1. On the CIA World Factbook website it says that the world population increases by about 1% each year. This means that the population multiplies by 1.01 each year. There are currently about 7...
-
Q.) Which of the following statements is FALSE? Multiple Choice O High-low method chooses the highest and lowest levels of activity. Both High-low method and Least-squares regression method assume...
-
Orange juice producers are dismayed and puzzled. An economist told them that the reason the demand for orange juice fell is that a new technology allow tomato producers to pick ripe tomatoes more...
-
Bryant Electronics produces short runs of battery-powered pocket lanterns. You have been asked to reduce inventory by introducing a kanban system. After several hours of analysis you have developed...
-
Southwestern University (SWU), a large state college in Stephenville, Texas, enrolls close to 20,000 students. The school is a dominant force in the small city, with more students during fall and...
-
Exponential smoothing is used to forecast automobile battery sales. Two value of are examined, = 0.8 and = 0.5. Evaluate the accuracy of each smoothing constant. Which is preferable? (Assume the...
-
Service firm joint costing Graves Learning Services provides a learning service center to students who want to improve their academic performance. The four service programs currently offered are...
-
Joint product decisions The Pearly Waters Perfume Company manufactures various qualities of perfumes and colognes. One popular line of colognes includes three products that result from a joint...
-
Joint product decision analysis The Maplewood Products Company manufactures three wood treatment products in a joint production process. Each product has certain finish and preservative properties...
Study smarter with the SolutionInn App