Questions 1-4 are the for table aboove. 1. List the data types you would select

Question

Questions 1-4 are the for table aboove.

1. List the data types you would select for each attribute above.

2. Why, in the CLASS table are there 2 foreign keys?

3. What is a DOMAIN? What do you think the DOMAIN is for PROF_SPECIALTY?

4. What would CLASS TIME look like if printed? What constraint could be put on CLASS TIME?

Explanation / Answer

1.) int->EMP_NUM,CLASS_CODE,CRS_CODE,PROF_RANK,CLASS_DAYS,CRS-CREDIT char->EMP_LNAME,EMP_FNAME,EMP_INITIAL,EMP_E_MAIL,PROF_SPECALITY,CRS_TITLE,CRS_DESCRIPT, time->CLASS_TIME 2.)because in every class there should be a professor and a course.so EMP_NUM,CRS_CODE are the two foriegn keys. 3.)I am not clear about this. 4.) Range is 00:00:00.0000000 through 23:59:59.9999999 for example 10:56:32

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.