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
concepts of database management
Concepts Of Database Management 10th Edition Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt - Solutions
Which facility does not have the three senior classes: Maturity, Endurance, and Strength, Maturity Classics, andAgility for Seniors?a. Shadysideb. Downtownc. Oaklandd. All of the facilities have the three senior classes Instructors InstructoriD InstructorLastName InstructorFirstName
How many classes are offered at the Downtown location at 6:00 pm?a. 1b. 2c. 3d. 4 Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn Way 245D Wylie
What two classes did Charles Hatcher sign up for?a. Aquasize, Aqua Strength and Cardiob. Barre, Barre Limitedc. Cycle, Cycle and Strengthd. HIIT, Bootcamp Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode
Where does Juan Varlano teach his classes?a. Oakland and Downtownb. Oakland onlyc. Oakland and Shadysided. Shadyside and Downtown Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn
Which class holds the largest number of participants?a. Yogab. Cyclec. Barbell Powerd. Combination Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode InstructorEmail Address 15A Penn Ave 2661 Butler St 2367 Barn
What therapist lives in Palm Rivers?a. Steven Wilderb. Bridgette McClainc. Saritha Naird. Jonathan Risk TherapyCode
What patient lives in Palm Rivers?a. Tierra Fallsb. Ben Odepaulc. Susan Houghlandd. Andre Marino TherapyCode
Which patient has the highest balance?a. Joseph Kingb. Robbie Koehlerc. Latisha Cullingd. Tammy Wilson TherapyCode
Which therapy takes the longest time?a. Massageb. Education and training for patient self-managementc. Ultrasoundd. Electrical stimulation TherapyCode
What treatment is Ben Odepaul having?a. Paraffin bathb. Knee strappingc. Electrical stimulationd. Hot or cold pack application TherapyCode
Who is having self-care/home management therapy?a. Tammy Wilsonb. Tobey Shortc. Brianna Waggonerd. Isaiah Venable TherapyCode
What therapist is performing unlisted modality on 10/17/2021?a. Steven Wilderb. Bridgette McClainc. Saritha Naird. No therapist has that session TherapyCode
Which patient is undergoing aquatic therapy with therapeutic exercises? What is the length of the session? Whois the therapist in charge?a. Tierra Falls, 15 minutes, Bridgette McClainb. Tierra Falls, 30 minutes, Jonathan Riskc. Tierra Falls, 30 minutes, Bridgette McClaind. Robbie Koehler, 30
What patient is therapist Saritha Nair seeing on 10/18/2021?a. Susan Houghlandb. Isaiah Venablec. Tierra Fallsd. Latisha Culling TherapyCode
Why is it customary to list the primary key field as the first field in a table?
Which SQL operator provides a concise way of creating a condition to match a specific list of criteria?a. BETWEENb. CONTAINSc. INd. NOT
Write an SQL query that displays the therapies and their unit of time for the therapies that include the word bath, hot, or electrical.
Which of the following is not an aggregate function used to calculate information on groups of records?a. SUMb. MINc. COUNTd. SUBTOTAL
Write an SQL query to display every therapist’s first name and last name as their full name, but only for those instructors not living in zip code 72511.
Which SQL clause sorts the selected records in ascending order by FirstName within LastName?a. ORDER BY FirstName, LastNameb. ORDER BY FirstName, LastName ASCc. ORDER BY LastName, FirstNamed. ORDER BY LastName & FirstName
Which SQL clause would join a Customers table with an Orders table assuming that they are related in a one-to-many relationship on a field called CustID in both tables?a. WHERE Customers.CustID = Orders.CustIDb. WHERE Customers = Orders AND CustID = CustIDc. WHERE Customers.CustID & Orders.CustIDd.
Which SQL keyword starts an SQL statement to select fields and records from one or more related tables?a. LISTb. SELECTc. SORTd. SUM
Which SQL keyword(s) start an SQL statement to append a new record to a table?a. ADDb. APPENDc. CONCATENATEd. INSERT INTO
Which SQL keyword identifies the tables that are involved in a SELECT query?a. FROMb. HAVINGc. TABLEd. WHERE
Which symbol is a wildcard representing any number of characters?a. *b. < >c. &d. #
The _____ operator allows you to select the records that match each condition separately, and then combine them into a single view.a. COMBINEb. MATCHc. UNIONd. MERGE
What is another term for a subquery?a. Outer queryb. Inner queryc. Union queryd. Aggregate query
Which of the following is the most sought-after language for programmers, according to codingsight.com?a. C++b. Javac. Pythond. SQL
Which of the following is not true about a view?a. It provides access to a subset of fields and records in one or more tables.b. It consists of a duplicate copy of the selected data.c. It provides a light blanket of security by limiting access to specific data.d. It automatically shows up-to-date
You have a table for a membership database that contains the following fields: MemberLastName, MemberFirstName, Street, City, State, ZipCode, and InitiationFee. There are 75,000 records in the table. What indexes would you create for the table, and why would you create these indexes?
Why doesn’t Access SQL provide for the SQL CREATE VIEW statement?a. In Access, queries function as views.b. Access SQL needs to be compiled outside of the database in order to run all statements.c. Access is not a true relational database system.d. Access does not have the ability to run SQL.
Using Access, open the Relationships window and identify all of the one-to-many relationships in the database as well as the field used in both tables to make the connection using the following pattern found in SQL, when connecting two tables using a WHERE or INNER JOIN clause. An example of one of
What is the primary purpose of creating an index?a. Documenting relationshipsb. Identifying integrity issuesc. Adding event trigger functionality to tablesd. Improving the speed by which data is searched and presented
Using Access, an employee at JC Consulting tried to delete TaskID CODE01 from the TaskMasterList table and received the following error message: “The record cannot be deleted or changed because table ‘ProjectLineItems includes related records.”Why did the employee receive this error message?
What best describes a null value?a. A zero-length string, b. A space or tab characterc. An intentional nothingd. The string "null"
Assume that the Pitt Fitness accountant has met with the owner to discuss how to handle payments and balances. They both decide to add fields to the Customers table to record any payments arriving and the subsequent balance. Add the appropriate fields to the Customers table and set up a Before data
Which of the following is not prevented by enforcing referential integrity on a one-to-many relationship?a. Incorrect entry into a primary key field valueb. Entry into a foreign key field that doesn’t have a match in the table that contains the primary key fieldc. Deleting a record in the parent
Discuss security issues with the Pitt Fitness database. Who should have access to the database? Can any employee change the data? What are problems with that task?
Which of the following is not true about a one-to-many relationship?a. The table on the “one” side is also called the parent or left table.b. The table on the “one” side may or may not have related records in the “many” table.c. The table on the “many” side may have orphan records,
Create an SQL query that calculates how many different therapies have not yet been booked for a session.
RIGHT JOINS in SQL are helpful to find _____.a. Orphan recordsb. Parent records with no matching child recordsc. Records with AND criteria in the WHERE claused. Records with OR criteria in the WHERE clause
Considering the information stored in the Sports Physical Therapy database, what security measures are important?
When two tables are joined in an Access query, the default join type is _____.a. OUTERb. INNERc. LEFTd. RIGHT
Which feature of Access is used to create a report on the metadata about tables and queries?a. Data macrosb. Referential integrityc. Cascade optionsd. Database Documenter
Stored procedures differ from triggers in what essential way?a. Stored procedures are usually run intentionally by users, whereas triggers are generally run automatically by processes.b. Stored procedures are stored at the server, whereas triggers are generally stored at each user’s client
Which feature of Access mimics that of relational database management system triggers?a. SQL Viewb. Data macrosc. Referential integrityd. Cascade options
Which Access field property might you use to set data integrity rules on a single field?a. Validation Ruleb. Indexed?c. Captiond. Default Value
_____ is the duplication of data or the storing of the same data in more than one place.a. Data securityb. Data inconsistencyc. Data independenced. Data redundancy
Explain how redundant data often leads to poorer decision making.
Which of the following is not a problem associated with redundancy?a. Prevents orphan recordsb. Makes updating data more cumbersome and time-consumingc. Can lead to inconsistenciesd. Results in more frequent data errors
A(n) _____ is a person, place, object, event, or idea for which you want to store and process data.a. Attributeb. Entityc. Relationshipd. Flat file
JCC needs to be able to contact clients when problems arise concerning an estimate. What other attributes could JCC include in the Clients table to assist in contacting clients?
A(n) _____ is a characteristic or property of an entity.a. Metadatab. Databasec. Flat filed. Attribute
JCC wants the database to include data on all its employees, not just those who may be involved in projects. What additional entities would the DBA need to include in the database to store this data? What attributes?
A(n) _____ exists between two entities when each row in the first entity may match many rows in the second entity, and each row in the second entity matches only one row in the first entity.a. Recordb. Many-to-many relationshipc. One-to-many relationshipd. Attribute
What kinds of unstructured data or big data might JCC want to gather in the future?
A(n) _____ is a structure that contains data about many categories of information as well as the relationships between those categories.a. Tableb. Data filec. Relational databased. Software stack
A few of the classes have data in a field called “OtherFees.” These are rentals of bicycle shoes for the cycle classes. Should that fee be combined with the ClassPrice field? What if a participant has their own bike shoes?
Which of the following describes how to create a one-to-many relationship in a database system?a. Insert a new table between two existing tables.b. Use a common field in the two tables to tie the related records from each table together.c. Create an entity-relationship (E-R) diagram.d. Include
Currently, the class price and other fees reside in the Registration table. If Pitt Fitness practices dynamic pricing (the management changes the prices as the classes fill up like the airlines do), should they put the class price in the Classes table? Why or why not?
In a(n) _____, rectangles represent entities and display their attributes; lines represent relationships between connected entities.a. Entity-relationship (E-R) diagramb. Unstructured data filec. Spreadsheetd. Software stack
The Sports Physical Therapy database does not include a field for the hours that the therapist is working. For example, doing any sort of treatment requires set up and break down of equipment, reading patients’ charts, etc. In which table would you put the hours worked? What might be a better way
Which of the following defines a DBMS?a. A collection of data that corresponds to one recordb. A file used to store data about a single entityc. The person or group in charge of a databased. A program through which users interact with the data stored in a database
What table might the database need to help determine the balance field in the Patient table? Would you want to record when a bill is paid and the amount? How would the insurance part of the bill be recorded? Module 1 30 Copyright
Which of the following describes database design?a. Collecting the large volume of data produced by digital processes and devicesb. Creating a file used to store data about a single entityc. Creating the entities, attributes, and relationships between tables of datad. Converting the data in a
Which of the following allows you to get more information from the same amount of data?a. Creating a healthy relational databaseb. Entering the same information more than oncec. Using a flat file systemd. Encrypting the datae. Designing professional forms
Using the data for the JC Consulting database shown in Figure 2-1, identify the one-to-many relationships as well as the primary key fields and foreign key fields for each of the five tables. TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03 Code Ruby on Rails CODE04 Code
A(n) _____ is the person in charge of an organization’s database.a. Database management server (DBMS)b. Database administrator (DBA)c. Organization administrator (OBA)d. Big data administrator (BDA)
Which of the following is not a characteristic of a healthy relation?a. Each column has a distinct name (technically called the attribute name).b. Each intersection of a row and column in a table may contain more than one value.c. All values in a column are values of the same attribute (that is,
Using the data for the JC Consulting database shown in Figure 2-1 and your answers from the previous question, which tables would need to be involved if you wanted to create a query that showed the EmployeeID and LastName fields from the Employees table as well as all TaskID and Description fields
Which of the following sentences explains how entities, attributes, and records work together?a. A record contains a single attribute with many entities.b. An entity can have only one attribute in a record.c. A record contains all related entities and all of their attributes.d. A record is all of
The _____ contains values that uniquely identify each record in a table and serves as the linking field in the table on the “one” (parent) side of a one-to-many relationship.a. Primary key fieldb. Foreign key fieldc. Calculated fieldd. Natural field
Select the ClientName, ProjectStartDate, and TaskID fields for all records that have a project start date in the year 2020 and have a task ID of MEET00 or MEET01. Sort the records by client name then task ID.
An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly?
What is the purpose of the foreign key field?a. It is the linking field in the table on the “one” (parent) side of a one-to-many relationship.b. It establishes the order of the records in a table.c. It is the field in the table on the “many” (child) side of a one-to-many relationship.d. It
In the query design grid in Access Query Design View, you place AND criteria on _____, and you place OR criteria on _____.a. The same row, different rowsb. Different rows, the same rowc. The Total row, the next blank Field rowd. The AND row, the OR row
Suppose you want to list information on all the classes that Pitt Fitness offers, including the day of the week, time, location, and length of class. To do this, you could create a query. What table(s) should you add to the query? If you use only the Classes table instead of all the tables
With _____, only one criterion must evaluate true in order for a record to be selected and with _____, all criteria must be evaluate true in order for a record to be selected.a. Parameter criteria, double criteriab. Function criteria, IF criteriac. Simple criteria, complex criteriad. OR criteria,
The owner of Pitt Fitness is considering whether to consolidate his clubs and offer classes in only one location to ensure profitability. To explore his question, what query or queries would you create to answer this business strategy question?
Which of the following is an example of a computed field?a. MonthlyRate = [AnnualRate] / 12b. MonthlyRate: Annual Rate / 12c. MonthlyRate: [AnnualRate] / 12d. MonthlyRate: “AnnualRate” / 12
If you want to find out which therapist is meeting a particular patient on a specific day, what tables do you need for your query? If you also want to know the description of the therapy, does that change your query design? If so, how?
Which of the following describes an Access aggregate function?a. An aggregate function performs a calculation that provides new information for each record.b. An aggregate function determines all rows that are in table A but not in table B.c. An aggregate function sums, averages, or counts, for
If you made a mistake on the update query in question 17 to add a 5 percent surcharge to accounts with balances greater than $1,000, how would you undo the change?Question # 17:A surcharge is being placed on any patient whose balance is greater than $1,000. That surcharge is 5 percent addition to a
How do you sort data in Access Query Design View?a. Use the Sort row and specify the sort fields in a left-to-right order.b. Enter the sort order on the Criteria row of the query design grid.c. Select a grouping field, and then use the Sort row to select a sort order.d. In the Sort row, select
What does it mean to enforce referential integrity on a one-to-many relationship?a. You may not set a primary key in the “many” table.b. You may not create orphan records by entering a phony foreign key field value in the “many” table.c. You may not delete records in the “one” table
Which of the following types of queries does not change data in Access?a. Updateb. Feletec. Selectd. Make-table
_____ forms the foundational knowledge for SQL, Structured Query Language, which is the most popular way developers select, edit, and add data to a relational database.a. Query algebrab. Referential integrityc. Entity diagrammingd. Relational algebra
Which of the following is not an Access SQL data type?a. TEXTb. SHORTc. LONGd. DECIMAL
What would be a good Access SQL data type for a Phone Number field?
Which of the following is not a valid comparison operator?a. =b.
What would the WHERE clause look like in a SELECT query that selects fields from the TaskMasterList, ProjectLineItems, and Projects tables?
Which of the following is true?a. Criteria joined by OR always select fewer records than if joined by AND.b. Criteria joined by AND always select fewer records than if joined by OR.c. Criteria joined by OR criteria may select more records than if joined by AND.d. If a record is true for two
Use the terms primary key field, foreign key field, one-to-many relationship, parent table and child table to describe the following WHERE clause:WHERE Clients.ClientID = Projects.ClientID
Which of the following is not true about a computed or calculated field?a. A calculated field creates a new piece of information for each record.b. A calculated field starts by determining how to group the records.c. A calculated field may use data from numeric fields.d. A calculated field may use
Pitt Fitness is selling a line of exercise clothing at their three locations. At the beginning of this venture, they decide to sell only three types of t-shirts with the Pitt Fitness logo: two women’s sizes and one men’s size. How would you use SQL to create a new table in the Pitt Fitness
Which SQL operator can be rewritten with >= AND
Write an SQL query that would ask the database to count the number of different types of t-shirts available and total their price. Your output should show only the field names: NumberOfTshirts TotalPriceOfTshirts.
Showing 400 - 500
of 497
1
2
3
4
5
Step by Step Answers
Get 50% OFF
Claim Now
