Questions and Answers of Database Concepts

What is a LAN?
What is a shared lock? What is an exclusive lock?
For the following exercises, you will address problems and answer questions from the Solmaris Condominium Group staff. You do not use the Solmaris database for any of these exercises.1. The log shown
The management of Colonial Adventure Tours wants to upgrade its database and wants you to help select a different DBMS. To help management, they would like you to complete the following exercises.
For the following exercises, you will address problems and answer questions from management at TAL Distributors.You do not use the TAL Distributors database for any of these exercises.1. While users
Assume that you need to withdraw $100 from your checking account using your bank’s ATM machine. What set of steps does the DBMS need to perform to complete your transaction?
What is privacy? How is privacy related to security?
How do views relate to security?
What are permissions? Explain the relationship between permissions and work groups.
What are authorization rules?
What is security?
What is recovery?
What is locking and what does it accomplish?
What is meant by concurrent update?
Complete the following tasks. In each exercise, represent your answer in both DBDL and with a diagram. You may use any of the styles presented in this chapter for the diagram.1. Design a database to
The following exercises are based on the TAL Distributors database as designed in Example 1 in this chapter. In each exercise, represent your answer in DBDL and with a diagram. You may use any of the
List the changes you would need to make in your answer to Question 7 if you must store the year and the semester in which a student took a course and received a grade.
Suppose in addition to the requirements specified in Question 7, you must store the number of the department in which the student is majoring. Indicate the changes this would cause in the design in
List the changes you would need to make in your answer to Question 7 if they could have more than one advisor.
Under what circumstances would you not need to break down an overall design into a consideration of individual user views?
Define the term user view as it applies to database design.
The following exercises are based on the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. No computer work is required.1. Using the types of entities found in the Solmaris
The following exercises are based on the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1. No computer work is required.1. Using the types of entities found in the
The requirements shown in Question 11 have changed. The dentist’s office would like to add the date of the patient’s last payment. In which relation (table) would you place this attribute?
Assume the same scenario as that given in Question 13 but replace CourseNum and Description with Advisor- Num, LastName, and FirstName as shown. Advisor refers to the advisor responsible for the
Convert the following table to an equivalent collection of tables that are in third normal form. This table contains information about patients of a dentist. Each patient belongs to a
Define first normal form.
Define functional dependence.
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the
The owner of Colonial Adventure Tours would like you to complete the following tasks to help him maintain his database. In the following exercises, you will use the data in the Colonial Adventure
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL
Toys Galore currently has a credit limit of $7,500. Because Toys Galore has an excellent credit rating, TAL Distributors is increasing the company’s credit limit to $10,000. If you run the SQL
You have a table that contains the following fields: Member Last Name, Member First Name, Street, City, State, Postal Code, and Membership Fee. There are 75,000 records in the table. What indexes
What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2013?
Write the SQL commands to obtain the following information from the system catalog:a. List every table that you created.b. List every field in the Customer table and its associated data type.c. List
What is the system catalog? Name three items about which the catalog maintains information.
Write the SQL command to revoke user Stetson’s privilege.
Write the SQL commands to grant the following privileges:a. User Stetson must be able to retrieve data from the Customer table.b. Users Webster and Bremer must be able to add new orders and order
Define a view named Item Order. It consists of the item number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.a. Using SQL,
Using data from the TAL Distributors database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a
The owner of Colonial Adventure Tours knows the importance of the SQL language in database management. He realizes that he can use SQL to perform the same functions that you performed with queries in
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL
You need to delete the Order Line table from the TAL Distributors database. Will the following command work? Why or why not?
In Example 1, why is the data type for the Postal Code field CHAR and not SMALLINT or INTEGER? Is the length of the field long enough? Why or why not?
How do you save the results of an SQL query as a table?
How do you join tables in SQL?
What is a sub query? When is a sub query executed?
What are the SQL built-in functions? How do you use them in an SQL query?
In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25 in Chapter 1. (If you use a computer to complete these exercises, use a
The owner of Colonial Adventure Tours knows that being able to run queries is one of the most important benefits of using a DBMS. In the following exercises, you will use the data in the Colonial
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. In each step, indicate how to use relational algebra to obtain the desired results.1. List the
In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the TAL Distributors database
In Example 23 on page 58, would you get the same result if you performed the PROJECT command before the JOIN command? Why or why not?
In the TAL Distributors database shown in Figure 2-1, the Rep table contains four rows and the Customer table contains 12 rows. How many rows would be contained in the Cartesian product of these two
Describe the results of the division process in relational algebra.
Describe the purpose of the product process in relational algebra.
Describe the purpose of the SUBTRACT command in relational algebra.
Describe the purpose of the INTERSECT command in relational algebra.
Are there any restrictions on the tables when using the UNION command? If so, what are these restrictions?
Describe the purpose of the UNION command in relational algebra.
Describe the purpose of the JOIN command in relational algebra.
Describe the purpose of the PROJECT command in relational algebra.
Describe the purpose of the SELECT command in relational algebra.
When do you use a make-table query?
When do you use an update query?
How do you join tables in an Access query?
How do you sort data in an Access query?
How do you create a computed field in an Access query?
How do you use an AND criterion to combine criteria in an Access query? How do you use an OR criterion to combine criteria?
How do you indicate criteria in an Access query?
How do you include a field in an Access query?
What is a primary key? What is the primary key for each table in the Colonial Adventure Tours database shown in Figures 1-15 through 1-19 in Chapter 1?Figure 1-15 GuideNum LastName FirstName Address
Describe the shorthand representation of the structure of a relational database. Illustrate this technique by representing the database for Colonial Adventure Tours shown in Figures 1-15 through 1-19
How is the term attribute used in the relational model? What is a more common name for attribute?
What is an un-normalized relation? Is it a relation according to the definition of the word relation?
Answer each of the following questions using the Solmaris Condominium Group data shown in Figures 1-21 through 1-25. No computer work is required.1. List the owner number, last name, and first name
Answer each of the following questions using the Colonial Adventure Tours data shown in Figures 1-15 through 1-19. No computer work is required.1. List the last name of each guide that does not live
Describe and give an example of each of the two principal B2B forms.
Define and contrast B2B and B2C e-commerce styles.
Identify and briefly explain five advantages and five disadvantages of e-commerce.
What does e-commerce mean and how did it evolve?
Using the contracting company’s ERD in Chapter 6, “Normalization of Database Tables,” Figure 6.15, create the equivalent OO representation.
Using the ERD shown in Appendix C, “The University Lab Conceptual Design Verification, Logical Design, and Implementation,” Figure C.22 (the Check_Out component), create the equivalent OO
Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. ) The Avion Sales database includes the
Convert the following relational database tables to the equivalent OO conceptual representation. Explain each of your conversions with the help of a diagram. The R&C Stores database includes the
Assume the following business rules:• A course contains many Sections, but each Section references only one course.• A Section is taught by one professor, but each professor may teach one or more
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Write a query to return the shortest path based only on reviews between members Abraham
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Write a query to display cuisine, restaurant, and owner for every “American” or
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Write a query to display member Frank Norwood and every restaurant that he has rated as
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Create a REVIEWED relationship between member Frank Norwood and the restaurant created
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Create a REVIEWED relationship between the member created above and the restaurant
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Update the “Hungry Much” restaurant created above to add the phone number “(931)
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Create a restaurant node with restaurant id is 10000, the name “Hungry Much”, and
Use the Food Critics Club (FCC) graph database that was created and used earlier in the text for use with Neo4j.Create a node that meets the following requirements. Use existing labels and property
What is the difference between using WHERE and embedding properties in a node when creating a pattern in Neo4j?
Explain the difference between using the same variable name and different variable names when matching multiple patterns in Neo4j.
Use the fact database and patron collection created in the text for use with MongoDB.Write a query to display the only the first name, last name, and age of students that are between the ages of 22
Use the fact database and patron collection created in the text for use with MongoDB.Write a query to retrieve the documents of patrons that are faculty and checked out book 5235, or that are
Use the fact database and patron collection created in the text for use with MongoDB.Write a query to retrieve only the first name, last name, and type of faculty patrons that have checked out at

Showing 400 - 500 of 650