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

Many-to-many relationships _____.a. Are common in almost all relational databasesb. Represent unnormalized datac. Create orphan recordsd. Can be directly implemented using two link lines in most relational database management systems
For the table Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate), which field is the primary key field?a. LastNameb. BirthDatec. PhoneNumberd. CustomerID
For the table Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate), which field is a foreign key?a. LastNameb. CustomerIDc. There isn’t a foreign key.d. PhoneNumber
For the table Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate), which of the following is a secondary key?a. LastName, FirstNameb. BirthDatec. PhoneNumberd. CustomerID
What field(s) in the Customers table would be the most appropriate for a CustomerName index?a. LastNameb. LastName and FirstNamec. LastName, FirstName, and BirthDated. CustomerID
What is the relationship between the tables Classes and Reservations?a. One to oneb. One to manyc. Many to manyd. The tables aren’t related.
What is the relationship between the tables Instructors and Classes?a. One to oneb. One to manyc. Many to manyd. The tables aren’t related.
What is the relationship between the tables Classes and Customers?a. One to oneb. One to manyc. Many to manyd. The tables aren’t related.
Which of the following tables could be considered a composite entity in an ERM and a junction table in an E-R diagram?a. Classesb. Instructorsc. Reservationsd. Customers
Which of the following tables could be considered a composite entity in an ERM and a junction table in an E-R diagram?a. ClassInstructorsb. Instructorsc. Customersd. Classes
The Pitt Fitness program director wants to list customer last names and first names along with the classes they are taking. He creates a query using the Customers and Classes tables. In the query grid, he adds the LastName and FirstName fields from the Customers table and the ClassName field from
What would be a possible alternative key field for the Session table?a. There isn’t a good choice for an alternative key field.b. SessionDatec. PatientNumd. TherapyCode
What is a good choice for a secondary key in the Therapist table?a. Streetb. LastName, FirstNamec. FirstNamed. City
Identify the foreign key(s) in the Session table.a. SessionDateb. PatientNum, TherapyCodec. PatientNum, TherapistIDd. PatientNum, TherapyCode, TherapistID
What is the relationship between the tables Patient and Session?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
What is the relationship between the tables Patient and Therapies?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
What is the relationship between the tables Therapist and Therapies?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
What is the relationship between the tables Therapist and Session?a. One to oneb. One to manyc. Many to manyd. There isn’t a relationship.
Which of the following tables is a junction table?a. Patientb. Therapiesc. Sessiond. Therapist
What is the main difference between the SQL keywords and HTTP methods shown in Figure 7-1? Operation Create Read Update Delete SQL Keyword INSERT SELECT UPDATE DELETE Common HTTP Method POST GET PATCH DELETE Other Common Terms Add Retrieve Edit, modify Destroy
Which of the following fields in the Therapist table would have the highest cardinality?a. TherapistIDb. LastNamec. FirstNamed. Street
Which of the following programming languages does the “P” in modern software solution stacks such as the LAMP, LAPP, and WAMP stacks not stand for:a. PHPb. Pythonc. Perld. Pascal
Create a list of five practical and free precautions you can take to protect your Social Security number.
Which of the following types of Access objects may not be used for data entry?a. ProjectEstimates reportb. Projects formc. ProjectEstimates queryd. Projects table
How do modern online shopping carts help maintain data concurrency?
Which of the following would not be an example of metadata found in a database catalog?a. Values in a primary key fieldb. Table and view namesc. Relationship descriptionsd. Index definitions
Use Figure 7-5 to research a database service for an enterprise-level relational database and document three new key terms based on how that particular vendor handles that particular service. (Examples: Data security by Oracle, Data integrity by MySQL, Backups by SQL Server). Database Management
Which of the following represents information that the Database Documenter feature cannot supply?a. property information for tablesb. list of current unique values for fieldsc. index information for tablesd. relationship information
What symbol does Access use to the left of a record when it is currently being edited and is therefore locked so that other users cannot currently update it?a. Lockb. Black right arrowc. Plus signd. Pencil
How do you back up an online service such as a cloud-based database?
Data consistency means .a. Allowing two or more users to access the database at the same timeb. Giving each user a consistent view of the data including changesc. Using properties such as the Validation Rule property to improve data entry accuracyd. Implementing offsite backups
What type of backup schedule and process would you recommend for JC Consulting?
Which Access tool helps you recover data in the current database?a. Analyze Performanceb. Database Documenterc. Compact and Repair Databased. Backup Database
How do you create a strong password (one that can’t be easily hacked)?
Which feature potentially helps you recover data in an Access database?a. Journalingb. Incremental backupsc. Two-step lockingd. Compact and repair
What type of compact and repair schedule would you recommend for JC Consulting?
A database password in Access works at the level.a. Recordb. Userc. Filed. Group
What is the main difference between reconciling the copies of data involved in traditional database replication as compared to the copies created in the distributed database model used by Git?
Which SQL statement would give user cyclone1 the ability to select, insert, update, or delete records from the Students table?a. GRANT SELECT, INSERT on STUDENTS to cyclone1b. GRANT ALL on STUDENTS to cyclone1c. GRANT GLOBAL on STUDENTS to cyclone1d. GRANT cyclone1 TO STUDENTS
Pitt Fitness would like to analyze their options for an in-house database versus a cloud database-as-a-service. What are the benefits to moving their database to the cloud?
What does Access automatically add to backup files?a. Current user’s nameb. Current datec. Current time of dayd. Backup sequential value
Which of the following is not a constraint on the primary key field for a table?a. There may be no null values.b. All values must be unique.c. All values must have a matching value in the foreign key field of the table in which it has a one-to-many relationship.d. All values must contain data
Create a data integrity constraint for the Pitt Fitness database that only allows a user to enter one of the three fitness locations into the Classes table.
Which SQL statement would add a new field in the Employees table to a query?a. SELECT ALL FROM EMPLOYEESb. SELECT * FROM EMPLOYEESc. SELECT EACH FROM EMPLOYEESd. SELECT FROM EMPLOYEES
Which of the following changes to a database would most likely require the most rework to existing programs and queries?a. Adding a new field to a tableb. Creating a new indexc. Changing relationships between tablesd. Adding a new view
The IT manager at Sports Physical Therapy finds it useful to identify all objects that are dependent on a particular table, query, form, or report. List the tables that the Session table depends on.
Which process can you set to automatically occur when a database is closed?a. Compactb. Backupc. Documentd. Analyze
GitHub and BitBucket are popular websites for .a. Hosting projects that use the Git language for version controlb. Completing full-stack web app projectsc. Posting technical questions and receiving answersd. Reading about trends in the digital development industry
The IT manager at Sports Physical Therapy needs to know all the relationships in the database. Use Access to create a Relationship report for the Sports Physical Therapy database for your own reference. Use Database Design Language to identify the relationships in the database.
The new DBA at Pitt Fitness is working on catalog services in Microsoft Access. This employee has published an internal report on the database schema, but the managers receiving this report are confused by the term “database schema.” What does the report contain?a. A model of the tables and
The new IT person hired by Pitt Fitness is becoming familiar with the database and requests the database schema. How can you generate the schema from the current Access database?a. Click the All Relationships button (Database Tools tab | Relationships group).b. Click the Direct Relationships button
Two clerks at Pitt Fitness need to update an address in the Access database for the customer Min Jee Choi. One clerk sees a note about updating the address and begins to edit Min Jee’s record. At the same time, another clerk receives a phone call from Min Jee about changing the address and opens
Popular classes at Pitt Fitness fill up almost immediately. What database technique would work well to determine which people should be admitted into a popular class based on when they requested entry?a. Two-phase lockingb. Timestampingc. Phantom lockingd. Concurrent locking
Pitt Fitness’s IT person backs up the database every day at the end of business hours. After completing their evening classes, customers register for classes for the upcoming week. Assume that a thunderstorm made Pitt Fitness lose power 12 hours starting at midnight. What state would the database
Suppose Pitt Fitness were using an enterprise-level DBMS when a thunderstorm caused a brief power loss to the database, stopping a class registration entry in midstream. When the power was fully restored, the database would not be in a valid state. What type of recovery is needed to undo the
The IT manager at Pitt Fitness is creating a backup of the company database. What is the best location for storing the backup?a. At the Downtown locationb. Next to the current database for easy accessc. In the cloudd. Pitt Fitness is too small to have a backup.
Which of the following data integrity constraints would ensure Pitt Fitness has a consistent method to record customer phone numbers?a. Format (Input Mask)b. Legal valuesc. Data typed. Validation Rule
Pitt Fitness is now routinely creating backups of their database. They store them on a server and have a number of backup files that need to be deleted. Which of the following files is the correct backup and should not be deleted?a. PittFitness_2021-08-12b. PittFitness_2021-09-30c.
The IT manager at Pitt Fitness wants to secure the database using a method that includes processing logic to periodically change and synchronize with passwords stored on the database. Which of the following choices would fit that requirement?a. Fingerprintb. Smart cardc. Facial recognitiond. Voice
If Sports Physical Therapy had an enterprise DBMS, the IT manager might look at the journal log if a record seemed wrong. Which log entry would indicate that a transaction was completed successfully?a. Startb. Commitc. Insertd. Update
If Sports Physical Therapy had an enterprise DBMS and the IT manager looked at the journal log, which log entry would indicate a change of a record?a. Startb. Commitc. Insertd. Update
Security is especially important for Sports Physical Therapy because the medical information stored on the database must be kept private by law. What is the federal law that protects medical records and other personal health information?a. FERPAb. FDAc. HIPAAd. FDIC
The IT manager at Sports Physical Therapy would like to secure the database with an authentication method that identifies users by physical or behavioral characteristics. What type of authentication fits that requirement?a. Passwordb. Biometricc. Smart cardd. Key fob
The IT manager at Sports Physical Therapy would like to incorporate a data integrity constraint to ensure accuracy and consistency to the database. Specifically, the manager wants to consider a legal value for the UnitOfTime field in the Therapies table. What is a reasonable legal value constraint
Which of the following fields in the Patient table in the Sports Physical Therapy database would be appropriate for an Access input mask?a. LastNameb. FirstNamec. Addressd. State
How can Sports Physical Therapy ensure that if an unauthorized user attempts to gain access to the database, they see only an indecipherable version of the database?a. Set a strong password.b. Encrypt the database.c. Authenticate the database.d. Ensure the server room has a good lock on the door.
What type of concurrent update occurs when two physical therapists are trying to update the record of the same patient at the same time?a. Record-level lockingb. Read-only lockingc. Stateless lockingd. Data concurrent locking
What is the property of the Sports Physical Therapy database that lets the users change the database structure without requiring changes to all the programs that might access that database?a. Clean datab. Updated datac. Data independenced. Separated data
The IT manager at Sports Physical Therapy finds it useful to identify all objects that depend on a particular table, query, form, or report. How can that be accomplished in Access?a. Double-click the object, and then click the Database Documenter button (Database Tools tab | Analyze group).b. Click
What is the main difference between traditional and emerging careers in the database industry?
Which of the following is a common job responsibility for someone in the database industry?a. Network securityb. Data securityc. Application programmingd. Web app development
What policies have you seen your school or college take to protect your privacy?
Which of the following types of external data might be valuable to JC Consulting, but is not currently stored in their internal Access database?a. Clicks on their home pageb. Hashtag references in tweetsc. Company name references in blog postingsd. Each of these types of external data might be
What are the major areas of responsibility for a DBA?
Which of the following would generally not be a typical responsibility of the DBA?a. Data securityb. Data entryc. Data disaster planningd. Data dictionary maintenance
What mission-critical applications must your college or university protect?
JC Consulting is a small business without a dedicated DBA. An employee with which of the following skills would probably be the best candidate to train for the position?a. Marketing background and excellent management skillsb. Computer information systems background and excellent written skillsc.
What has been one of the most recent significant cyberattacks?
Which of the following technical job titles typically does not report to the DBA?a. Data analystb. Data operations managerc. Application programmerd. System DBA
Is it as important for a small business like JC Consulting to have a disaster recovery plan as it is for a large corporation? Please cite three different examples to support your position.
JC Consulting is a small business without a dedicated DBA. An employee with which job title is most likely to be in charge of the database?a. Operations managerb. Sales managerc. Personnel managerd. Construction manager
What are the most sought-after technical skills in the database industry?
Which of the following is typically not a responsibility of a data analyst?a. Data visualizationb. Writing SQLc. Big data analysisd. Transaction data analysis
How might JC Consulting use the cloud?
What skills would someone need at JC Consulting to analyze the potential revenue by ZipCode?a. How to build summary queriesb. How table relationships are set upc. How fields are organized within each tabled. An employee would need all of these skills to successfully analyze potential revenue by
How long does it take to become a DBA?
Which of the following is typically not a primary responsibility of a data scientist?a. Data securityb. Statistical analysisc. Big data analysisd. Data visualization
The database administrator at Pitt Fitness wants to develop and test new applications. What is the safest way to do this, considering the company has customers reserving classes frequently?
JC Consulting just hired a new summer intern in his first year of college to gather social media information about the company. The intern wants to be called a “data scientist.” Is this an appropriate title for the intern?a. Yes. Data scientists deal with big data from social media feeds so
What is the best career path to becoming a DBA?
Which of the following is not a currently popular database industry credential?a. Microsoft Access MOSb. Microsoft Technology Associatec. Oracle Certified Professional, MySQLd. Universal Relational Database Designer
Considering that Pitt Fitness is a small company, what type of backup site would be appropriate for their smaller budget?
Which of the following would be the most appropriate industry credential to earn for the person responsible for the JCConsulting database?a. Microsoft Access MOSb. Microsoft Technology Associatec. Oracle Certified Professional, MySQLd. IBM Certified Database Administrator—DB2
What are typical qualifications for a data analyst?
Considering that Sports Physical Therapy constantly deals with health information, who would be the best person to hire to handle the government regulations and compliance? This person would report to the DBA.
Pitt Fitness realizes that the company needs to be on top of all trends in fitness centers to keep up with the competition. To ensure they stay on the cutting edge, the company would like to employ a person who could help the business make faster and better data-driven decisions. What position
What are typical qualifications for a data scientist?
What sorts of big data might be important for Sports Physical Therapy? Research physical therapy clinics online to find out more information about what they might find vital to be competitive.
Pitt Fitness employs a person who defines and models data requirements, business rules, and database policies.This employee installs, configures, and tests database hardware and software. What is this employee’s title?a. Chief security officerb. Chief information officerc. Database
What should someone considering a career in the database industry keep in mind?

Showing 200 - 300 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