3. Using the data information provided in the next 3 slides, implement the schema using Transact...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. Using the data information provided in the next 3 slides, implement the schema using Transact SQL (show SQL statements for each table). Implement the constraints as well. Data information for Question 3 tblLevels O O tblPool O O O O tblStaff O O O O Level - auto increment PK ClassName - text 20 - nulls are not allowed O O Pool - auto increment PK PoolName - text 20 nulls are not allowed Location text 30 StaffID - auto increment PK FirstName text 20 Middlelnitial - text 3 LastName - text 30 Suffix text 3 Salaried - bit PayAmount - numeric Data information for Question 3 tblClasses O LessonIndex - auto increment PK Level Integer FK SectionID - Integer Semester - TinyInt O O O O O O O O O O tblEnrollment O LessonIndex - Integer FK SID - Integer FK (LessonIndex and SID) Primary Key Status - text 30 Charged - bit O AmountPaid numeric O DateEnrolled - datetime O O O Data information for Question 3 O tblStudents O O O Days - text 20 Time - datetime (formatted for time) O Pool - Integer FK Instructor - Integer FK Limit - TinyInt Enrolled - TinyInt Price - numeric O O O SID - auto increment PK FirstName - text 20 Middlelnitial - text 3 LastName - text 30 Suffix - text 3 Birthday - datetime LocalStreet - text 30 LocalCity - text 20 3. Using the data information provided in the next 3 slides, implement the schema using Transact SQL (show SQL statements for each table). Implement the constraints as well. Data information for Question 3 tblLevels O O tblPool O O O O tblStaff O O O O Level - auto increment PK ClassName - text 20 - nulls are not allowed O O Pool - auto increment PK PoolName - text 20 nulls are not allowed Location text 30 StaffID - auto increment PK FirstName text 20 Middlelnitial - text 3 LastName - text 30 Suffix text 3 Salaried - bit PayAmount - numeric Data information for Question 3 tblClasses O LessonIndex - auto increment PK Level Integer FK SectionID - Integer Semester - TinyInt O O O O O O O O O O tblEnrollment O LessonIndex - Integer FK SID - Integer FK (LessonIndex and SID) Primary Key Status - text 30 Charged - bit O AmountPaid numeric O DateEnrolled - datetime O O O Data information for Question 3 O tblStudents O O O Days - text 20 Time - datetime (formatted for time) O Pool - Integer FK Instructor - Integer FK Limit - TinyInt Enrolled - TinyInt Price - numeric O O O SID - auto increment PK FirstName - text 20 Middlelnitial - text 3 LastName - text 30 Suffix - text 3 Birthday - datetime LocalStreet - text 30 LocalCity - text 20
Expert Answer:
Related Book For
Applied Regression Analysis and Other Multivariable Methods
ISBN: 978-1285051086
5th edition
Authors: David G. Kleinbaum, Lawrence L. Kupper, Azhar Nizam, Eli S. Rosenberg
Posted Date:
Students also viewed these databases questions
-
Design a Java class that represents a cache with a fixed size. It should support operations like add, retrieve, and remove, and it should evict the least recently used item when it reaches capacity.
-
A load must be suspended 6 m below a high ceiling using cables attached to two supports that are 2 m apart (see figure). How far below the ceiling (x in the figure) should the cables be joined to...
-
How important is the loss of manufacturing jobs to the nation?
-
Give an acceptable IUPAC name for each of the following compounds:
-
List, describe, and provide examples of the various defenses available to a defendant charged with a business crime.
-
The City of Bernard starts the year of 2015 with the following unrestricted amounts in its general fund: cash of $20,000 and investments of $70,000. In addition, it holds a small building bought on...
-
why is there an OSI and TCP / IP model?
-
Company 1 wholly owns company 2 and company 3. Company 2 and 3 are both operating businesses, but, in order to mitigate taxable income, intercompany transactions that are not always done on...
-
Salt Company, a newly established subsidiary of Pepper Corporation, received assets with an original cost of $260,000, a fair value of $200,000, and a book value of $140,000 from the parent in...
-
In Problems 20-52: a. State the type; and \(\mathbf{b}\). Answer the question. Certain Concrete Company deposits \(\$ 4,000\) at the end of each quarter into an account paying \(10 \%\) interest...
-
If a car with a cash price of \(\$ 11,450\) is offered for nothing down with 48 monthly payments of \(\$ 353.04\), what is the APR?
-
Use a calculator to evaluate the amortization formula \[m=\frac{P\left(\frac{r}{n}ight)}{1-\left(1+\frac{r}{n}ight)^{-n t}}\] for the values of the variables \(P, r\), and \(t\) (respectively) given...
-
In Problems 20-52: a. State the type; and \(\mathbf{b}\). Answer the question. A 5-year term insurance policy has an annual premium of \(\$ 300\), and at the end of 5 years, all payments and interest...
-
Annual demand for a product is 250 units. Annual carrying cost per unit of product is $1. Ordering cost per order is $20. Assume a year is 350 days. 1. How much should we order each time to minimize...
-
The age-old saying for investing is "buy low and sell high," but this is easier said than done. Investors who panic about falling prices sell their investments, which in turn lowers the price and...
-
A regression analysis of data on n = 53 males considered the following variables: Y = SBPSL (estimated slope based on the straight-line regression of an individual's blood pressure over time) X1 =...
-
Repeat Problem 9 using LN_BLDTL as the dependent variable. Problem 9 This problem involves data from Problem 15 in Chapter 5. Treat LN_BRNTL as the dependent variable and dosage level of toluene...
-
In Section 13.6, adjusted mean BMI values were obtained for the two nominal variables exercise and tobacco_now. A drawback of the approach used is that these four adjusted means were estimated for...
-
What accounts for the disparity in NPMO between the statistical 6 and the popular Six Sigma approach?
-
What purpose is served by flowcharts?
-
What is the most common use of stratification?
Study smarter with the SolutionInn App