Using the SQL*Plus describe commands given below, define the referential integrity constraints associated with the Cab...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using the SQL*Plus describe commands given below, define the referential integrity constraints associated with the Cab Project. You may also want to refer to the ER diagram on the second page. SQL> desc cab Name CA CABNUM CA MAKE CA MODEL CA YEAR CA PURDATE CA LICNUM CA CONDITION CA CABSTATUS CA_FUELCAPACITY CA BASEFARE CA MILEAGECHARGE SQL> desc driver Name DR DRVNUM DR DRVNAME DR DRVSTREET DR DRVCITY DR DRVSTATE DR DRVZIP DR DRVPHONE DR ORVLIC DR DRVLICDATE DR DRVSTATUS DR BRTHDATE DR JOBCODE DR SALARY DR HIREDATE SQL desc shift Name A Referential Integrity Opportunity That Involves the CAB Project SH_WKDATE SH WKSHIFT SH_CARNUM SH DRVNUM SH WKFLAG SH ODMROGI SH_ODOMROG2 SH NUMFARES SQLX Nud? Type NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(10) NOT NULL VARCHAR2(15) NOT MALL VARCHAR2(2) NOT NULL DATE NOT NULL VARCHAR2(8) NOT NULL VARCHAR2(38) NOT NULL VARCHAR2(1) NOT NULL VARCHAR2(5) NOT NULL NUMBER NOT NULL NUMBER Mull? Type NOT NULL VARCHAR2(4) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(15) NOT NULL VARCHAR2(2) NOT NULL VARCHAR2(5) NOT NULL VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL DATE NOT NULL VARCHAR2(20) NOT NULL DATE NOT NULL NUMBER NOT NULL NUMBER NOT NULL DATE Null? Type NOT NULL DATE NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(4) VARCHAR2(1) NUMBER NUMBER NUMBER SQL> desc maintain Name MA CANUM MA MAINDATE MA MAINTYPE MA_MAINODOM MA COST MA LASTDRVNUM SQL> desc incident Nane IC CABNUM IC WKDATE IC WKSHIFT IC INCITYPE IC DETAILS SQL dese qualification Nane QU DRVNUM QU CABNUM SQL> desc fueluse Name FUL CANUM FUL FUELDATE FUL_NUMGAL FUL FUELCODE FUL_PRICEGAL FUL FUELBRAND SQL> Null? Type NOT NULL VARCHAR2(3) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NUMBER NOT NULL NUMBER (10,2) NOT NULL VARCHAR2(4) Null? Type NOT NULL VARCHAR2(3) DATE VARCHAR2(3) NOT NULL VARCHAR2(15) VARCHAR2(200) Null? Type NOT NULL VARCHAR2(4) NOT NULL VARCHAR2(3) Null? Type NOT NULL VARCHAR2(3) NOT NULL DATE NOT NULL NUMBER NOT NULL VARCHAR2(1) NOT NULL NUMBER (6,2) NOT NULL VARCHAR2(10) Undergoes (0,n) CAB (0,n) Makes use (1,1) FUELUSE (0,n) (1,1) Qual_cab (0,n) Driven_on (1.1) (1.1) MAINTAIN QUALIFICATION SHIFT (0,n) Involved in (1.1) INCIDENT (1.1) (1,1) Qual_driver (1.1) (0,n) Drives (0,n) Brings in (0,n) DRIVER Using the SQL*Plus describe commands given below, define the referential integrity constraints associated with the Cab Project. You may also want to refer to the ER diagram on the second page. SQL> desc cab Name CA CABNUM CA MAKE CA MODEL CA YEAR CA PURDATE CA LICNUM CA CONDITION CA CABSTATUS CA_FUELCAPACITY CA BASEFARE CA MILEAGECHARGE SQL> desc driver Name DR DRVNUM DR DRVNAME DR DRVSTREET DR DRVCITY DR DRVSTATE DR DRVZIP DR DRVPHONE DR ORVLIC DR DRVLICDATE DR DRVSTATUS DR BRTHDATE DR JOBCODE DR SALARY DR HIREDATE SQL desc shift Name A Referential Integrity Opportunity That Involves the CAB Project SH_WKDATE SH WKSHIFT SH_CARNUM SH DRVNUM SH WKFLAG SH ODMROGI SH_ODOMROG2 SH NUMFARES SQLX Nud? Type NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(10) NOT NULL VARCHAR2(15) NOT MALL VARCHAR2(2) NOT NULL DATE NOT NULL VARCHAR2(8) NOT NULL VARCHAR2(38) NOT NULL VARCHAR2(1) NOT NULL VARCHAR2(5) NOT NULL NUMBER NOT NULL NUMBER Mull? Type NOT NULL VARCHAR2(4) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(30) NOT NULL VARCHAR2(15) NOT NULL VARCHAR2(2) NOT NULL VARCHAR2(5) NOT NULL VARCHAR2(10) NOT NULL VARCHAR2(10) NOT NULL DATE NOT NULL VARCHAR2(20) NOT NULL DATE NOT NULL NUMBER NOT NULL NUMBER NOT NULL DATE Null? Type NOT NULL DATE NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(3) NOT NULL VARCHAR2(4) VARCHAR2(1) NUMBER NUMBER NUMBER SQL> desc maintain Name MA CANUM MA MAINDATE MA MAINTYPE MA_MAINODOM MA COST MA LASTDRVNUM SQL> desc incident Nane IC CABNUM IC WKDATE IC WKSHIFT IC INCITYPE IC DETAILS SQL dese qualification Nane QU DRVNUM QU CABNUM SQL> desc fueluse Name FUL CANUM FUL FUELDATE FUL_NUMGAL FUL FUELCODE FUL_PRICEGAL FUL FUELBRAND SQL> Null? Type NOT NULL VARCHAR2(3) NOT NULL DATE NOT NULL VARCHAR2(30) NOT NULL NUMBER NOT NULL NUMBER (10,2) NOT NULL VARCHAR2(4) Null? Type NOT NULL VARCHAR2(3) DATE VARCHAR2(3) NOT NULL VARCHAR2(15) VARCHAR2(200) Null? Type NOT NULL VARCHAR2(4) NOT NULL VARCHAR2(3) Null? Type NOT NULL VARCHAR2(3) NOT NULL DATE NOT NULL NUMBER NOT NULL VARCHAR2(1) NOT NULL NUMBER (6,2) NOT NULL VARCHAR2(10) Undergoes (0,n) CAB (0,n) Makes use (1,1) FUELUSE (0,n) (1,1) Qual_cab (0,n) Driven_on (1.1) (1.1) MAINTAIN QUALIFICATION SHIFT (0,n) Involved in (1.1) INCIDENT (1.1) (1,1) Qual_driver (1.1) (0,n) Drives (0,n) Brings in (0,n) DRIVER
Expert Answer:
Answer rating: 100% (QA)
It appears that youd like to define referential integrity constraints for a database that involves the Cab Project based on the ER diagram and tables ... View the full answer
Related Book For
Concepts of Database Management
ISBN: 978-1285427102
8th edition
Authors: Philip J. Pratt, Mary Z. Last
Posted Date:
Students also viewed these databases questions
-
The gross profit on beginning inventory of merchandise sales from the subsidiary to the parent needs to be Deducted from the income distribution schedule of the subsidiary Added to the income...
-
The project should be based on the most recently published Annual Report and should cover a three (minimum) to five (maximum) year period. Each student must work on a different company Perspective (5...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
A $250 suit is on sale for $190, and a $90 pair of shoes is on sale for $65. Find the average percent decrease in price for the 2 items.
-
The intensity of the Sun's light in the vicinity of the Earth is about 1350 W/m2. Imagine a spacecraft with a mirrored square sail of dimension 1.0 km. Estimate how much thrust (in newtons) this...
-
Kaisers installs a new milkshake machine that increases labor productivity. If the price of a milkshake remains at $4, does Kaisers change the number of workers it hires? Explain. Kaisers Ice Cream...
-
J Evans has kept records of his business transactions in a single entry form, but he did not realise that he had to record cash drawings. His bank account for the year 19X8 is as follows: Records of...
-
Following are transactions and events of the General Fund of the City of Springfield for the fiscal year ended December 31, 2012. 1. Estimated revenues (legally budgeted) Property taxes .........
-
1. On January 1, 2015 Whitney Sports acquired the local broadcast rights of the 2021 Homecoming Games slated on December 28, 2021 for P15,000,000. Management expects that Homecoming Games related...
-
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...
-
Lebel Corporation has the following capital structure at the beginning of the year: Preferred shares, $3, no par value, 20,000 shares authorized, 6,000 shares issued and outstanding $ 300,000 Common...
-
How would you fix Social Security to allow it to continue as a viable retirement program? Would you raise the retirement age? Would you lower the benefit level? Are there any other options to make...
-
Based on the high cost of the average benefits package, what would you do if you were the manager in charge of figuring out how to cut benefit costs in your company? Remember that you want to meet...
-
Briefly describe a job you have or had. (If you havent had a job, think of someone you know well.) If you were to be promoted, which training method(s) would you use to train the person to do your...
-
You are the external auditor for Centnet Pty. Ltd., a public electronic funds transfer network that operates switches in the capital cities of all states in Australia. Because Centnet has a large...
-
To provide more extensive services to their customers, financial institutions in some countries are becoming increasingly involved in using interchange network facilities. In an interchange network...
-
Bowen & Bowen's quality assurance officers are tasked to input data into the company's AIS, which produces a monthly report of the number of defects in each assembly line. This is an example of...
-
Saccharin is an artificial sweetener that is used in diet beverages. In order for it to be metabolized by the body, it must pass into cells. Below are shown the two forms of saccharin. Saccharin has...
-
The requirements shown in Question 11 have changed. The dentists office would like to add the date of the patients last payment. In which relation (table) would you place this attribute? Why? Data...
-
Why is increased efficiency an advantage in a distributed database?
-
How do you create a one-to-many relationship in a database system?
-
What is meant by refunding?
-
The Merton Manufacturing Co Ltd has been in business for many years making fitted furniture and chairs. During 2004 and 2005 substantial losses have been sustained on the manufacture of chairs and...
-
A company retired a bond issue early, at a loss. Is the company in an economically worse position after the retirement?
Study smarter with the SolutionInn App