Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID. Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID. Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID. Create a new database with the name Lab08Exercise. Use Lab08Exercise to accomplish the below tasks. Create a table Faculty based on the following chart: Data type Constraints INT (6) Primary Key Last Name Varchar(15) First Name Varchar(15) Dept Char(3) Column Faculty_id Not NULL Dept Code Dept Name Not NULL Create a table Dept based on the following chart: Column Data type Char (3) Varchar(20) Constraints Primary Key Not NULL Add a new column Location to Dept table which has data type Char(7). Add a new FOREIGN KEY constraint to column Dept on table Faculty that refers to the column Dept Code on table Dept. Add ON DELETE CASCADE option. Increase Last Name column to 25 characters long Remove the column Location (the one added in Task #3 above) from Dept. Create a table course based on the following chart: Column Data type Constraints course Code Char (3) Primary Key course Name Varchar(20) Not NULL ). Add a new column Instructor_ID to course which has data type corresponding to Faculty. Faculty_ID . Add a new FOREIGN KEY constraint (named faculty_course_fk) to course Instructor_ID that refers to the column Faculty. Faculty_ID.
Expert Answer:
Answer rating: 100% (QA)
It appears that youre trying to create tables for a database with specific constraints and relations... 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
-
3. What is stored in numList after the following code executes? (15 Points) int numList[6] = {25, 37, 62, 78, 92, 13}; int *listPtr = numList; int *temp = listPtr + 2; int num; *listPtr = *(listPtr +...
-
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...
-
This assignment reviews object-oriented programming concepts such as classes, methods, constructors, accessor methods, and access modifiers. It makes use of an array of objects as a class data...
-
The following is the documentation of the payroll cycle at McQuarrie Enterprises, a ladies clothing wholesaler. There are approximately 50 staff members at McQuarrie Enterprises. Every employee has a...
-
According to the information given in Fig. 7-3, is little-sister.cs.vu.nl on a class A, B, or C network?
-
Brite-Lite Bulbs has an equity multiplier of 3.2. The company's assets are financed with some combination of long-term debt and common equity. What is the company's debt ratio?
-
Derive the first two equations of Equation 2.44. Q11=U+U cos 20+ U3 cos 40 Q12 U4-U3 cos 40 Q22 2=U-U cos 20+ U3 cos 40 U2 Q16 sin 20+ U3 sin 40 2 us Q26 sin 20-U3 sin 40 2 Q66 = (U-U4)-U3 cos 40...
-
At year-end, the price-earnings ratio of General Motors was 11.3, and the price-earnings ratio of Microsoft was 28.14. Which company did the stock market favor? Explain.
-
1: Explain what elasticity of demand means. Support your explanation with a suitable example. 2: Describe the relationship between elasticity of demand and revenue when the prices are changed. 3:...
-
Sue and Dave always spend their evenings together, either cycling or playing computer games. On an evening with good weather, the probability that Sue prefers cycling is 0.7 and for Dave it is 0.4....
-
For the function f(x) given in the table, find the average Pate of change over each specified interval. 2 2.5 3 3.8 4 (x) 23 20 24 19 16 15 30 (a) [2, 5) (b) [3.8, 4]
-
14. What are the four basic differences between TCP and UDP TCP UDP
-
Consider the following two projects: Project Year 1 Year 2 Year 0 Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow Year 3 Year 4 Discount Rate A B - 100 -73 40 30 50 60 N/A 0.13 30 30 30 0.13 The...
-
Master Onion Corporation has a target capital structure of 40 percent common stock, 10 percent preferred stock, and 50 percent debt. Its cost of equity is 15 percent, the cost of preferred stock is 7...
-
If Lucky earned an interest of Php 1.912.50 for investing, Php 9.000 in CAS canteen for 2 years and 6 months, what is the rate of interest?
-
Tesla Brothers is expected to pay a $1.50 a share annual dividend next year. Dividends are expected to increase by 2.5 percent annually. What is one share of this stock worth to you today if your...
-
On June 30, Sharper Corporation's stockholders' equity section of its balance sheet appears as follows before any stock dividend or split. Sharper declares and immediately distributes a 50% stock...
-
What is the difference between the straight-line method of depreciation and the written down value method? Which method is more appropriate for reporting earnings?
-
Why is system availability an advantage in a distributed database?
-
What is the difference between a file server and a client/server system?
-
Assume the same scenario as that given in Question 13 but replace CourseNum and Description with Advisor- Num, LastName, and FirstName as shown. Advisor refers to the advisor responsible for the...
-
Action Quest Games adjusts its accounts annually. The following information is available for the year ended December 31, 2025. 1. Purchased a 1-year insurance policy on June 1 for $1,800 cash. 2....
-
With each pass of a comet about the Sun, the comets mass (a) remains virtually unchanged. (b) actually increases. (c) is appreciably reduced.
-
Why is carbon such a special atom?
Study smarter with the SolutionInn App