All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Hire a Tutor
AI Study Help
New
Search
Search
Sign In
Register
study help
computer science
database concepts
Questions and Answers of
Database Concepts
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?
What string function should you use to list the first three characters of a company’s EMP_LNAME values? Give an example, using a table named EMPLOYEE.
What Oracle function should you use to calculate the number of days between your birthday and the current date?
What MS Access/SQL Server function should you use to calculate the number of days between the current date and January 25, 1999?
Given the employee information in Question 19, what is the query output for the MINUS query? (List the query output.)Data from Question 19.Suppose that you have two tables, EMPLOYEE and EMPLOYEE_1.
Given the employee information in Question 19, what is the query output for the INTERSECT query? (List the query output.)Data from Question 19.Suppose that you have two tables, EMPLOYEE and
Given the employee information in Question 19, what is the query output for the UNION ALL query? (List the query output.)Data from Question 19Suppose that you have two tables, EMPLOYEE and
Suppose that you have two tables, EMPLOYEE and EMPLOYEE_1. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, and Anne McDonald. The EMPLOYEE_1 table
What does it mean to say that SQL operators are set-oriented?
What are the three types of results a subquery can return?
What is the difference between the COUNT aggregate function and the SUM aggregate function?
What is a recursive join?
How would you describe a condition in which one attribute is dependent on another attribute when neither attribute is part of the primary key?
Why is a table whose primary key consists of a single attribute automatically in 2NF when it is in 1NF?
What is a partial dependency? With what normal form is it associated?
When is a table in 3NF?
Global Unified Technology Sales (GUTS) is moving toward a “bring your own device” (BYOD) model for employee computing. Employees can use traditional desktop computers in their
Tiny College wants to keep track of the history of all administrative appointments (date of appointment and date of termination). The Tiny College chancellor may want to know how many deans worked in
Is it possible for a book to appear in the BOOK table without appearing in the PRODUCT table? Why or why not?
What is a disjoint subtype? Give an example.
Use the following description of the operations of the RC_Charter2 Company to complete this exercise.¢ The RC_Charter2 Company operates a fleet of aircraft under the Federal Air
Luxury-Oriented Scenic Tours (LOST) provides guided tours to groups of visitors to the Washington D.C. area. In recent years, LOST has grown quickly and is having difficulty keeping up with all
Create a Crow’s Foot notation ERD to support the following business operations:• A friend of yours has opened Professional Electronics and Repairs (PEAR) to repair smartphones, laptops, tablets,
What is a recursive relationship? Given an example.
Create the relational diagram.Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of
Create the ERD.Use the database shown in Figure P3.24 to answer this Problem. ROBCOR is an aircraft charter company that supplies on-demand charter flight services using a fleet of four aircraft.
Use the database composed of the two tables shown in Figure Q3.18.What would be the conceptual view of the INDEX table that is described in question 26? Depict the contents of the conceptual INDEX
Use the database composed of the two tables shown in Figure Q3.18.Suppose you wanted quick lookup capability to get a listing of all plays directed by a given director. Which table would be the basis
Use the database composed of the two tables shown in Figure Q3.18.Identify the primary keys.Figure Q3.18. Table name: DIRECTOR DIR_NUM DIR_LNAME DIR_DOB 100 Broadway 12-Jan-65 18-Nov-53 101
Using the tables in Figure Q3.13, create the table that results from MACHINE DIFFERENCE BOOTH.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT MACHINE_PRICE Table name:
Create the table that results from applying an INTERSECT relational operator to the tables shown in Fig Q3.13.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT
Write the relational algebra formula to apply an INTERSECT relational operator to the tables shown in Figure Q3.13.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT
Create the table that results from applying a UNION relational operator to the tables shown in Fig Q3.13Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT MACHINE_PRICE
Write the relational algebra formula to apply a UNION relational operator to the tables shown in Figure Q3.13.Figure Q3.13: Database name: Ch03_VendingCo Table name: MACHINE MACHINE_PRODUCT
Create the table that would result from πstu_code,dept_code(student ⋈ professor).
Create the table that would result from πstu_code(student).
Write the business rules that are reflected in the ERD shown in Figure P2.17.
Describe the relationships (identify the business rules) depicted in the Crow’s Foot ERD shown in Figure P2.13.
Create the UML class diagram that reflects the entities and relationships you identified in the relational diagram.
Create the basic Crow’s Foot ERD for Tiny College.
Use the contents of Figure 2.1 to work on this problem.Given the business rule(s) you wrote in Problem 1, create the basic Crows Foot ERD. Table name: AGENT (first Six attribute AGENT
Use the contents of Figure 2.1 to work on this problem.Write the business rule(s) that governs the relationship between AGENT and CUSTOMER.FIGURE 2.1 Table name: AGENT (first Six attribute AGENT CODE
What is a relationship, and what three types of relationships exist?
How would you model Question 6 with an OODM?
Why is an object said to have greater semantic content than an entity?
Consider the scenario described by the statement “A customer can make many payments, but each payment is made by only one customer” as the basis for an entity relationship diagram (ERD)
Using your schools student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name,
What is metadata?
Explain the differences between data, information, and a database.
What is structual independence, and why is it important?
Define each of the following terms:a. Datab. Fieldc. Recordd. File
Showing 600 - 700
of 697
1
2
3
4
5
6
7