+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
Which of the following best defines a statement of work?
|
A preliminary document that describes the work that needs to be done on a project
|
|
What is a Relational Database?
|
A type of database that restores data in tables that are related to each other by means if repeated columns called keys
|
|
A good definition for a database is?
|
A collection of related data
|
|
A friend has a spreadsheet in which she documents her DVD collection. She tracks the title, genre, edition, the date she bought it, and the price she paid for it. So far, she has listed about 400 titles. She wonders if it is time to move to a relational database management system. Which of the following would be the best advice for her?
|
If she wants to learn how to use a relational database, then she can certainly get one. However, her data needs are modest and a spreadsheet might be the best solution at this point
|
|
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
|
|
A small community takes in stray animals. Many of them given out to foster families who take care of them until they are adopted by someone. They need a database that will track animals, which families have the animals, and the adoption history of each animal. Which of the following best describes the "Big themes" or the topics of the database?
|
Animals, Foster Families, Adoptions.
|
|
Which of the following is one of Codds principles?
|
Local design must be kept separate from physical design
|
|
Which description best describes a fixed length?
|
A file where every piece of data is allotted the same amount of space.
|
|
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.
|
|
Who first defined the principles of a relational database?
|
Edgar Codd
|
|
A small community takes in stray animals, many are given out to foster families who take care of them until someone adopts them. They need a database that will track animals, which foster families have the animals and the adoption history of each animal. Which of the following is the best Statement of Scope?
|
The database will track each animal that is taken in. It will track all available adoptive families and which animals are being tended by each adoptive family. It will also track when each animal is adopted and by whom.
|
|
Redundancy refers to what database condition?
|
The same data is recorded in more than one place in the same database
|
|
Which part of a statement work defines all the broad requirements for a project?
|
Statement of Scope
|
|
Which of the following could be considered a database? A) A card CatalogB) An address bookC) a mailing list developed in Microsoft AccessD) All of the above
|
D) All of the above
|
