1D0-541 Exam Dumps : CIW v5 Database Design Specialist

It contains a query language for retrieving data.

It can be used only to manipulate data through a SQL interface.

The user is not required to know how the underlying data structures are implemented.

It requires that the user know how the underlying data structures are implemented.

Second normal form

First normal form

Boyce-Codd normal form

Third normal form

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

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

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

Data files are owned and maintained by the users.

Database administration is simplified.

A standard method can be used to access the database.

Data is decentralized.