New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
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
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
computer science
database concepts
Database Systems Design Implementation and Management 13th edition Carlos Coronel, Steven Morris - Solutions
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 using what you have learned in this chapter.a. Search for a data set that may interest you and
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 computer lab director assigns you the task of developing a data warehouse in which to keep track of 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 Tennessee (TN).b. The company has 300,000 customers (subscribers) distributed throughout the four states
Based on the following query:SELECT CUS_CODE, MAX(LINE_UNITS*LINE_PRICE)FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINEWHERE CUS_AREACODE = ‘615’GROUP BY CUS_CODE;How would you rewrite the query
Based on the following query:SELECT CUS_CODE, MAX(LINE_UNITS*LINE_PRICE)FROM CUSTOMER NATURAL JOIN INVOICE NATURAL JOIN LINEWHERE CUS_AREACODE = ‘615’GROUP BY CUS_CODE;Assuming that you follow the
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_QOH, P_PRICE, V_CODEFROM PRODUCTWHERE P_QOH < P_MIN AND P_MIN = P_REORDER’ AND
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATEFROM PRODUCT P, VENDOR VWHERE P.V_CODE = V.V_CODE AND V_STATE =
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATEFROM PRODUCT P, VENDOR VWHERE P.V_CODE = V.V_CODE AND V_STATE =
Based on the following query:SELECT P_CODE, P_DESCRIPT, P_PRICE, PRODUCT.V_CODE, V_STATEFROM PRODUCT P, VENDOR VWHERE P.V_CODE = V.V_CODE AND V_STATE =
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 equal to the minimum quantity, P_MIN. What optimizer hint would you use to ensure that your query
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 BY V_NAME;Assume that 10,000 vendors are distributed as shown in Table P11.18. What
Based on the following query:SELECT P_CODE, P_QOH*P_PRICEFROM PRODUCTWHERE P_QOH*P_PRICE > (SELECT AVG(P_QOH*P_PRICE) FROM PRODUCT)What is the likely data sparsity of the P_QOH and
Based on the following query:SELECT P_CODE, SUM(LINE_UNITS)FROM LINEGROUP BY P_CODEHAVING SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE);Write the command to create statistics for this table.
Based on the following query:SELECT P_CODE, SUM(LINE_UNITS)FROM LINEGROUP BY P_CODEHAVING SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE);Should you create an index? If so, what would the index column(s)
Based on the following query:SELECT P_CODE, SUM(LINE_UNITS)FROM LINEGROUP BY P_CODEHAVING SUM(LINE_UNITS) > (SELECT MAX(LINE_UNITS) FROM LINE);What is the likely data sparsity of the LINE_UNITS column?
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 INV_NUMBER LINE_NUMBER contains generates FK1 Cus CODE INV DATE Cus_LNAME cus_FNAME Cus_INITIAL Cus
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 INV_NUMBER PK,FK1 INV_NUMBER LINE_NUMBER contains generates FK1 Cus CODE INV DATE Cus_LNAME cus_FNAME
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 PRODUCTWHERE P_PRICE >= (SELECT AVG(P_PRICE) FROM
Based on the following query:SELECT EMP_LNAME, EMP_FNAME, EMP_DOB, YEAR(EMP_DOB) AS YEARFROM EMPLOYEEWHERE YEAR(EMP_DOB) = 1966;What is the likely data sparsity of the EMP_DOB column?
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, if you think that “Load the database” is the appropriate first step, label it “1.”)
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 of maintenance needs to be done: (a) corrective, (b) adaptive, and (c) perfective.a. An error in
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. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, and Anne
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 EMPLOYEE_1. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, 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 EMPLOYEE_1. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, 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 contains the records for employees John Cretchakov and Mary Chen. Given that information, what is the query
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 offices. They can also use a variety of personal mobile computing devices such as tablets, smartphones, and
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 the College of Business between January 1, 1960 and January 1, 2018 or who the dean of the College
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 Regulations (FAR) Part 135 (air taxi or charter) certificate, enforced by the FAA. The aircraft are available
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 of the various information needs of the company. The company’s operations are as follows.•
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, and MP3 players. She wants you to create a database to help her run her business. • When a
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 four aircraft. Aircrafts are identified by a unique registration number. Therefore, the aircraft
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. Aircrafts are identified by a unique registration number. Therefore, the aircraft registration number
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 table.Figure Q3.18.Data from Question 26:Suppose you wanted quick lookup capability to get a listing
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 for the INDEX table, and what would be the index key?Figure Q3.18. Table name: DIRECTOR DIR_NUM
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 Hollywoody 21-Jun-62 102 Goofy Table name: PLAY PLAY_NAME 1001 Cat On a Cold, Bare Roof 1002 Hold the Mayo,
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: BOOTH BOOTH PRODUCT BOOTH PRICE 1.5 1.25 1.25 Chips Chocolate Bar Chips Cola Energy Drink Energy
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 MACHINE_PRICE Table name: BOOTH BOOTH PRODUCT BOOTH PRICE 1.5 1.25 1.25 Chips Chocolate Bar Chips Cola Energy
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 MACHINE_PRICE Table name: BOOTH BOOTH PRODUCT BOOTH PRICE 1.5 1.25 1.25 Chips Chocolate Bar Chips Cola
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 Table name: BOOTH BOOTH PRODUCT BOOTH PRICE 1.5 1.25 1.25 Chips Chocolate Bar Chips Cola Energy Drink
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 MACHINE_PRICE Table name: BOOTH BOOTH PRODUCT BOOTH PRICE 1.5 1.25 1.25 Chips Chocolate Bar Chips Cola Energy
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 Crow€™s Foot ERD. Table name: AGENT (first Six attribute AGENT CODE AGENT LNAME AGENT_FNAME AGENT NTIAL AGENT AREACODE AGENT_PHONE 501 Alby Alex 713 228-1249 502 Hahn
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 AGENT LNAME AGENT_FNAME AGENT NTIAL AGENT AREACODE AGENT_PHONE 501 Alby Alex 713 228-1249 502 Hahn
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) representation.
Using your school€™s student information system, print your class schedule. The schedule probably would contain the student identification number, student name, class code, class name, class credit hours, class instructor name, the class meeting days and times, and the class room number.
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
Step by Step Answers
Get 50% OFF
Claim Now
