Cpsc - Relational Database Design Student Assessment
This assessment is a gauge to estimate your knowledge of MS Access Relational Database Design. The results will help you and the instructor determine how you may need to spend more time learning about MS Access capabilities as they relate to Relational Database Design (building lists).
After reviewing the Relational Database Design handout, take a few moments to answer the questions below. Do NOT review the material untial after you have answered the questions. Be sure that you have a thorough understanding of the questions and correct answers before attending the Access Essentials training Read moresession.
- 1.
The key to understanding the database desing process lies in understanding the way a relational database management system, such as Microsoft Access
- A.
Stores data
- B.
Sorts data
- C.
Filters data
- D.
Analyzes data
Correct Answer
A. Stores dataExplanation
The given statement suggests that the key to understanding the database design process lies in understanding how a relational database management system, such as Microsoft Access, stores data. This implies that one must have a clear understanding of how data is organized, structured, and stored within a database in order to effectively design and utilize it. Understanding the storage mechanisms and principles of a database management system is crucial for efficient data management and retrieval.Rate this question:
-
- 2.
You should be careful not to make mistakes during the design process because it is hard to change the design of an Access Database as you are creating it:
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
With Microsoft Access, it's easy to change the design of your database as you're creating it. However, it becomes much more difficult to make changes to tables after they're filled with data and after you've built forms and reports.Rate this question:
-
- 3.
The following are signs that you should reevaluate your database design:
- A.
You have one table with a large number of fields that don't all relate to the same subject.
- B.
You have fields that are intentionally left blank in many records because they aren't appliable to those records.
- C.
You have a large number of tables, many of which contain the same fields.
- D.
All of the above.
Correct Answer
D. All of the above.Explanation
The given answer "All of the above" is correct because each of the signs mentioned (having one table with a large number of unrelated fields, having intentionally left blank fields, and having multiple tables with the same fields) indicate a poor database design. These signs suggest that the database is not properly organized, normalized, or efficient, which can lead to difficulties in data management, querying, and overall system performance. Reevaluating the database design can help address these issues and improve the overall effectiveness of the database.Rate this question:
-
- 4.
Some ideas for determining how a database will be used include:
- A.
Talking to the people who will use the database.
- B.
Brainstorming about the questions you'd like the database to answer.
- C.
Sketching out the reports you'd like it to produce.
- D.
Gathering the forms you currently use to record your data.
- E.
All of the above.
Correct Answer
E. All of the above.Explanation
The correct answer is "All of the above" because all the mentioned ideas contribute to determining how a database will be used. Talking to the people who will use the database helps understand their needs and requirements. Brainstorming about the questions the database should answer helps identify the specific information that needs to be stored and retrieved. Sketching out the reports helps visualize the desired output and format. Gathering the forms currently used to record data provides insights into the existing data structure and workflow. Considering all these ideas together ensures a comprehensive understanding of how the database will be utilized.Rate this question:
-
- 5.
The trickiest step in designing the database is:
- A.
Identifying the end users
- B.
Building forms and reports
- C.
Determing the tables you'll need
- D.
None of the above
Correct Answer
C. Determing the tables you'll needExplanation
Determining the tables in your database can be the trickiest step in the database design process. That's because the results you want from your database -- the reports you want to print, the forms you want to use, the questions you want answered -- don't necessarily provide clues about the structure of the tables that produce them.Rate this question:
-
- 6.
Think of fields as:
- A.
Related to addressed.
- B.
Characteristics of the table.
- C.
A place to store extra information that you may need later.
- D.
Derived or calculated data.
Correct Answer
B. Characteristics of the table.Explanation
Fields in this context refer to the characteristics of a table. In a database, a table consists of rows and columns, where each column represents a field. These fields define the specific attributes or properties of the data that can be stored in the table. They determine the type of data that can be stored in each column, such as text, numbers, dates, etc. Therefore, the given answer accurately describes the purpose of fields in relation to tables.Rate this question:
-
- 7.
Tips for determining the fields to be included in your database include:
- A.
Relate each field directly to the subject of the table.
- B.
Avoid derived or calculated data.
- C.
Include all the information you need.
- D.
Store information in its smallest logical parts.
- E.
All of the above.
Correct Answer
E. All of the above.Explanation
The correct answer is "all of the above." This means that all of the tips mentioned in the question should be considered when determining the fields to be included in a database. These tips include relating each field directly to the subject of the table, avoiding derived or calculated data, including all the necessary information, and storing information in its smallest logical parts. By following all of these guidelines, one can ensure that the database is well-structured and contains all the relevant data needed for its intended purpose.Rate this question:
-
- 8.
In database terminology, a field or set of fields that uniquely identifies each individual record stored in the table is called:
- A.
The primary key of the table
- B.
An identifier field
- C.
The unique record
- D.
None of the above
Correct Answer
A. The primary key of the tableExplanation
Microsoft Access uses primary key fields to quickly associate data from multiple tables and bring the data together for you.Rate this question:
-
- 9.
A relational database management system means:
- A.
That you store related data in separate tables and then define relationships between the tables.
- B.
That information about relatives is stored in tables.
- C.
That relationships are used to find associated information stored in the database.
- D.
A and C above.
Correct Answer
D. A and C above.Explanation
Microsoft Access is a relational database management system. That means you store related data in separate tables. Then you define relationships between the tables, and Microsoft Access uses the relationships to find associated information stored in your database.Rate this question:
-
- 10.
There are 3 types of relationships between tables:
- A.
Parent-to-child, sister-to-brother and cousin-to-cousin relationships.
- B.
Hierarchical, flat and layered relationships.
- C.
One-to-many, many-to-many and one-to-one relationship.
- D.
Simple, complex and multiple relationships.
Correct Answer
C. One-to-many, many-to-many and one-to-one relationship.Explanation
The correct answer is one-to-many, many-to-many, and one-to-one relationship. These are the three types of relationships that can exist between tables in a database. A one-to-many relationship means that one record in the first table can be associated with multiple records in the second table. A many-to-many relationship means that multiple records in the first table can be associated with multiple records in the second table. A one-to-one relationship means that each record in the first table is associated with only one record in the second table, and vice versa. These relationships are fundamental in organizing and connecting data in a database system.Rate this question:
-
- 11.
Some items to check for when reviewing the initial design of your database:
- A.
Did you forget any fields? Is there information that you need that isn't included? If it's information about something else, you may need to create another table.
- B.
Did you choose a good primary key for each table? If you use it to search for specific records, is it easy to remember and type? Make sure that you won't need to enter a value in a primary key field that duplicates another value in the field.
- C.
Are you repeatedly entering duplicate information in one of your tables? If so, you probably need to divide the table into two with a one-to-many relationship.
- D.
Do you have tables with many fields, a limited number of records, and many empty fields in individual records? If so, think about redesigning the table so it has fewer fields and more records.
- E.
All of the above.
Correct Answer
E. All of the above.Explanation
The correct answer is "All of the above" because all of the mentioned items are important considerations when reviewing the initial design of a database. Forgetting fields or missing necessary information can lead to incomplete or inaccurate data. Choosing a good primary key is crucial for efficient searching and data organization. Repeatedly entering duplicate information indicates a need for normalization and establishing relationships between tables. Lastly, having tables with many empty fields suggests inefficient data storage and a need for table redesign. Therefore, all of these points should be checked when reviewing the initial design of a database.Rate this question:
-
- 12.
Name the steps in the database design process:
- A.
Purpose - determine your purpose and choose which facts to store. Tables - separate subjects such as "Manufacturer" and "Address". Fields - Decide what information to keep within each table. Relationships - Review each table and decide how the data in one table is related to the data in other tables. Analyze - your design for errors and refine if necessary.
- B.
Categorize each field after deciding on your purpose and use the SAVE AS feature to insure your work is not lost. Then, sort the tables so as to eliminate any errors before printing.
- C.
Purpose, tables, fields and categories are the primary steps involved ending with a careful analysis and check for errors.
Correct Answer
A. Purpose - determine your purpose and choose which facts to store. Tables - separate subjects such as "Manufacturer" and "Address". Fields - Decide what information to keep within each table. Relationships - Review each table and decide how the data in one table is related to the data in other tables. Analyze - your design for errors and refine if necessary.Explanation
The correct answer lists the steps involved in the database design process. These steps include determining the purpose and choosing which facts to store, separating subjects into tables, deciding what information to keep within each table, reviewing and establishing relationships between tables, analyzing the design for errors, and refining if necessary. The answer also mentions categorizing each field based on the purpose and using the "SAVE AS" feature to ensure work is not lost, as well as sorting the tables to eliminate errors before printing.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 21, 2023Quiz Edited by
ProProfs Editorial Team -
Oct 08, 2009Quiz Created by
Johnmontreal
- Academic Quizzes
- Adult Learning Quizzes
- Blended Learning Quizzes
- Career Quizzes
- Coaching Quizzes
- College Quizzes
- Communication Quizzes
- Curriculum Quizzes
- Distance Learning Quizzes
- E Learning Quizzes
- Early Childhood Education Quizzes
- GCSE Quizzes
- Grade Quizzes
- Graduation Quizzes
- Kindergarten Quizzes
- Knowledge Quizzes
- Literacy Quizzes
- Online Assessment Quizzes
- Online Exam Quizzes
- Online Test Quizzes
- Physical Education Quizzes
- Qualification Quizzes
- Religious Education Quizzes
- School Quizzes
- Special Education Quizzes
- Study Quizzes
- Subject Quizzes
- Teaching Quizzes
- Theory Quizzes
- Thesis Quizzes
- University Quizzes
Back to top