quiz 1 Flashcards
Who first defined the principles of a relational database?
Edgar Codd
Which of the following best describe how you should document a project?
Document the structure of the database, Keep a project notebook containing all documentation, Document the development process for the database.
Which of the following best defines a statement of work?
A preliminary document that describes, in general, the work that needs to be done on a project
Which of the following are common functions of a relational database management system?
Providing for the creation of databases and database objects, Providing for data retrieval and manipulation, Providing for backup and security
Which of the following is it important to document?
The design of the database, The process of developing the database
When a primary key is repeated in a second table to make a relationship it is called:
A foreign key
What best describes the function of a foreign key?
A foreign key is the primary key of one table repeated in another table in order to create a relationship between the tables
Which best defines the function of SQL in a database?
It is the language relational databases used to create database objects and to manipulate and retrieve data
When estimating times for tasks it is a good practice to:
Determine the best time and the worst and then make your estimate with an edge toward the worst
Which of the following is the best way to begin identifying the topics of a database?
Look at the project notes and identify all the nouns, then group them into themes
Which of the following could be considered a database?
A mailing list developed in Microsoft Access, an address book, a card catalogue.
A nonprofit wants to talk to you about a database to track donors and potential donors. Which of the following best describes how you should prepare for the initial interview?
Don’t over anticipate. Remain open minded. Try to develop a few questions to get the client started describing the basic purpose and needs of the database.
Which of these best defines data integrity?
The accuracy and correctness of the data in the database
