Questions and Answers of Database Concepts

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?
What is polyglot persistence, and why is it considered a new approach?
Explain why veracity, value, and visualization can also be said to apply to relational databases as well as Big Data.
How is stream processing different from feedback loop processing?
What is stream processing, and why is it sometimes necessary?
Explain the difference between scaling up and scaling out.
Explain why companies like Google and Amazon were among the first to address the Big Data problem.
What are the traditional 3 Vs of Big Data? Briefly, define each.
What is Big Data? Give a brief definition.
Create your own data analysis and visualization presentation. The purpose of this project is for you to search for a publicly available data set using the Internet and create your own presentation
The university computer lab's director keeps track of the lab usage, as measured by the number of students using the lab. This particular function is very important for budgeting purposes. The
What five graphical data characteristics does data visualization use to highlight and contrast data findings and convey a story?
Describe the different types of data and how they map to star schemas and data analysis. Give some examples of the different data types.
Is data visualization only useful when used with Big Data? Explain and Expand.
Describe Data Visualization? What is the goal of data visualization?
Describe the characteristics of predictive analytics. What is the impact of Big Data in predictive analytics?
The following data structure and constraints exist for a magazine publishing company.a. The company publishes one regional magazine each in Florida (FL), South Carolina (SC), Georgia (GA), and
Based on the following query:SELECT CUS_CODE, MAX(LINE_UNITS*LINE_PRICE)FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINEWHERE
Based on the following query:SELECT CUS_CODE, MAX(LINE_UNITS*LINE_PRICE)FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINEWHERE
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE, V_CODEFROM PRODUCTWHERE P_QOH <
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATEFROM PRODUCT P, VENDOR VWHERE
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATEFROM PRODUCT P, VENDOR VWHERE
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATEFROM PRODUCT P, VENDOR VWHERE
Assume that you have 10,000 different products stored in the PRODUCT table and that you are writing a Web-based interface to list all products with a quantity on hand (P_QOH) that is less than or
Using Table 11.4 as an example, create two alternative access plans.
Based on the following query:SELECT V_CODE, V_NAME, V_CONTACT, V_STATEFROM VENDORWHERE V_STATE = ‘TN’ORDER
Based on the following query:SELECT P_CODE, P_QOH*P_PRICEFROM PRODUCTWHERE
Based on the following query:SELECT P_CODE, SUM(LINE_UNITS)FROM LINEGROUP BY P_CODEHAVING SUM(LINE_UNITS) >
Based on the following query:SELECT P_CODE, SUM(LINE_UNITS)FROM LINEGROUP BY P_CODEHAVING SUM(LINE_UNITS) >
Based on the following query:SELECT P_CODE, SUM(LINE_UNITS)FROM LINEGROUP BY P_CODEHAVING SUM(LINE_UNITS) >
Based on the ER model shown in Figure P11.7 and on the query shown after the figure.Figure P11.7:Should you create an index? Why or why not? INVOICE CUSTOMER LINE PK Cus CODE PK INV_NUMBER PK,FK1
Based on the ER model shown in Figure P11.7 and on the query shown after the figure.Figure P11.7:What is the likely data sparsity of the P_PRICE column? INVOICE CUSTOMER LINE PK Cus CODE PK
Based on the ER model shown in Figure P11.7 and on the query shown after the figure.Figure P11.7:Given the following querySELECT P_CODE, P_PRICE FROM
Based on the following query:SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEAR(EMP_DOB) AS YEARFROM EMPLOYEEWHERE
How is the processing of SQL DDL statements (such as CREATE TABLE) different from the processing required by DML statements?
Describe the three most common problems with concurrent transaction execution. Explain how concurrency control can be used to avoid those problems.
What does serializability of transactions mean?
You have been assigned to design the database for a new soccer club. Indicate the most appropriate sequence of activities by labeling each of the following steps in the correct order. (For example,
In a construction company, a new system has been in place for a few months and now there is a list of possible changes/updates that need to be done. For each of the changes/updates, specify what type
What is a sequence? Write its syntax.
What is the difference between a view and a materialized view?
What is the difference between using a subquery with a CREATE TABLE command and using a subquery with an INSERT command?
What is the difference between an INSERT command and an UPDATE command?
Explain when an ALTER TABLE command might be needed.
What is the purpose of a CHECK constraint?
What is the difference between a column constraint and a table constraint?
What type of integrity is enforced when a primary key is declared?
What two things must a SQL programmer understand before beginning to craft a SELECT query?

Showing 500 - 600 of 650