Question: Create the Projects schema using the integrity enhancement features of SQL with the following constraints: (a) Sex must be one of the single characters M

Create the Projects schema using the integrity enhancement features of SQL with the following constraints:
(a) Sex must be one of the single characters ‘M’ or ‘F’.
(b) Position must be one of ‘Manager’, ‘Team Leader’, ‘Analyst’, or ‘Software Developer’.
(c) Hoursworked must be an integer value between 0 and 40.

Step by Step Solution

★★★★★

3.39 Rating (174 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

CREATE SCHMEA Projects CREATE DOMAIN TableKey AS CHAR5 CREATE DOMAIN ... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

672-CS-DB (1286).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Create the Hotel table using the integrity enhancement features of SQL.

Now create the Room, Booking, and Guest tables using the integrity enhancement features of SQL with the following constraints: (a) Type must be one of Single, Double, or Family. (b) Price must be...

The university computer lab's director keeps track of the lab usage, as measured by the number of students using the lab. This particular function is very important for budgeting purposes. The...

The following tables form part of a database held in a relational DBMS: Hotel (hotelNo, hotelName, city) Room (roomNo, hotelNo, roomType, price) Booking (hotelNo, guestNo, dateFrom, dateTo, roomNo)...

. Create the following tables using the integrity enhancement features of SQL with the following constraints. Use the domains that you created in question 1. a. (5 points) Create the Hotel table...

The relational schema shown below is part of a hospital database. The primary keys are highlighted in bold. Patient (patientno, patName, patAddr, DOB) Ward (wardNo, wardName, wardType, noofBeds)...

Now create the Room, Booking, and Guest tables using the integrity enhancement features of SQL with the following constraints: ( a ) type must be one of Single, Double, or Family. ( b ) price must be...

/* Database Exam, Artist database, Dr. N. Drawel */ CREATE TABLE GALLERY ( GAL_NUM char(4), GAL_OWNER varchar(35), GAL_AREACODE char(3), GAL_PHONE char(8), GAL_RATE number(8) ); INSERT INTO GALLERY...

Please answer all of the numbered questions in A) and B) Here is the Artist.sql file required: CREATE TABLE GALLERY ( GAL_NUM char(4), GAL_OWNER varchar(35), GAL_AREACODE char(3), GAL_PHONE char(8),...

CREATE TABLE GALLERY ( GAL_NUM char(4), GAL_OWNER varchar(35), GAL_AREACODE char(3), GAL_PHONE char(8), GAL_RATE number ); INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);...

Let A = {1,2, 3, 4} and R = {(1,2), (2,3)(3, 4), (2,1)}. The number of edges in the transitive closure of R is O a. 9 O b. None O c.5 O d.4 O e. 16

3. Suppose that g is given by the graph at left in Figure 5.3 and that A is the corresponding integral function defined by A(x) = g(1) dt. 3+ 6 MA -10 3+ Mat 3 5 Figure 5.3: At left, the graph of y=...

The appearance of a formal report must be impeccable. Write a summary for your instructor in which you address issues of appearance, mechanics, and the use of graphics.

How does Basel III address liquidity risk?

Instead of storing shared structures in shared memory, an alternative architecture would be to store them in the local memory of a special process, and access the shared data by interprocess...

In typical clientserver systems the server machine is much more powerful than the clients; that is, its processor is faster, it may have multiple processors, and it has more memory and disk capacity....

Consider an object-oriented database system based on a client-server architecture, with the server acting as a data server. a. What is the effect of the speed of the interconnection between the...

QUESHON 6110 Marks) The R&D department of laptop bag manufacturer is gathering feedback for their new design. 300 bags were distributed to their staff. Their age is between 21 and 49 years old. They...

Question 1 9 1 pts This is a software entity that contains data and procedures. Method Object Class Program

Please answer what is asked in each problems in number 4, 5, and 6. Thank you! 4. Sound waves from a basketball. An experiment was con- 6. Crude oil biodegradation. Refer to the Journal of Petroleum...