Questions and Answers of Concepts Of Database Management

To check your understanding of the relationship between therapies and the other tables, answer the following questions: Did any patient have a hot or cold pack application? Which therapist(s) helped
To check your understanding of the Pitt Fitness data, which classes does InstructorID NT01, NedaTahan, teach?
What are typical salaries for a database administrator and data analyst?
What are other examples of unstructured data?
What is data security?
Which DBMS should JC Consulting use to create and maintain its database?
Why does ProjectID 2 have such a large row in Figure 1-6?Figure 1-6 ProjectID ProjectStartDate ClientID EmployeeID ProjectNotes 06-Feb-19 1 1 2 3 4 07-Feb-19 11-Mar-19 10-Apr-201 10 3 4 52 63 52 52
How is the information in Figure 1-5 represented in Figure 1-6?Figure 1-5Figure 1-6 TaskID Description CODE01 Code PHP CODE02 Code C# in ASP.NET CODE03 Code Ruby on Rails CODE04 Code SQL CODE05 Code
What happens when the relationship between two entities is best defined as “many-to-many” because one record in one entity relates to many records in the other entity and vice versa? For example,
What problems does redundancy cause?
Which of the following is not a benefit of the database normalization process?a. Redundant data is minimized.b. Data is simplified into only the important attributes.c. Data is more accurate.d. Data
Assume that PatientNum 1021 is entered into a record in the table Session. However, PatientNum 1021 does not appear in the Patient table. What type of record would this be (in the Session table)?a.
The ProjectsAndLineItems query currently uses the ProjectID field from the Projects table. Explain why that field cannot be edited in Query Datasheet View.
Select the LastName, ProjectID, and ClientName fields for all records for the employee with the last name of Novak. Which of the following ProjectID values is not associated with Novak?a. 1b. 17c.
Select the ProjectID, ProjectStartDate, ClientName, and Government fields for all records where the Government field value is True. Which of the following clients are included in the results?a.
Delete all of the records in the ProjectLineItems table with a ProjectID field value of 11. How many records were deleted?a. 1b. 0c. 7d. 145 TaskID Description CODE01 Code PHP CODE02 Code C# in
When I run the calculated field query, Access asks me for a parameter value. What should I do?
Complete the following statements to list the project ID and project start date of all projects that were placed by client ID 5.JOIN Projects Clients WHERE Projects.ClientID = Clients.ClientID GIVING
Complete the following statements to list the project ID and project start date of all projects that were created for client ID 5 or 6.JOIN Projects Clients WHERE Projects.ClientID = Clients.ClientID
Complete the following statements to list the project ID and project start date of all projects with a project start date of 3/1/2020 but not for client ID 7.SELECT Projects WHERE ProjectStartDate
Which customer lives on Negley Avenue?a. Gregorb. Aboudc. Agnewd. Sanchez JC Consulting Project Estimate 2000 Pler Four Blvd, Boston, MA 02210 (617) 868-8900 Tri-Lakes Realtors Brief project
How many customers were born from 2001 onward?a. 5b. 3c. 10d. 2 InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode
Which instructors live in zip code 15217?a. Juan Varlano, Michael Nguyenb. Robert Sisto, Neda Tahanc. Vicki Pegues, Raymond Steind. No instructors live in this zip code. InstructoriD
Which classes (by name) have the highest number of reservations?a. Intense Cycle, Barreb. Combination, Bootcampc. Yogad. Aqua Calm, Yoga Balance InstructoriD InstructorLastName InstructorFirstName
How many customers have registered for a class on Wednesdays?a. 10b. 7c. 6d. 5 InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState
What are the three most popular class names on Saturday?a. Cycle, Combination, Agility for Seniorsb. Zumba, Cycle, Combinationc. Bootcamp, Zumba, Cycled. Maturity Endurance and Strength, Intense
How many classes did Pablo Brough sign up for?a. 5b. 2c. 1d. 0 InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState InstructorZipCode
How many customers have signed up for a class on January 8, 2021?a. 0b. 1c. 3d. 10 InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState
Which customers prefer the 45-minute class length?a. Glenn Spencer, Sharon Smithb. Debby Thorn, Juan Barryc. Tamara Lara, Albert Cornettd. Min Jee Choi, Ramiro Sanchez InstructoriD InstructorLastName
Which instructor teaches the most classes?a. Raymond Steinb. Memo Saidc. Michael Nguyend. Maria D’Angelo InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity
Which instructor teaches Zumba?a. Neda Tahanb. Juan Varlanoc. Megan Kobinskid. Robert Sisto InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState
Of all reservations for classes containing the word Cycle, which customer does not owe another fee besides the class price? (Note: this field is called “OtherFees.”) Create a calculated field to
According to the reservations so far, how much money will the Combination classes generate?a. $9b. $18c. $36d. $0 InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress
Instructor Michael Nguyen is injured and has to cancel his class on Wednesday. Delete that record and count how many classes he has left to teach.a. 6b. 2c. 5d. 10 InstructoriD InstructorLastName
Which instructor will customer Margo Patterson get for her HIIT class?a. Raymond Steinb. Vicki Peguesc. Megan Kobinskid. Neda Tahan InstructoriD InstructorLastName InstructorFirstName
How many classes are offered on Tuesday at 6 am and last 45 minutes?a. 3b. 2c. 1d. 0 InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState
Which day of the week has the most classes?a. Mondayb. Tuesdayc. Wednesdayd. Thursday InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress InstructorCity InstructorState
Which patient has the highest balance?a. Latisha Cullingb. Andre Marinoc. Tammy Wilsond. Isaiah Venable PatientNum
How many patients and therapists live in Georgetown, TX?a. One patient and one therapistb. Three therapistsc. Two patientsd. No one lives in Georgetown, TX. PatientNum
Which patient has a therapy session on October 12, 2021?a. Robbie Koehlerb. Tobey Shortc. Ben Odepauld. Tierra Falls PatientNum
Which therapist has a session on October 12, 2021?a. Saritha Nairb. Anthony Shieldsc. Bridgette McClaind. Jonathan Risk PatientNum
Which patient has booked the most therapies?a. Brianna Waggonerb. Tammy Wilsonc. Andre Marinod. Joseph Baptist PatientNum
Who are the busiest therapists?a. Wilder, Shieldsb. Risk, Nairc. McClain, Shieldsd. Wilder, Nair PatientNum
Which patients live in the same town as their therapist?a. Culling, Marinob. Venable, Koehlerc. King, Fallsd. Baptist, Short PatientNum
How many patients are receiving ultrasound therapy?a. 1b. 2c. 3d. 0 PatientNum
Which therapist has the longest single session?a. Bridgette McClainb. Saritha Nairc. Steven Wilderd. Anthony Shields PatientNum
Create a calculated field that figures the amount each therapist earns assuming they charge $100 per hour and the length of the session is the correct amount of time each therapy takes. How much
Which therapist works with a patient’s speech?a. Jonathan Riskb. Anthony Shieldsc. Saritha Naird. Steven Wilder PatientNum
How many therapies refer to pain in their description?a. 3b. 1c. 4d. 0 PatientNum
Which patient has the longest single session?a. Latisha Cullingb. Brianna Waggonerc. Joseph Baptistd. Robbie Koehler PatientNum
How many therapies have a designated 15-minute unit of time?a. 5b. 10c. 15d. 30 PatientNum
Which therapists are scheduled for October 11, 2021?a. McClain, Shieldsb. Risk, Shieldsc. Nair, Shieldsd. Wilder, Shields PatientNum
Which therapist works the least, in terms of hours in sessions?a. Jonathan Riskb. Steven Wilderc. Bridgette McClaind. Anthony Shields PatientNum
A surcharge is being placed on any patient whose balance is greater than $1,000. That surcharge is 5 percent addition to a patient’s current balance. Create an update query to perform the
What SQL statement lists only the EmployeeID, LastName, and FirstName fields of all employees in the Employees table?a. SELECT *FROM Employees;b. SELECT EmployeeID, LastName, FirstName FROM
What SQL statement lists all the fields from the records in the TaskMasterList table with a CategoryID of Database?a. SELECT *FROM TaskMasterList;b. SELECT *FROM TaskMasterList WHERE Count(*) >
Which SQL command would be used to join the TaskMasterList and ProjectLineItems tables?a. CONNECTb. COMBINEc. LINKd. WHERE ProjectID ProjectStartDate ClientID
What default command appears in the SQL query window?
Which SQL keyword would be used to find all TaskMasterList records with a CategoryID field value of Testing or Support?a. ANDb. ORDERc. &&d. OR ProjectID ProjectStartDate ClientID
How would you create a new table named Zips with two TEXT fields named City and Zip?
Which SQL command would be used to sort all TaskMasterList records in ascending order based on the value of their TaskID within CategoryID?a. ORDER BY CategoryID, TaskIDb. ORDER BY TaskID,
Which SQL keyword would be used to select all records except those with a Per field value of Hour?a. WHERE NOT Per = 'Hour'b. WHERE Per = 'Hour'c. SELECT NOT Per = 'Hour'd. SELECT * EXCEPT 'Hour'
Is Zip a text field?
What data types would you assign to the City and Zip fields when creating the Zips table?a. TEXT to City and SHORT to Zipb. LONGTEXT to City and TEXT to Zipc. TEXT to City and TEXT to Zipd. SHORT to
Which SQL statement calculates the Bonus field in the Employees table as 10 percent of Salary?a. SELECT Salary * 0.1 AS Bonus FROM Employees;b. SELECT Bonus AS Salary * 0.1 FROM Employees;c. SELECT
Which SQL statement lists the job titles at JCC and displays the number of employees that have each title?a. SELECT Title, COUNT(*) AS CountOfTitle FROM Employees GROUP BY Title;b. SELECT Title,
Which SQL statement lists the last names and salaries of employees who have a Salary field value less than Amir Nasser, EmployeeID 72?a. SELECT LastName, Salary FROM Employees WHERE Salary UNION
Write the SQL code for the following: List the class name, room, location, day, and time for all classes.a. SELECT *FROM Classes;b. SELECT ClassName, Room, Location, Day, Time IN Classes;c. SELECT
Write the SQL code for the following: Display the last names of the customers who have registered for a class on 1/2/2021.a. SELECT Customers.LastName, Reservations.ClassDate FROM Customers ADD
Write the SQL code for the following: Display the last name and street address of the customers who live on Negley.a. SELECT LastName, StreetAddress FROM Addresses WHERE StreetAddress LIKE
Write the SQL code for the following: Count the number of reservations for 1/3/2021 and display that number with a CountOfReservationID column heading.a. SELECT COUNT(ReservationID) AS
Write the SQL code that answers the following question: Which instructors (showing last name only) live in zip code 15217?a. SELECT LastName FROM Instructors WHERE InstructorZipCode = '15217';b.
Write the SQL code that answers the following question: Which classes are scheduled for Wednesdays at the Downtown location? List the class name, the day, and the location.a. SELECT ClassName FROM
What SELECT statement would you use in a longer query to calculate the amount of money earned by each instructor based on the length of time for the class and $20 per hour? Display the instructor’s
Write the SQL code for the following: Update all class prices to reflect a 1% increase.a. UPDATE Reservations SET ClassPrice = ClassPrice*1.10;b. UPDATE Reservations SET ClassPrice = ClassPrice*1%;c.
How would you write the SELECT statement in a longer query if you wanted to concatenate the first and last name of the instructors and display that as InstructorFullName?a. SELECT
Write the SQL code for the following: Order the reservations by class date and then by class ID. Display all fields.a. SELECT *FROM Reservations ORDER BY ClassDate, ClassID;b. DISPLAY ALL FROM
Write the SQL code for the following: List all the information in the patient’s table sorted by city.a. SELECT ALL FROM Patients ORDER BY City;b. SELECT *FROM Patients ASC City;c. SELECT *ORDER BY
Write the SQL code for the following: List the city, last name, and balance of patients who live in Waterville and have a balance greater than $1,000.a. SELECT City, LastName, Balance FROM Patient
Write the SQL code for the following: List the last name, city, and balance of patients who live in Waterville or have a balance greater than $2,000.a. SELECT LastName, City, Balance FROM Patient
Write the SQL code for the following: List the last names of patients whose balance is greater than $1,000.a. SELECT LastName, Balance>1000 FROM Patient;b. SELECT LastName, Balance FROM Patient WHERE
Write the SQL code for the following: Increase the balance by 2% of any patient whose balance is greater than $2,000.a. UPDATE Patient SET Balance = Balance*1.2 WHERE Balance>2000;b. UPDATE
Write the SQL code for the following: List the full name of the therapist scheduled to work on 10/16/2021.a. SELECT Therapist.FirstName, Therapist.LastName FROM Therapist WHERE Therapist.TherapistID
Write the SQL code that answers the following question: How long are the therapy sessions for the therapist whose last name is Shields? List the length of each session.a. SELECT
Write the SQL code for the following: List the session dates and numbers for those sessions scheduled between 10/18/2021 and 10/20/2021.a. SELECT SessionDate, SessionNum FROM Session WHERE
Write the SQL code that answers the following question: Which therapies have the word "movement" in their description? List the therapy description only.a. SELECT Description FROM Therapies WHERE
Write the SQL code that answers the following question: How many therapies are offered? Answer with one number only.a. SELECT COUNT(TherapyCode) AS CountOfTherapyCode FROM Therapies;b. SELECT COUNT
Does Access support views?
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future
Is it possible to set user-level or transaction-level security in Access?
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future
Why might you use the MSysObjects table in Access?
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future modules.In
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future modules.To
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future
Using Access, create a view for Pitt Fitness that displays all the classes held at the Downtown location. Show only the fields ClassName, Room, Day, Time, and Description. Show the ClassName field as
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future modules.What
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future
Write the SQL code to create a view for Pitt Fitness that displays all the classes held at the Downtown location.Show only the fields ClassName, Room, Day, Time, and Description. Show the ClassName
In the following exercises, you will use the data in the JC Consulting database. Don’t forget to use a copy of the JC Consulting database so any changes you make will not affect future

Showing 1 - 100 of 497