Questions and Answers of Database Concepts

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
Use the fact database and patron collection created in the text for use with MongoDB.Write a query to retrieve the _id, display name and age of students that have checked out a book in the cloud
Use the fact database and patron collection created in the text for use with MongoDB.Modify the document entered in the previous question with the following data. Do not replace the current
Use the fact database and patron collection created in the text for use with MongoDB.Create a new document in the patron collection. The document should satisfy the following requirements:First name
Explain the difference in processing when using an explicit and and an implicit and with MongoDB.
Explain the functions used to enable pagination of results in MongoDB.
Describe the difference between using $push and $addToSet in MongoDB.
Explain what an upsert does.
What is the difference between a replacement update and an operator update in MongoDB?
Create an Order data entry screen, using the ORDERS and ORDER_LINE tables in the RobCor database. (To complete this problem successfully, you should know how to use frames and ColdFusion tags. Please
Create an Order data-entry screen, using the ORDERS and ORDER_LINE tables in the RobCor database. To do this, you can use frames and other advanced ColdFusion tags. Consult the online manual and
Describe the Web page development problems related to database parent/child relationships.
Transaction management is critical to the e-commerce environment. Given the assertion made in Item 3, how is transaction management supported?
Discuss the following assertion: The web is not capable of performing transaction management.
Describe the basic services provided by the ColdFusion Web application server.
What are scripts, and how are they created in ColdFusion?
Bsed on the following query:SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEXFROM EMPLOYEE WHERE EMP_SEX
Verify the conceptual model you created in Appendix B, Problem 4. Create a data dictionary for the verified model.
Verify the conceptual model you created in Appendix B, problem 3. Create a data dictionary for the verified model.
An examination of the UCL's Inventory Management module reporting requirements uncovered the following problems:• The Inventory module generates three reports, once of which is an Inventory
Modern businesses tend to provide continuous training to keep their employees productive in a fast-changing and competitive world. In addition, government regulations often require certain types of
Describe and discuss the ER model's treatment of the UCL's inventory/order hierarchy:a. Categoryb. Classc. Typed. Subtype
How would you verify the ER diagram shown in Figure QC.4? Make specific recommendations.Figure QC.4: PART PART_SUP VENDOR OPK,FK1PART NUM PK,FK2 VEND CODE PK PART NUM PK VEND CODE PART_PROD PK,FK2
What major factors should be addressed when database system performance is evaluated? Discuss each factor briefly.
What steps must be completed before the database design is fully implemented? (Make sure that you list the steps in the correct sequence and discuss each step briefly.)
Why must a conceptual model be verified? What steps are involved in the verification process?
You have just been employed by the ROBCOR Trucking Company to develop a database. To gain a sense of the database’s intended functions, you have spent some time talking to ROBCOR’s employees and
Use the following brief description of operations as the source for the next database design:All aircraft owned by ROBCOR require periodic maintenance. When maintenance is required, a maintenance log
Create an ER diagram for a hardware store. Make sure that you cover (at least) store transactions, inventory, and personnel. Base your ER diagram on an appropriate set of business rules that you
Suppose a manufacturer produces three high‑cost, low‑volume products: P1, P2, and P3. Product P1 is assembled with components C1 and C2; product P2 is assembled with components C1, C3, and C4;
Create the initial ER diagram for a video rental shop. Use (at least) the following description of operations on which to base your business rules.The video rental shop classifies movie titles
Create the initial ER diagram for a car dealership. The dealership sells both new and used cars, and it operates a service facility. Base your design on the following business rules:a. A salesperson
Using an ER diagram, illustrate how the change you made in problem 1 affects the relationship of the USER entity to the following entities:LAB_USE_LOGRESERVATIONCHECK_OUTWITHDRAW
Modify the initial ER diagram presented in Figure B.19 to include the following entity supertype and subtypes: The University Computer Lab USER may be a student or a faculty member.
What is a module interface, and what does it accomplish?
What is a module, and what role does a module play within the system?
Write the connectivity and cardinality for each of the entities shown in Question 4.Data from Question 4:What business rule(s) and relationships can be described for the ERD in Figure QB.4?Figure
What business rule(s) and relationships can be described for the ERD in Figure QB.4?Figure QB.4: PART VEND PART VENDOR PK PART COOE O PK,FK1 VEND ID PKFK2 PARI CODE PK VEND R PART_PROD PK,FK1 PART
What is the difference between the database design scope and its boundaries? Why is the scope and boundary statement so important to the database designer?
Why is the organizational structure relevant to the database designer?
What factors relevant to database design are uncovered during the initial study phase?
In Oracle, what is a database profile?
In Oracle, what is a database role?
Using a single sentence, explain the role of databases in organizations. Then explain your answer.
Explain what it means for a database to be aggregate aware.
Explain why graph databases tend to struggle with scaling out?
What is the difference between a column and a super column in a column family database?
Briefly explain the difference between row-centric and column-centric data storage.
How are the value components of a key-value database and a document database different?
What are the four basic categories of NoSQL databases?
Briefly explain how HDFS and MapReduce are complementary to each other.
Explain the basic steps of MapReduce processing.
What is the difference between a name node and a data node in HDFS?
What are the key assumptions made by the Hadoop Distributed File System approach?

Showing 500 - 600 of 697