최신CIW v5 Database Design Specialist - 1D0-541무료샘플문제

A. Dept_Mngr

B. Dept_Name

C. Department.Dept_ID

D. Employee.Dept_ID

A. An update anomaly and a deletion anomaly would occur.

B. An insertion anomaly would occur.

C. A deletion anomaly would occur.

D. Only an update anomaly would occur.

A. Proj_ID and Item_Num

B. ltem_Num and E_Date

C. ProjJD

D. S_Date and E_Date

A. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num Foreign Key Class_Num References STUDENT

B. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key StudenMMumber STU_CLASS( Student_Number: integer NOT NULL Class_Num: integer NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

C. First normal form

D. Third normal form

E. STUDENT( Student_Number: integer NOT NULL Name: variable length character string length 20 NOT NULL) Primary Key Student_Number CLASS( Class_Num: integer NOT NULL Class_Name: integer NOT NULL) Primary Key Class_Num

F. Boyce-Codd normal form

G. Second normal form

A. CREATETABLE BUILDING ( Building_ID NOT NULL PRIMARY KEY, Bldg_Name, Location, Room_Count, FOREIGN KEY Building_ID REFERENCES BUILDING (Building_ID));

B. CREATETABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (50),
Room_Count INTEGER CHECK (Room_Count >
Room_Count INTEGER CHECK (
-1 And Room_Count < 601));
Room_Count > -1 Or Room_Count < 601));

C. CREATETABLE BUILDING (Building_ID INTEGER NOT NULL PRIMARY KEY, Bldg_Name VARCHAR (20), Location VARCHAR (50),

D. CREATETABLE BUILDING (
Building_ID NOT NULL PRIMARY KEY, Bldg_Name, Location, Room_Count);

A. Three-tier using thin client

B. Two-tier using thin client

C. Centralized mainframe with terminal client

D. Three-tier using fat client