sample records to éach your progress. 4. Suppose you work in IT, and the sales team needs answers to three specific ques- tions. The data might be stored physically in seven tables. You know how to cre- ate Microsoft Access queries, but to learn more about database logic and design, you decide to study Figure 9-32, and then pretend to tell the database how to find the answers, step by step: a. Did any customers receive service after 5/4/2015? If so who were they? b. Did technician Marie Johnson put in more than six hours of labor on any ser- vice calls? If so, which ones? era c. Were any parts used on service calls in Washington? If so, what were the part 20 numbers, descriptions, and quantities? Interview the manager or

sample records to éach your progress. 4. Suppose you work in IT, and the sales team needs answers to three specific ques- tions. The data might be stored physically in seven tables. You know how to cre- ate Microsoft Access queries, but to learn more about database logic and design, you decide to study Figure 9-32, and then pretend to tell the database how to find the answers, step by step: a. Did any customers receive service after 5/4/2015? If so who were they? b. Did technician Marie Johnson put in more than six hours of labor on any ser- vice calls? If so, which ones? era c. Were any parts used on service calls in Washington? If so, what were the part 20 numbers, descriptions, and quantities? Interview the manager or

Fundamentals of Information Systems

9th Edition

ISBN:9781337097536

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter3: Database Systems And Big Data

Section: Chapter Questions

Problem 4PSE

See similar textbooks

Similar questions

Here's a situation to mull over: two students are interested in enrolling in the same class, but there's only room for one of them. What is it about a database that makes it so they can't sit together?
Consider given database schema and write triggers for each statement. Student ( regNo, sName, sCity, sCGPA, sAge)Course ( cCode, cName, credit_hours)Enrollment (regNo, cCode, semester,quality_points,Grade) 1- A trigger which display all data of student table whenever a record is inserted in Student table. 2- A trigger which deletes all data from course table whenever total number of records in “Course” table reaches 10. 3- A trigger which displays all data of “Enrollment” table whenever a record is deleted from “Enrollment” table. 4- A trigger which displays data of “Student” table on insertion of every 10th record. 5- A trigger that checks age of Student after insertion, delete all those employees whose age is above 25.
3. Database locking concept is used to solve the problem of a. Lost Update b. Uncommitted Dependency c. Inconsistent Data d. All of the above
Consider the relational database below, where the primary keys are underlined.employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name)Give a query for each of the following:a Give all managers in database a 10 percent raise.b Give managers in the database a 10 percent raise, unless the salary would be greaterthan $100,000. In such cases, give only 3 percent raise.c Delete all tuples in the works relation for employees of Small Bank Corporation
Should the social effects of records be looked at? Personal information that is sensitive should not be kept in the same database management system (DBMS) as information about an employee's salary and perks, like medical information. There are, however, some exceptions to this rule.
1. What are the three stages during the startup of an Oracle database? If a copy of the control file is corrupted, which stage of the startup would fail? Briefly explains why. 2. What are the SQL statements to perform the following tasks? Create a smallfile tablespace Hw2Tbs that contains a 32MB datafile in the directory C:\app\abc\oradata\csc544744\myData Add another 8MB to tablespace Hw2Tbs
You want to avoid data loss by fixing the four most common causes of database failure. What are they?
One of the tables that resulted from the DBA denormalizing some of the data in the TAL Distributors database so as to boost performance is as follows: Which field or fields in the Customer table (CustomerNum, CustomerName, Street, City, State, PostalCode, Balance, CreditLimit, RepNum, RepName) are responsible for the table no longer being in third normal form? In this scenario, what does the normal form of the denormalized table look like?
Suppose you're interested in recording the history of changes made to the takes relation. Have any assurances been made that unauthorized database administrators (or those who manage to crack an administrator's password) would be recorded in an audit trail of modifications made by this implementation? Your reply need to include many specifics.
Assume that your database system is down. Show off your understanding of database recovery techniques like write-through and deferred-write.
Consider the following database design: Also consider the virtual table ASSIGNMENTS, which doesn't meet the third normal form but is created by: CREATE VIEW ASSIGNMENT AS SELECT ASSIGN_NUM, ASSIGN_DATE, PROJ_NUM, EMPLOYEE.EMP_NUM, JOB.JOB_CODE AS ASSIGN_JOB, JOB_CHG_HOUR AS ASSIGN_CHG_HR, ASSIGN_HOURS, JOB_CHG_HOUR *ASSIGN_HOURS AS ASSIGN_CHARGE FROM ASSIGN, EMPLOYEE, JOB WHERE ASSIGN.EMP_NUM = EMPLOYEE.EMP_NUM AND EMPLOYEE.JOB_CODE = JOB.JOB_CODE; In SQL design the following queries for information search: Create and run a query to list employees who were hired before the year 1995. Create and run a query to list job code, job description, and employee last name, first name sorted by job description and employee last name. Create and run a query to list the name of employees who were assigned to the Rolling Tide project (which is one of the entries in the column PROJ_NAME). Create and run a query to list the project name, the number of employees worked for the project, and the…
Following on your BIG break to make a database for an… organization that organizes table tennis tournaments (also known as “Tourney”s) at their premises on behalf of clubs, you’ve written down the business rules as follows: One Match belongs to One Tourney, and not none. One Tourney has Many Matches, at least one and a maximum of 128. One Match takes place on One Table, and not none. One Table is used in Many Matches, and possibly none. One Match belongs to one Category, and not none. One Category appears in Many Matches, and possibly none and a max of 32. One Match involves Many Players, minimum 2 and maximum 4. One Player plays Many Matches, and possibly none. You have also been given a small sample of their records (which is not in the least in relational format), which may prove useful. It is below. Match Number Tourney Tourney Start Date Day Time Slot In Day Player Names(Team 1) Player Names(Team 2) Player IDs (Team 1) Player IDs(Team 2)…

SEE MORE QUESTIONS

Recommended textbooks for you

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781337097536

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Fundamentals of Information Systems

Computer Science

ISBN:

9781305082168

Author:

Ralph Stair, George Reynolds

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS