A file containing SQL commands is called a ____________________ file.

Fill in the blank(s) with the appropriate word(s).


script

Computer Science & Information Technology

You might also like to view...

What networking function is required if the DHCP server is not on the same LAN? Why is this networking function required?

What will be an ideal response?

Computer Science & Information Technology

Consider the following database schema. The attributes are ABCDEF. The FDs are:

ABF -> C CF -> B CD -> A BD -> AE C -> F B -> F (a) Compute the attribute closure of ABD with respect to the above set of FDs. Show all steps. (b) Compute the minimal cover of the above set of FDs. Show all steps. (c) Use the 3NF synthesis algorithm to construct a lossless, dependency preserving decomposition of the above schema. Show all steps. (d) Are all the schemas in the resulting decomposition in BCNF? If yes, then you are done. If there are schemas that are not in BCNF, decompose them further to achieve BCNF. Is the resulting decomposition dependency-preserving? Explain all steps: yes/no answers do not count. (a) What is a functional dependency? (b) Explain why a primary key constraint is an example of a functional dependency. (c) State the conditions (in terms of functional dependencies) for a relation to be in 3rd normal form and in BCNF. (d) Consider a relation in a library system with the following attributes: author (A), title (T), copy number (C), author's year of birth (B), shelf (Sh), subject (Sub). If the library has multiple copies of a particular book they are numbered consecutively with (unique) copy numbers. Shelf is the location of a particular book and all the books on a shelf are in the same subject category. What are the functional dependencies? Decompose the relation into two or more relations to eliminate redundant storage of information. In what normal form are the relations that result from your decomposition?

Computer Science & Information Technology

The arrangement of records sorted in a datasheet is ____________________ unless the datasheet is saved as a table.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

A file system lets a program save or retrieve information in units called ____.

A. sectors B. blocks C. tracks D. files

Computer Science & Information Technology