3710-module1

Multiple Choice

Which of the following is a key factor for maintaining a healthy relational database system?

• Regular backups

• Ignoring data redundancy

• Allowing unauthorized access

• Neglecting database updates

Multiple Choice

Which of the following is a problem that JC Consulting employees faced when using spreadsheets for project estimates?

• Data redundancy leading to errors

• Too many employees

• Lack of clients

• Insufficient project tasks

Multiple Choice

Based on the information in slides 1 and 2, what are two major limitations of using spreadsheets for managing project estimates at JC Consulting?

• Data redundancy and limited security

• Unlimited storage and fast access

• Automated error correction and high security

• Real-time collaboration and no size limits

Open Ended

From the given image, explain why this dataset has redundancy problem.

Open Ended

What are the key differences between the project estimates spreadsheet and the sample project estimate shown for ProjectID 31?

Open Ended

Describe how data redundancy can impact decision making at JC Consulting Company.

Multiple Choice

Which of the following pieces of information is NOT required for employees according to JC Consulting's management?

• Hire date

• Salary

• Project notes

• Title

Multiple Choice

Which of the following is a problem caused by data redundancy?

• It makes updating data more cumbersome and time-consuming.

• It improves data consistency.

• It reduces the need for storage space.

• It simplifies data management.

Open Ended

Explain why it is important for JC Consulting Company to manage the relationships between different lists of data such as employees, clients, estimates, and tasks.

Multiple Select

Which of the following are advantages of using a relational database for JCC?

• Ability to retrieve specific project estimates and related tasks

• Summarize and analyze data in various ways

• Requires more manual data updates

• Contains information about multiple categories like employees and clients

Open Ended

From the given image, identify the Entities and Attribute

Multiple Choice

What does a one-to-many relationship mean in the context of clients and projects?

• Each client can be associated with many projects.

• Each project can have many clients.

• Each client can have only one project.

• Projects and clients are not related.

Open Ended

Based on the diagram, describe how the entities 'Clients' and 'Projects' are related and what attributes are associated with each entity.

Multiple Choice

Which field is used to establish the one-to-many relationship between the Clients and Projects tables in a relational database?

• ClientID

• ProjectID

• EmployeeID

• ProjectStartDate

Open Ended

Why can't a many-to-many relationship be directly created in a relational database, and how is it accommodated?

Open Ended

Explain how a relational database handles relationships between entities using a common field. Use the example of clients and projects.

Multiple Choice

Which of the following are warning signs that your entities, attributes, and relationships are not properly designed in a relational database?

• Need to enter more than one value in a particular field

• Asked to enter two or more pieces of information in a field

• Find yourself adding new columns to handle multiple values for the same type of data

• All of the above

Multiple Choice

In an Entity-Relationship (E-R) diagram, what does a rectangle represent?

• Entity

• Relationship

• Attribute

• Primary Key

Open Ended

Explain how the relationships between tables in the E-R diagram (Clients, Projects, Employees, ProjectLineItems, TaskMasterList) help in organizing data for JC Consulting.

Multiple Choice

Which of the following best describes the purpose of an E-R (Entity-Relationship) diagram in database design?

• To show the relationships between tables and their fields

• To display the user interface of a database application

• To list all possible queries for a database

• To provide a backup of database data

Multiple Select

Which of the following are commonly included in a software stack used to build a new application?

• Programming language

• Database management system

• Web server

• Spreadsheet software

Multiple Choice

What is the main advantage of using forms in a database application, as described in the slides?

• They allow users to maintain and view data without programming knowledge

• They increase the speed of database queries

• They automatically generate reports

• They prevent unauthorized access to the database

Open Ended

Compare the Task Master List Entry Form and the Project Estimate Entry Form in terms of the data they display and their complexity. How does each form utilize data from different tables?

Multiple Choice

What is one of the fundamental goals of a database system as compared to a flat-file environment?

• To separate data into multiple disjointed lists for easier access

• To provide better information by turning recorded facts into useful knowledge

• To make summarized data requests more difficult to fulfill

• To prevent users from sharing updated client information immediately

Multiple Choice

Who is primarily responsible for managing and structuring a database to meet the needs of the entire organization?

• Database Administrator (DBA)

• Data Analyst

• Software Engineer

• Network Administrator

Multiple Choice

Why is data consistency important in a relational database?

• It allows users to enter data in any format they prefer.

• It ensures that attribute values are entered in a uniform way, making it easier to find, filter, and analyze data.

• It prevents users from accessing multiple tables at once.

• It reduces the need for primary keys in a database.

Multiple Choice

What is the main purpose of enforcing referential integrity in a relational database?

• To allow duplicate records across multiple tables

• To ensure every record on the “many” side of a relationship has a matching record on the “one” side

• To reduce data redundancy by merging all tables into one

• To allow users to freely delete records without restrictions

Multiple Choice

Which of the following best describes how a secure DBMS increases security?

• By allowing all users unrestricted access to the database

• By removing the need for passwords and simplifying access

• By eliminating the need for backups or rollbacks

• By providing features such as user authentication, permissions, data encryption, and protection against unauthorized access or corruption

Multiple Choice

How does a DBMS increase productivity for both programmers and nonprogrammers?

• By restricting nonprogrammers from retrieving any data without programmer assistance

• By eliminating the need for managers and analysts to use reports

• By automating data manipulation tasks and allowing users to access accurate, reliable reports without needing custom programs

• By requiring programmers to manually manipulate all data before it can be used

Multiple Choice

What does it mean when data is "freed from individual applications" in a DBMS?

• Database changes always require rewriting all programs that access the data

• Data independence allows the database structure to change without major changes to the programs that access it

• Programmers must update every application whenever new data is added to the database

• Management avoids changing the database because DBMS systems cannot adapt to new structures

Match

Match each key factor for a healthy relational database with its correct description.

• Design

• Security

• Talent

If entities, attributes, and relationshi

When multiple users share a database, br

A business must commit to either hiring

• If entities, attributes, and relationshi

• When multiple users share a database, br

• A business must commit to either hiring

Multiple Choice

Which statement best differentiates structured data from unstructured data?

• Structured data is not organized and usually requires metadata, while unstructured data is stored in relational DBMS.

• Structured data is organized and stored in traditional DBMS, while unstructured data is not easily organized or interpreted and may involve metadata.

• Both structured and unstructured data are always stored the same way in a DBMS.

• Unstructured data is always more accurate than structured data.

Multiple Choice

Which of the following is NOT one of the learning objectives for this module?

• Define basic database terminology

• Describe database management systems (DBMSs)

• Explain the history of computer programming

• Prepare for a career in database administration