Concepts Of Database Management 10th Edition Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt - Solutions

Who at Pitt Fitness determines access privileges for users and enters the appropriate authorization rules in the DBMS?a. Chief security officerb. Chief information officerc. Database administratord. Big data administrator
Pitt Fitness suspects their system contains software that enables someone to surreptitiously record keystrokes.What might their system be infected with?a. Spywareb. Keywarec. Recordersd. Keystroke crackers
Pitt Fitness requires that all employees come into the main office (Shadyside) on a Saturday to practice a step-bystep plan to minimize the effects of a natural disaster. For example, if a freak tornado hit the city of Pittsburgh, Pitt Fitness’s computer systems might be incapacitated. What type
Assume that a destructive storm hit the city of Pittsburgh and it took 20 hours for Pitt Fitness’s computer specialists to return the system to normal working operation. Twenty hours, the length of time this would normally take in a disaster situation, would be considered the _____.a. Recovery
As a backup system, Pitt Fitness replicates their DBMS to multiple hard drives that can process reservations if another hard drive fails. What is this system for backup called?a. HDb. RAIDc. REPLICATEd. Multiplicity
In the summer months, Pitt Fitness often suffers from power outages due to thunderstorms. What would be a good investment to prevent losing data during power outages?a. A dedicated electrical lineb. A lightning rodc. An uninterruptible power supplyd. Moving their computers outside the city
Considering Pitt Fitness is a privately held company, which of the following data archiving laws must they comply with?a. Sarbanes–Oxleyb. Patriot Actc. FERPAd. None of the choices is required of the company.
What is the repository at Pitt Fitness that contains the log of database maintenance, license keys, and updates to the system?a. DB Diaryb. Check list registerc. Run-bookd. Captain notes
The Sports Physical Therapy group has hired a student intern who is an expert in using the software Tableau.What position should that intern fill?a. Data analystb. Database administratorc. SQL programmerd. Python programmer
Sports Physical Therapy is looking to hire an employee that is certified in Microsoft Office to help run the Access database, analyze data with Excel, and use other Office tools. What certification should the Human Resources Department look for?a. OCAb. SQLc. MOSd. HANA
If you consider that Sports Physical Therapy is a large organization employing many computer personnel, who is the employee that the database administrator most likely reports to?a. Chief executive officerb. Chief information officerc. Chief personnel officerd. Chief data analyst
An employee at Sports Physical Therapy who had access to the database management system has been fired for inappropriate conduct. Immediately, their database privileges must be rescinded. What is the SQL command that will accomplish this?a. REVOKEb. RESCINDc. REMOVEd. REPLACE
Because Sports Physical Therapy deals with sensitive health data, only certain employees should be able to access the sensitive data. What is the process of granting specific rights and privileges to a user?a. Encryptionb. Authenticationc. Authorizationd. Views
The database at Sports Physical Therapy that contains the health records of the patients is essential to the survival of the business and all the business processes. In terms of disaster planning, this would be considered a system that is _____.a. Highly criticalb. Unbelievably criticalc. Mission
Which of the following laws most likely governs the data archiving of the database at Sports Physical Therapy, considering it is a privately held company?a. HIPAAb. FERPAc. SOXd. Patriot Act
Sports Physical Therapy regularly uses hardware, software, and databases in a ___________ system and tests and develops applications in a ____________ system.a. Test, liveb. Test, sandboxc. Production, testd. Production, live
How much does Amazon Web Services cost?
Which of the following database architectures is most closely aligned with traditional, enterprise-level relational databases?a. Centralizedb. Client/serverc. Data warehoused. Distributed
Identify the characteristics of a new application that lends itself to the MEAN or MERN stack.
Which of the following database architectures best describes how Access works when the database is stored on a file server and accessed by many users with personal computers?a. Centralizedb. Client/serverc. Data warehoused. Distributed
What competitors dominate the operating systems for mobile devices today?
Which of the following best describes the concept of an OLAP cube?a. Selected columns and rows from one or more tables.b. A read-only snapshot of data organized in levels and hierarchies of categories.c. An object-oriented key/value pair description of data.d. A BLOB.
The term “big data” is trendy and means different things to different businesses. Ask five people in the Computer Science Department within your college what the term means to them, and organize the results.
If you wanted to evaluate Access data using Excel PivotTables and PivotCharts, what would be the first step?a. Select the data you want to evaluate with a query.b. Export all of your tables to text files.c. Create OLAP cubes in Access.d. Use the Database Business Intelligence Wizard in Access.
How does a browser and the web represent an application of client/server computing?
Big data typically does not include which of the following?a. Clicks on webpagesb. Imagesc. Billing informationd. Keyword search data
What hierarchies and levels of data do you see in Figure 9-10? ProjectEstimates ClientD Record ClientName Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors 1 Tri-Lakes Realtors Project ProjectStartDate. Taski 2/6/2019
Identify the characteristics of the business problem that lends itself to an Access solution.
For the following exercises, you will answer problems and questions from management at JC Consulting. You do not need to use the JCConsulting database for any of these exercises.If JC Consulting used Google Analytics, what type of information might they learn?a. What areas of the country had the
Which of the following databases would probably be considered for a web app if your company had a significant commitment to JavaScript?a. IBM Db2b. Microsoft Accessc. Microsoft SQL Serverd. MongoDB
As JC Consulting grows, they may need to convert their Access application into technologies that can handle more users and locations. What solution stacks would you recommend they consider?
For the following exercises, you will answer problems and questions from management at JC Consulting. You do not need to use the JCConsulting database for any of these exercises.JC Consulting wants to upgrade some Access data to a larger, enterprise-scale database management system.Which is the
Why might distributed databases work extremely well for software version control projects but not so well for traditional transaction systems?
Which of the following types of databases would most likely be used for tracking connections between people?a. Documentb. Relationalc. Graphd. Flat file
Pitt Fitness would like to enhance their web presence and enable the exchange of data on the web. What type of markup language should they use and why?
Which of the following is a NoSQL database?a. IBM Db2b. Microsoft Accessc. Microsoft SQL Serverd. MongoDB
What makes Access a RAD (rapid application development) framework, and when is it appropriate to choose Microsoft Access as the relational database system for a new application?
Which file extension is a type of XML file?a. Xlsxb. Jsonc. Txtd. Dbf
Describe some of the big data that Pitt Fitness might collect and find useful.
Which menu option on the More button of the External Data tab of the ribbon in Access do you use to export data to SQL Server?a. ODBC Databaseb. dBASE Filec. SQL Serverd. Relational
What primary limitation of relational database management systems do NoSQL database management systems address?
Line charts are best used for which type of visualization?a. Comparing valuesb. Identifying relationshipsc. Showing trends over timed. Displaying cumulative totals
When creating a query in Access for data that you later want to analyze as a PivotTable or PivotChart in Excel, how many fields do you typically use in the visualizations?a. 1b. 2c. 3d. At least 4 or more
The Sports Physical Therapy clinic is considering centralizing their database operations. What are their options for this centralized computing?
Object-oriented database management systems are most appropriate for what types of data, and in what applications are they commonly implemented?
The Sports Physical Therapy clinic is having trouble with the performance of their Access database. They would like to split the database between front end and back end to improve performance. How would they do this?
Pitt Fitness, having transitioned to a larger database system to accommodate their recent growth, is now considering moving their database to the cloud. However, management is concerned that they will be sharing the resources with other cloud clients. The cloud provider assures Pitt Fitness that
How do you start using Google Analytics at a website?
Pitt Fitness stores their Access database on a centralized file server for usage by a few employees. What type of architecture are they using?a. Client/serverb. Cloud-basedc. LAN-basedd. Front end
Why might it be helpful to export data from an Access database to an HTML file?
Pitt Fitness has hired summer interns for data analysis. The interns are running complex queries that take enormous processing power. The clerks at Pitt Fitness have found that registering customers and classes has slowed to an unacceptable pace. What type of system does Pitt Fitness need to
Where can you find more examples of data visualizations?
The summer interns at Pitt Fitness explain to management that they will be initially summarizing data in a crosstabular organization. What type of tool are the interns using to create these cubes of data?a. OLTPsb. Scalablesc. Thin clientsd. PivotTables
Considering that Pitt Fitness is a relatively new company, what types of computer programs does Pitt Fitness not have?a. Legacyb. Dinosaurc. JavaScriptd. object-oriented
Managers at Pitt Fitness want developers to write back-end applications that interact with the centralized database. Which computer language should they use?a. Java Liteb. JavaScriptc. Javad. JavaVB
Pitt Fitness has decided to employ Google Analytics to analyze traffic on their website. The first report has come in with a recording of the bounce rate. What does the bounce rate measure?a. A site visitor that views many pages on the siteb. A site visitor from a mobile devicec. A site visitor
Pitt Fitness has hired a full-time data analyst to produce various data visualizations to help management better serve their customers. Which of the following tools could the new employee use for data visualization?a. Excelb. Power BIc. Tableaud. Excel, Power BI, and Tableau
The new data analyst at Pitt Fitness wants to create a chart that compares the monthly class registrations by displaying them in horizontal lines. What type of chart would be appropriate?a. Columnb. Linec. Pied. Bar
The data analyst at Pitt Fitness is creating a chart that displays the relationship between advertising expenses and new customers. What type of chart is she using?a. Barb. Areac. XY Scatterd. Map
When physical therapists are scheduled to see a patient, they ask the clerk for a “hard copy” to view what is needed for that day’s session with the specific treatments. What are the physical therapists referring to when they request a hard copy?a. A poster board with the daily scheduleb. A
The Sports Physical Therapy clinic is considering moving their database to the cloud. Which of the following is the current market leader in cloud storage, and therefore would be a safe bet for the organization?a. IBMb. Oraclec. Microsoftd. AWS
The Sports Physical Therapy clinic’s Access database is stored on a centralized computer for usage by a few trusted colleagues. They are therefore running a ______ application.a. Client/serverb. Back/endc. Front/endd. Crowdsourced
As the Sports Physical Therapy clinic grows, management is considering moving to a larger database management system, where the clients perform the presentation functions, a database server performs the database functions, and separate centralized computers perform the business functions as well as
The Sports Physical Therapy clinic has an Access database for patients, therapists, and appointments. The clinic also has other systems that record information such as insurance details, accounting of payments, and miscellaneous employee data. The IT manager at the organization wants to consolidate
The IT manager at the Sports Physical Therapy clinic created a system to consolidate and summarize data from its Access database and other insurance, accounting, and employee systems to produces management reports.What database technology optimizes data for querying, analyzing, and reporting?a.
The summer intern at Sports Physical Therapy clinic has been using Excel to analyze some data. The intern is displaying a crosstabular organization of the data with the session date as the row heading, the therapist ID as the column heading, and the session number as a counted value. What Excel
The Sports Physical Therapy clinic is not a large business, but management still would like to analyze their “big data” using a moderately priced service. Which of the following would be appropriate for this task?a. Hadoopb. Amazon Web Servicesc. IBMd. Google Analytics
The summer intern at Sports Physical Therapy clinic would like to do data visualizations that are more sophisticated than the software Excel can provide. Which of the following solutions would be the best to use?a. Microsoft Accessb. Microsoft Power BIc. Microsoft Projectd. Microsoft OneNote
The summer intern at Sports Physical Therapy clinic is using Excel to create some interesting charts of the activities at the clinic. The intern would like to show trends over time based on a cumulative group of sessions.Which of the following chart types would be appropriate?a. XY Scatterb. Mapc.
List ProjectLineItemID values that are related to ProjectID 3.a. ProjectLineItemIDs 1 and 2b. ProjectLineItemIDs 8 and 9c. ProjectLineItemIDs 39, 40, and 41d. ProjectLineItemID 4 EmployeelD LastName FirstName
Which projects had an estimated start date prior to 1/1/2020?a. ProjectIDs 1, 2, 3, and 7b. ProjectIDs 8, 16, and 24c. ProjectIDs 8–30d. ProjectID 1, 9, and 17 EmployeelD LastName FirstName
What client is not a government entity?a. Project Lead The Wayb. Aspire Associatesc. The HELPCardd. All are government entities. EmployeelD LastName FirstName
Which employee has a salary value of $8,100?a. Nathan Gellerb. Nigel Horvatc. Hector Garciad. Nada Prohm EmployeelD LastName FirstName
List the name of the client related to ProjectID 3.a. SecureCom Wirelessb. Loren Groupc. Midstates Auto Auctiond. Project Lead The Way EmployeelD LastName FirstName
For the record with a ProjectLineItemID value of 7, why does the Factor field contain 1.3?a. It represents an estimated increase of 1.3% due to risk or complexity for that task.b. It represents an estimated increase of 30% due to risk or complexity for that task.c. It represents an estimate of 1.3
Find the total, average, and count of the Salary field for all employees grouped by title. Sort the records in ascending order by title. What is the average of the salaries for the first title in the results?a. $6,650.00b. $6,000.00c. $6,375.00d. $4,366.67 TaskID Description CODE01 Code PHP CODE02
Select the records in the TaskMasterList table with a CategoryID field value of Database and then create an update query to update their Estimate field values by 10 percent. How many records are updated and what is the highest updated Estimate field value?a. 5 and $1,100b. 5 and $1,000c. 40 and
Make a table with the ClientName, ProjectID, ProjectStartDate, and TaskID fields for all projects with a TaskID field value of MEET00. Sort the records in ascending order by the ProjectStartDate field. Twenty-four records should be selected. Name the table InitialMeetings. What is the ClientName
Complete the following statement to list the employee ID, first name, and last name of all employees. _____EMPLOYEES OVER (EmployeeID, LastName, FirstName) GIVING Answera. PROJECTb. JOINc. INTERSECTIONd. SELECT TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03 Code Ruby on
Complete the following statement to list all information from the TaskMasterList table for task ID CODE05. SELECT TaskMasterList WHERE _____ GIVING Answera. TaskID = CODE05b. TaskID = 'CODE05'c. CODE05 = 'TaskID'd. (TaskID, CODE05) TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03
Complete the following statements to list the project ID, project start date, client ID, and client name for each project. JOIN Projects Clients WHERE _____ GIVING Temp1 PROJECT Temp1 OVER (ProjectID, ProjectStartDate, ClientID, ClientName) GIVING Answera. ClientID.Projects = ClientID.Clientsb.
Complete the following statements to list the project ID, project start date, client ID, and client name for each project created for the employee with the last name of Winter. _____ Projects Clients WHERE Projects.ClientID = Clients.ClientID GIVING Temp1 JOIN Temp1 Clients WHERE Temp1.EmployeeID =
Select the EmployeeID, LastName, HireDate, and Salary fields for employees hired on or before 1/1/2020. Create a calculated field named Bonus that is calculated as 50 percent of their monthly salary, which is stored in the Salary field. What is the bonus amount for Lopez?a. 2500b. 12,400c. 6200d.
Select the ProjectID, ProjectStartDate, ClientName, TaskID, and Description fields for TaskID TEST01 and a ProjectStartDate after 1/1/2020. Sort the records in ascending order by ProjectStartDate. What are the ProjectStartDate and ClientName values in the first record of the results?a. 1/6/2020,
Select the ProjectID, ClientName, TaskID, and Description fields for TaskIDs TEST01 or TEST02. Sort the records in ascending order by ProjectID and then by TaskID. What are the ProjectID and TaskID values of the first two records in the results?a. 2, TEST01 and 4, TEST01b. 2, TEST01 and 2, TEST02c.
If your database is performing well, why is it still important to concern yourself with techniques that improve the performance of queries?
Which of the following tasks is not priced by the project?a. TaskID DB01 Design relational databaseb. Task ID DB04 Install SQL Server databasec. Task ID MEET00 Initial customer meetingd. Task ID CODE04 Code SQL EmployeelD LastName FirstName
For the record with a ProjectLineItemID value of 7, why does the Quantity field contain 20?a. It represents an estimate of 20 hours.b. It represents an estimate of 20 minutes.c. It represents an estimate of 20 projects.d. It represents the project ID. EmployeelD LastName FirstName
Answer each of the following questions using the JCC data shown in Figure 1-5. No computer work is required.Figure 1-5What is the cost for an initial meeting with a client, TaskID MEET00?a. $100b. $150c. $0 (no charge)d. $1 EmployeelD LastName FirstName
Answer each of the following questions using the JCC data shown in Figure 1-5. No computer work is required.Figure 1-5What is the cost for creating a shopping cart, TaskID CODE15?a. $150/hourb. $125/projectc. $100/monthd. $125/hour EmployeelD LastName FirstName
Which instructor lives on Webster Avenue?a. Vicki Peguesb. Neda Tahanc. Memo Saidd. Luke Lane Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn
Who is the oldest customer?a. Glenn Spencerb. Jess Hillc. Gene Shafferd. Nour Aboud Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D Wylie
What class did Terrance Feldman reserve?a. Barreb. Barbell Powerc. Yoga Balanced. Yogalates Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D
In what location and room is ClassID 9, Barre, held?a. Shadyside, 159Bb. Oakland, Mainc. Shadyside, Maind. Oakland, 159B Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661
What time does ClassID 24, Intense Cycle, begin?a. 2 pmb. 1 pmc. 12 pmd. 10 am Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D Wylie
How long is the ClassID 15, Bootcamp?a. 60 minutesb. 45 minutesc. 30 minutesd. 90 minutes Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D
Who teaches ClassID 21, Combination?a. Maria D’Angelob. Robert Sistoc. Michael Nguyend. Megan Kobinski Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367
What customer has reservation 2100014?a. Debbie Thornb. Tamara Larac. Sylvia Devitod. Margo Patterson Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367
When was customer Ramiro Sanchez born?a. 10/21/2000b. 4/20/1984c. 2/16/1957d. 4/1/1953 Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D
How many classes are offered on Mondays?a. 2b. 3c. 0d. 5 Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D Wylie Ave 9087 Monanca Pl 45

Showing 300 - 400 of 497

Concepts Of Database Management 10th Edition Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt - Solutions

Step by Step Answers