Write SQL statements to create tables. Implement all related data integrity constraints. For each column, use the
Fantastic news! We've Found the answer you've been seeking!
Question:
Write SQL statements to create tables. Implement all related data integrity constraints. For each column, use the data type as you think appropriate. Declare all integritgtr constraint at the table level.
Transcribed Image Text:
Business rule • A product line may (may not) produce a product. Each product is produced in one product line. • A product line is assigned more than one employee. An employee may (may not) be assigned to a product line. • A product may (may not) be a component of another product. • Minimum quantity of product is 100. The quantity on hand cannot be below 100. The line name in the PRODUCT LINE table and the product name in the PRODUCT table should be distinct. • PRODUCT LINE LineID: UID LineName Location is assigned EMPLOYEE Salary Phone is assigned to EmpID: UID FirstName LastName HirsDate produces PRODUCT ProdNo: UID ProdName Category Size is produced in Price QtyOnHand is composed of is composed of Business rule • A product line may (may not) produce a product. Each product is produced in one product line. • A product line is assigned more than one employee. An employee may (may not) be assigned to a product line. • A product may (may not) be a component of another product. • Minimum quantity of product is 100. The quantity on hand cannot be below 100. The line name in the PRODUCT LINE table and the product name in the PRODUCT table should be distinct. • PRODUCT LINE LineID: UID LineName Location is assigned EMPLOYEE Salary Phone is assigned to EmpID: UID FirstName LastName HirsDate produces PRODUCT ProdNo: UID ProdName Category Size is produced in Price QtyOnHand is composed of is composed of
Expert Answer:
Answer rating: 100% (QA)
Based on the provided business rules and the entityrelationship diagram ERD we can write the SQL statements to create the tables for the PRODUCTLINE P... View the full answer
Related Book For
Data Modeling and Database Design
ISBN: 978-1285085258
2nd edition
Authors: Narayan S. Umanath, Richard W. Scammel
Posted Date:
Students also viewed these databases questions
-
Changing circumstances and ongoing managerial efforts to improve the strategy account for why a company's strategy evolves over time and why the task of crafting a company's strategy is a work in...
-
There is an XYZ Company, which purchases some parts from vendors to produce some products. It has several departments, marketing sites, and parts supply vendors in the company. 1) For each...
-
ConAir (CA) commercial airlines company requires you experience in database design and have approached you to assist in the design of their new airline database system. They urgently need to have...
-
As mentioned in Section 5.6, Sainte-Venants principle will allow particular boundary conditions to be replaced by their statically equivalent resultant. For problems (b), (c), (d),and (f) in Exercise...
-
Suppose your vehicle is licensed in a state that issues license plates that consist of three digits (between 0 and 9) followed by three letters (between A and Z). If a license number is selected...
-
Identify the weaknesses in PHC's inventory-taking procedures. What implications did those weaknesses have for the two teams of auditors?
-
A marine location marker is a smoke-producing device usually dropped from an airplane and used to mark a reference point in the ocean. One is being tested in a wind tunnel to determine the drag force...
-
The following are a number of scenarios that might constitute a violation of the Code of Professional Conduct. Required For each of the following situations, identify whether it involves a violation...
-
3. Andy is retiring as the morning shift supervisor at a candy factory. The manager is considering Bill, Charlie, Lisa, or Mindy to replace him. The factory workers are asked to rank the candidates....
-
Determine the shear force and moment acting at point C of the beam. For the calculation use Simpsons rule to evaluate the integrals. W 2 kip/ft ' W = 1/2 (2x +x + 4) 2 ft C 2 ft 11.58 kip/ft B X
-
Statute defines the maximum amount of qualified wages that are Work Opportunity Tax Credit (WOTC)-eligible for each eligible population. For example, the maximum eligible wages for a qualified...
-
QUESTION 1 (70 marks) The Lion Group of companies is listed on the JSE. They are a diverse group of companies situated all over Africa. The financial year-end of the Lion Group is 31 December. The...
-
Problem 5: Constitutional isomers are compounds that possess the same molecular formula but have different connectivity of various atoms. An abbreviated representation of an alcohol with the formula...
-
SMU Corp recently became public. Since SMU has only been a public company for a short while, you do not have an accurate assessment of SMU's equity beta (Be). Mustang Corp is an otherwise identical...
-
OBJECTIVE: The objective of this assignment is to: Analyze business letters for effective use of information. Use the correct words in communicating ideas and information. Thus, you will develop your...
-
(a) (b) (c) Consider the following dataset. Gender Car Type Shirt Size Class label M M M M F F F M M M Family Sports Sports Sports Sports Sports M F F F Luxury Family Family Family Luxury Luxury...
-
Harry Homeowner and his wife Happy (the Homeowners) decide to renovate their house after 15 years. They hire Reckless Ruins, Inc. (RRI), a general contractor, to perform the work. RRI is not...
-
a. Why does the Wi-Fi Alliance release compatibility testing profiles in waves instead of combining the entire standards features initially? 27a1.) An 802.11ac Wi-Fi compatibility testing profile...
-
What is the difference between F, F+, and Fc?
-
Consider the following Presentation Layer ER diagram. a. Identify all entity types that at one time or another function as a superclass. b. List the superclass entity type and subclass entity type(s)...
-
Describe the structure of the ANSI/SPARC three-schema architecture. Compare this structure with that of the two-schema architecture inherent in a file-processing system.
-
The United States brought a lawsuit requesting forfeiture of a \($38.5\) million jet purchased by Teodoro Nguema Obiang Mangue (Nguema) because the government believed the jet had been purchased with...
-
Jose Medellin participated in the rape and murder of two teenage girls in Houston, Texas. He was arrested and read his Miranda rights, and he confessed. At the time, he was not informed that he could...
-
OBB Personenverkehr (OBB), the Austrian state-owned railway, carries about 235 million passengers a year on routes within wholly owned by OBB Holding Group, which in turn, is wholly owned by the...
Study smarter with the SolutionInn App