Use the ER-diagram to create a data dictionary. Use the following template: Raw Materials Raw Materials_Code...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Use the ER-diagram to create a data dictionary. Use the following template: Raw Materials Raw Materials_Code Raw Materials Description Raw Materials Price Table Raw Materials Purchase Orders Suppliers (Choose "N/A" whenever "Primary Key" or "Foreign Key" is not applicable.) Attribute Name Raw Materials_Code Raw Materials_Description Raw Materials_Price Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Raw Materials_Code Quantity_Purchased 00 Supplier_ID Supplier_Company Name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier_Phone Notes Purchase Orders Purchase_Order_ID Purchase Order_Date Purchase Employee_ID Supplier_ID Raw Materials Code Quantity_Purchased Raw Material Purchase Price Primary or Foreign Key? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y |N Required? Suppliers Supplier_ID Supplier Company_name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier Phone Notes Description Data Type numeric short text currency numeric date numeric numeric numeric numeric numeric short text short text short text short text numeric short text short text Default Value Next sequential number n/a n/a Next sequential number current date n/a n/a n/a n/a Next sequential number n/a n/a n/a n/a n/a n/a n/a Use the ER-diagram to create a data dictionary. Use the following template: Raw Materials Raw Materials_Code Raw Materials Description Raw Materials Price Table Raw Materials Purchase Orders Suppliers (Choose "N/A" whenever "Primary Key" or "Foreign Key" is not applicable.) Attribute Name Raw Materials_Code Raw Materials_Description Raw Materials_Price Purchase_Order_ID Purchase_Order_Date Purchase_Employee_ID Supplier_ID Raw Materials_Code Quantity_Purchased 00 Supplier_ID Supplier_Company Name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier_Phone Notes Purchase Orders Purchase_Order_ID Purchase Order_Date Purchase Employee_ID Supplier_ID Raw Materials Code Quantity_Purchased Raw Material Purchase Price Primary or Foreign Key? Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y |N Required? Suppliers Supplier_ID Supplier Company_name Supplier_Address Supplier_City Supplier_St Supplier Zip Supplier Phone Notes Description Data Type numeric short text currency numeric date numeric numeric numeric numeric numeric short text short text short text short text numeric short text short text Default Value Next sequential number n/a n/a Next sequential number current date n/a n/a n/a n/a Next sequential number n/a n/a n/a n/a n/a n/a n/a
Expert Answer:
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
Create a data dictionary similar to the metadata table shown in Table 1-1 in Chapter 1 to document your choices. For each table in the relational schema you developed earlier, provide the following...
-
Use the function VanillaCall defined in the chapter to create a Data Table in which you can see the relation between the number of runs incorporated in the function and the Black-Scholes value of a...
-
Suppose we would like to create a data structure for holding numbers that can be accessed either in the order that they were added or in sorted order. We need nodes having two references. If you...
-
For numbers a and b, determine which of the following expressions equals the given expression. (a) a + b (b) a b (c) b a (d) a b a + (b)
-
The Smiths are a low-income family with $10,000 available annually to spend on food and shelter. Food costs $2 per unit, and shelter costs $1 per square foot per year. The Smiths are currently...
-
Question 1 A university plans to build a new computer lab for its students for data analysis and simulation modelling. It has determined the number of computers needed each month for the next 12...
-
Pluto Corporation issued \(\$ 400,000\) of \(7 \%, 20\) year bonds payable on March 31, 2006. The bonds were issued at 100 and pay interest on March 31 and September 30. Record (a) issuance of the...
-
A tissue manufacturer that has the fourth-largest market share plans to experiment with a 50 off coupon during November and a buy one, get one free coupon during December. The experiment will take...
-
Example 15C: The final mark (Y) for a particular statistics course comprises of a 30% weighting for the class record and a 70% weighting for the examination. A student believes that she is equally...
-
Assistant police chief Todd Beck wants to analyze the citys historic crime data in order to better allocate police resources in the future. He collects data over the past two years. Each record in...
-
You have a balance of $926 on your credit card account. The minimum payment on your account is 2 percent of the most recent balance or $20, whichever is greater. What will be the minimum payment this...
-
Describe the process of genomic imprinting and discuss how disruptions in imprinting patterns can lead to disorders such as Prader-Willi syndrome or Angelman syndrome.
-
The following transactions occurred during March 2024 for the Right Corporation. The company operates a wholesale warehouse. 1. Issued 34,000 shares of no-par common stock in exchange for $340,000 in...
-
Stormy Camping Supply sells tents. The company has the following income statement. Sales ($1,000 per unit) $200,000 Less Cost of Goods sold ($475 per unit) 95,000 Gross margin 105,000 Less Operating...
-
In Module 2, we discussed how accounting-based balance sheets don't represent the true value of a company. We discussed Facebook's balance sheet based on book values... Facebook Balance Sheet ASSETS...
-
Take-Home Exercise #5 Use the GPVC.accdb database to develop the following queries. Make sure to view the SQL version of your QBE query to become familiar with SQL for your upcoming exam....
-
39. What is the biggest problem of using government actions such as taxes and emission charges to control external costs? a. insufficient legal power to enforce the controls b. obtaining enough data...
-
Chris Zulliger was a chef at the Plaza Restaurant in the Snowbird Ski Resort in Utah. The restaurant is located at the base of a mountain. As a chef for the Plaza, Zulliger was instructed by his...
-
List and describe four common types of database failure.
-
Reread the definitions for data and database in this chapter. Database management systems only recently began to include the capability to store and retrieve more than numeric and textual data. What...
-
When a student has not chosen a major at a university, the university often enters a value of "Undecided" for the major field. Is "Undecided" a way to represent the null value? Should it be used as a...
-
Tavistuck Inc. uses a perpectual inventory system. Tavistock has these account balances at December 31, 2020, prior to making the year-end adjustments: A year ago, the net realizable value of...
-
Suppose a Johnson store in Ottawa, Ontario, ended November 2020 with 800,000 units of merchandise that cost an average of \(\$ 8\) each. Suppose the store then sold 600,000 units for \(\$ 5.0\)...
-
Suppose a company you are considering as an investment made sales of \(\$ 54.8\) billion in the year ended December 31, 2020. Collections from customers totalled \(\$ 55\) billion. The company began...
Study smarter with the SolutionInn App