Part-1 (8 Marks) Part a:- Create database tables in your designated section with appropriate relationships(5 Marks):-...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Part-1 (8 Marks) Part a:- Create database tables in your designated section with appropriate relationships(5 Marks):- ORDER Order D OrderDate ORDER LINE Order D ProductID OrderedQuantity PRODUCT ProductID Product Description ProductFinish ProductStandard Price ProductLinelD Make sure to pick right datatype for each column considering what kind of input you are expecting in that column as per real world needs. Following constraints should be satisfied: - a. OrderID and ProductID ORDERLINE table is a composite and foreign key. b. OrderDate in ORDER table should not be empty. c. OrderQuantity in OrderLine table should always be >0 d. ProductStandard Price in PRODUCT table should be >=0.0 Part b. (3 Marks) a. Issue command to new a new column - ProductColor in Product table without dropping the table. b. Issue command to drop column ProductColor from Product table which you just created in above steps. c. What will be the output for the following command Considering there are some records in the Orderline table; - I Update OrderLine set OrderedQuantity=-1; Part-2 (3 Marks) Insert minimum 2 products, 2 orders and 2 rows in OrderLine table with any values of your choice. Part-3 (2 Marks) Issue command to delete complete data from products table and observe the output and explain the reason for the output. Once you are done paste commands and output screenshots both on word document and upload the word document. One document would be enough for all screenshots. Part-1 (8 Marks) Part a:- Create database tables in your designated section with appropriate relationships(5 Marks):- ORDER Order D OrderDate ORDER LINE Order D ProductID OrderedQuantity PRODUCT ProductID Product Description ProductFinish ProductStandard Price ProductLinelD Make sure to pick right datatype for each column considering what kind of input you are expecting in that column as per real world needs. Following constraints should be satisfied: - a. OrderID and ProductID ORDERLINE table is a composite and foreign key. b. OrderDate in ORDER table should not be empty. c. OrderQuantity in OrderLine table should always be >0 d. ProductStandard Price in PRODUCT table should be >=0.0 Part b. (3 Marks) a. Issue command to new a new column - ProductColor in Product table without dropping the table. b. Issue command to drop column ProductColor from Product table which you just created in above steps. c. What will be the output for the following command Considering there are some records in the Orderline table; - I Update OrderLine set OrderedQuantity=-1; Part-2 (3 Marks) Insert minimum 2 products, 2 orders and 2 rows in OrderLine table with any values of your choice. Part-3 (2 Marks) Issue command to delete complete data from products table and observe the output and explain the reason for the output. Once you are done paste commands and output screenshots both on word document and upload the word document. One document would be enough for all screenshots.
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided in the images heres how you can create database tables for ORDER ORDERLINE and PRODUCT insert data into these tables and perform certain SQL commands as specified Par... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Why must managers be able to analyze financial statements when there is already an accountant for the company?
-
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...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Prove that point B in Figure 18.1 is not Pareto effi cient. Food Fo FB OA Abner E C B Contract curve UAB UBB MB -Medicine Z Belinda Mo Figure 18.1 Edgeworth Box for Exchange; Pareto Efficient Points...
-
What is one purpose of the linear correlation coefficient?
-
The model of a second-order system is given as \[4 \ddot{x}+4 \dot{x}+\frac{5}{4} x=0, \quad x(0)=0.5, \quad \dot{x}(0)=-1\] a. Identify the damping type and express the response \(x(t)\) in closed...
-
Question: For three weeks in a row, Peyton wrote a check to his yoga instructor, Eli. Unfortunately, each week Eli changed the amount of the check from $50 to $150 before depositing it. Because of...
-
Case Inc. is a construction company specializing in custom patios. The patios are constructed of concrete, brick, fiberglass, and lumber, depending upon customer preference. On June 1, 2017, the...
-
Question #1 Is a current account deficit something to worry about? If a government wants to correct a current account deficit, why can't it simply enforce restrictions on imports? Maybe Mr.Trump...
-
Modify the sentence-generator program of Case Study so that it inputs its vocabulary from a set of text files at startup. The filenames are nouns.txt, verbs. txt, articles.txt, and prepositions.txt....
-
Hartley, Inc. needs to purchase equipment for its 2,000 drive-ins nationwide. The total cost of the equipment is $2 million. It is estimated that the aftertax cash infows from the project will be...
-
As part of a quality-assurance program being initiated by Community Hospital, each vice president personally interviewed every staff member under his or her jurisdiction to determine what actions...
-
Reinforced concrete is a popular building material used in Singapore's built environment. It is commonly used in all local developments, buildings, and infrastructure, for the construction of their...
-
out2. Consider the following truth table for a circuit with inputs a, b, and c and outputs out1 and a atata 0 0 0 0 b cout1 out2 SO 0 ol 1 1 1 0 0 1 0 1 1 1 1 1 0 oto 0 1 1 0 0 1 0 1 0 1 1 0 0 1 0 1...
-
This week we will be utilizing technology in more depth to complete our assignment. I need an idea for a PowerPoint presentation which will either propose a CHANGE an Internet policy, OR propose a...
-
You are a lead IT auditor conducting an assessment of a mid - sized financial institution\'s IT governance framework. During your review, you discover that the organization has recently implemented...
-
An employee is given a $10,000 interest free loan from an employer on January 1 to purchase an automobile to be used for employment purposes. Due to a serious illness, the automobile is only used for...
-
Discuss the concept of the looking-glass self. how do you think others perceive you? do you think most people perceive you correctly?
-
In the last chapter you modified some queries for the Wine Depot. Now Barbara would like you to help her create some new forms. Make the following changes for Barbara using the chl l-04_student_name...
-
Open the report created in Assignment 2. Change the title of the report to Products by Buyer. Add lines to separate each buyer. Add a line above the grand total amount. Save the new report as Ch 13...
-
Modify the Products form by changing the Buyer ID text box control to a combo box control, listing the choices of Buyer ID and Buyer Name from the Buyers table. Be sure to first remove the...
-
List some tax advantages of retirement investing.
-
Go to the Web site of Yahoo! Finance (http://finance.yahoo.com). Enter the ticker symbol for Home Depot (HD) and Lowes (LOW). For each firm, click on Profile and note the ratio for Profit Margin (the...
-
Describe why you should itemize deductions as opposed to taking the standard deduction.
Study smarter with the SolutionInn App