Showing 1 to 30 of 30

Chapter 3 Review Questions
1. What is a table?
A logical structure containing a set of related entity instances
2. What are the conditions for a table to be a relation?
Each cell in a table must contain a single value
There should be no duplicated rows

Andres Ruiz
COSC-4336
10/12/16
Your Turn 1 Artisan Crafts - Part 2
When I was designing the Student Master Form, I kind of followed figure 5-1 by putting
the student code in the top center of the form. Then I decided to put the biography in center and
the

Andres Ruiz
COSC-4336
9/18/16
Your Turn 2 Mums Landscaping Database - Part 2
When making the query for step h I decided to just make a calculation field in the query
and multiplied the Hourly Rate field by forty. Then changed the caption of the calculatio

Andres Ruiz
COSC-4336
9/21/16
Maintaining Mums Landscaping Database - Part 2
When I made the calculation field, Total Amount, I decided to insert the record between
the Balance and Spr # records, so that after the Balance field you could see the results,

Andres Ruiz
COSC-4336
9/5/16
Mums Landscaping Database - Part 2
In the Mums Landscaping database I had two tables in the database, which are called
Customers and Supervisors. In the Customers table I made the customer number (Cust #) the
primary key becau

Chapter 10 Review Questions
1. What are forms and reports for?
Forms: Used to enter, display, and update data stored in a database.
Reports: Used to present information
2. Explain the role of an Image control.
Image: Used to present the company logo an

Chapter 7 Review Questions
1. For students who join both the Book and Soccer clubs, use the variable Fee to
set the Book Club membership fee at $50 and set the Soccer Club membership
fee as 70 percent higher than the Book Club fee. Run your SQL statement

Karen Lopez
Chapter 8 Review Questions and Lab
1. What are the advantages of using views in database applications?
Views can be used to limit the actions such as inserting, deleting, and updating tables
directly by front-end users. They are more secure.

Karen Lopez
Chapter 7 Lab and Review Questions
1. For students who join both the Book and Soccer clubs, use the variable Fee to set the Book Club
membership fee at $50 and set the Soccer Club membership fee as 70 percent higher than the
Book Club fee. Run

Chapter 5 Review Questions
1. What are the concerns at the physical design stage?
Database system architecture
Data type and size
Database accessing
Data usage
2. Explain why SQL is important to database development.
SQL code is portable and it can b

Chapter 4 Review Questions
1. What type of DBMS is good for single users?
Microsoft Access
2. What are the advantages of SQL Server?
It can handle large databases
It can manage a database with terabyte storage
It can work in a client/server environmen

Chapter 6 Review Questions
1. Execute a SQL statement to display all the columns in the table CLUB for the
club named Poetry.
2. Execute a SQL statement to display the columns FirstName and LastName in
the table STUDENT, where the student has the first na

Chapter 1 Review Questions
1. Why is business process information important?
2. Describe the functions of a database in a business process.
The use of the database in a business process is to store business data, track business processes, and
analyze busi

Karen Lopez
Chapter 6 Lab and Review Questions
1. Execute a SQL statement to display all the columns in the table CLUB for the club named Poetry.
2. Execute a SQL statement to display the columns FirstName and LastName in the table STUDENT,
where the stud