Name: 
 

A114/I111 Fall 2003 Midterm Study Guide (Part Seven)



True/False
Indicate whether the sentence or statement is true or false.
 

1. 

Redundancy wastes space because you are storing different types of data in the same place.
 

2. 

Redundancy makes changes more time-consuming since you must change the same information in a number of places.
 

3. 

Spreadsheet software is the best way to store business information, for example orders, customers, and sales people.
 

4. 

An entity is also defined as an attribute.
 

5. 

A person, place, or object is also known as an entity.
 

6. 

An attribute is a characteristic or property of an entity.
 

7. 

An attribute is also known as a row in most databases.
 

8. 

An association between entities is known as a relationship.
 

9. 

A database will not only hold multiple entities, but also information about the relationships between these multiple entities.
 

10. 

If one entity is associated with many other entities, then the relationship is considered a one-to-many relationship.
 

11. 

Each table in a database represents two or more entities.
 

12. 

The relationship between different entities (in different tables) is handled by their common columns.
 

13. 

A DBMS is a complex spreadsheet program.
 

14. 

A collection of programs that allows users to interact with a database is called a DBMS.
 

15. 

Users can only interact with a database directly; no other programming languages are allowed.
 

16. 

Popular DBMSs include Access, Oracle, DB2, and SQL Server.
 

17. 

The term database design refers to the inserting of information into the database for use.
 

18. 

A switchboard system refers to the process of ordering products from the database using a digital telephone system.
 

19. 

Sharing data is one advantage to database processing.
 

20. 

An advantage to database processing is facilitating redundancy.
 

21. 

Sharing data means that data is combined data so that all users, both authorized and unauthorized, can have access to a greater pool of data.
 

22. 

The database administrator, or DBA, can balance conflicting requirements by making sure that the database benefits the whole organization rather than a single person or group.
 

23. 

All redundancy within a database can and should always be eliminated.
 

24. 

An advantage of using a relational database is to facilitate consistency.
 

25. 

Integrity constraints limit the number of entities that can be placed in a table or database.
 

26. 

A database can be password protected to prevent unauthorized users from accessing the data.
 

27. 

One disadvantage of a database system would be larger file size.
 

28. 

There is a greater impact of failure in a nondatabase, file-oriented system.
 

Modified True/False
Indicate whether the sentence or statement is true or false.  If false, change the identified word or phrase to make the sentence or statement true.
 

29. 

The duplication of data is a problem called consistency.

 

30. 

Redundancy wastes space because the same data is stored in multiple places.

 

31. 

Spreadsheets have limited security features that protect the data from unauthorized users.

 

32. 

A database structure contains information about categories of information and the structure between the categories.

 

33. 

A person, place, or event is also known as a(n) entity.

 

34. 

A characteristic or property of an entity is also known as a(n) relationship.

 

35. 

Another name for a field or column is a(n) attribute.

 

36. 

A relationship is also known as the association between entities.

 

37. 

A relationship is handled by using common columns.

 

38. 

In some database systems, the word "Sort" has a special purpose.

 

39. 

Some popular DBMSs include Access, Oracle, SQL Server, and Java.

 

40. 

Determining the structure of a database is called the database design.

 

41. 

Screens are objects which are used to maintain, view, and print data from a database.

 



 
Check Your Work     Reset Help