Answer the following questions. Upload/submit your written answers in MS-Word as

Question

Answer the following questions. Upload/submit your written answers in MS-Word as an attachment. 1. Define each of the following terms a) file organization b) sequential file organization c) hashed file organization d) denormalization e) composite key f) secondary key g) data type 2. Using to Figure 6-11, page 283 of textbook, write SQL data definition commands for each of the following queries: a) How would you add an attribute, Class, to the Student table? b) How would you remove the Registration table? c) How would you change the FacultyName field from25 characters to 40 characters? 3. Using to Figure 6-11, page 283 of textbook, write SQL commands for the following: a) Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the Student table. b) Now write a command that will remove Lopez from the Student table. c) Create an SQL command that will modify the name of course ISM 4212 from Database to Introduction to Relational Databases. 4. Define each of the following terms: a) dynamic SQL b) correlated subquery c) embedded SQL d) procedure e) join

Explanation / Answer

The following terms are described below:

File organization: It refers to the process wherein data is stored in a file and the methods by which it can be accessed.

Sequential file organization: It is a file where individual records can only be accessed sequentially that is in the same order as they were orginally written to the file. Besides that, new records are always added to the end of the file.

Hashed file organization refers to the process of computing the address of the data item by computing a function on the search key value.Besides that, a hash file stores data in bucket format. Bucket is basically considered as a unit of storage.

Denormalization: It is the process to optimize the read performance of a database by adding redundant data or by grouping data.

Composite key: This key consists of more tthan one attribute that uniquely identifies an entity occurance.

Secondary key: It is belived that an entity may have one or more choices for the primary key. These keys are known as candidate key collectively and among them, one is selected as the primary key. Those which are left and are not selected are known as secondary keys.

Data type: In computer programning, a data type is a classification of identifying one of various types of data such as integer or bollean, that basically determines the possible values for that type.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

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