Cpsc - Relational Database Design Student Assessment

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Microsoft Access uses primary key fields to quickly associate data from multiple tables and bring the data together for you.