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
Ask a Question
Search
Search
Sign In
Register
study help
computer science
concepts of database management
Questions and Answers of
Concepts Of Database Management
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
How many classes are offered at the Downtown location at 6:00 pm?a. 1b. 2c. 3d. 4 Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
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
Where does Juan Varlano teach his classes?a. Oakland and Downtownb. Oakland onlyc. Oakland and Shadysided. Shadyside and Downtown Instructors InstructoriD InstructorLastName InstructorFirstName
Which class holds the largest number of participants?a. Yogab. Cyclec. Barbell Powerd. Combination Instructors InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress
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,
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
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 =
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
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.
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.
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
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
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
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
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
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
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
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
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
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?
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.
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
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
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),
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.
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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,
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
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
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
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
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.
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
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
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
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
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
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
Showing 400 - 500
of 497
1
2
3
4
5