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

In the Customers table, which field would be ideal for creating an index?a. BirthDateb. PhoneNumberc. FirstNamed. LastName InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress Instructor City InstructorState InstructorZipCode InstructorEmail
What is the SQL command to create an index on InstructorZipCode in the Instructors table?a. INDEX zipindex ON Instructors (InstructorZipCode)b. CREATE INDEX zipindex ON (InstructorZipCode)c. CREATE INDEX zipindex ON Instructors (InstructorZipCode)d. CREATE INDEX ON Instructors (InstructorZipCode)
What security feature can be used on the Pitt Fitness Access database?a. Grant a specific user rights to delete the table ClassInstructors.b. Grant a specific user rights to add data to the Reservations table.c. Set a password on the entire Pitt Fitness database.d. Revoke a given user’s rights.
Using SQL, list the classes that do not have a reservation. Show the class name, location, and reservation ID (which will be blank).a. SELECT Classes.ClassName, Classes.Location, Reservations.ReservationID FROM Classes RIGHT JOIN Reservations ON Classes.ClassID = Reservations.ClassID WHERE
Suppose you want to create a query that displays the class name, customer’s last name, instructor’s last name, and class date. What tables are required to answer this query?a. Classes, Customers, Reservationsb. Classes, ClassInstructors, Customers, Reservationsc. Classes, ClassInstructors,
Suppose you want to create a query that displays the class name, customer’s last name, instructor’s last name, and class date. What type of JOIN should you use for linking the tables together?a. INNERb. OUTERc. LEFTd. RIGHT InstructoriD InstructorLastName InstructorFirstName
As the module material stated, although Access doesn’t create a stored procedure, a parameter query mimics what a stored procedure might do. How would you create a parameter query in SQL to prompt for the patient’s last name and display the patient’s last name and their therapy?a. SELECT
To generate a schedule list, create a view in SQL that shows the session date and the last name and first name of the therapist. Show the list in chronological order.a. SELECT Session.SessionDate, Therapist.LastName, Therapist.FirstName FROM Therapist INNER JOIN [Session] ON Therapist.TherapistID =
What index(es) would be appropriate to create for the Session table? Select the best answer.a. SessionDateb. PatientNumc. TherapistIDd. SessionDate, PatientNum, and TherapistID Session
Assume a new patient calls to make an appointment with a therapist. The clerk recording the appointment creates a new PatientNum value for the new patient. Before entering any other data, she first enters the PatientNum value into the Session table as part of a new record. What rule does this
From the following views, what view would be the most appropriate for the Sports Physical Therapy accountant?a. PatientNum, LastName (Patient), SessionDate, SessionNumb. PatientNum, LastName (Patient), Address, City, State, ZipCode, Balancec. PatientNum, LastName (Patient), TherapistID,
If you created an SQL query to list the patient number and the session date, which tables would be joined?a. Session and Patientb. Therapies and Patientc. Therapist and Patientd. all four tables Session
When does a single list create redundant data and what are the major problems associated with redundant data?
If you want to send a mailing to all patients advertising a new facility, what tables would you need to generate the query that would print the mailing labels?a. Patient, Session, Therapies, Therapistb. Patient, Session, Therapiesc. Patient, Session, Therapistd. Patient Session
The following exercises are based on the JC Consulting database.What is the primary key field for the Employees table?a. EmployeeIDb. HireDatec. Salaryd. LastName
Assume you are using two tables for an SQL query: Therapist and Session. You want to make sure that you display all the names of the therapists even if they are not yet booked into a session. What join do you need to create to ensure that all the therapists are listed?a. LEFT JOIN Therapist ON
If you created an SQL query to list the patient number and the session date, what type of join should you use?a. PLAIN JOINb. OUTER JOINc. INNER JOINd. LEFT JOIN Session
Write the SQL code to list the session date and therapist’s last name to display the upcoming schedule for the therapists.a. SELECT Session.SessionDate, Therapist.LastName FROM Therapist INNER JOIN (Therapies INNER JOIN [Session] ON Therapies.TherapyCode = Session.TherapyCode) ON
When do you need to delete an index?
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.Which of the following fields from the Projects table is not a good candidate to index?a. ProjectIDb.
Using SQL, count how many classes each customer has signed up for. Show the customer’s last name, first name, and number of classes. Use an appropriate JOIN.a. SELECT LastName, FirstName, Count(ReservationID) AS [Number of Classes]FROM Customers INNER JOIN Reservations ON CustomerID = CustomerID
The Instructors table and the ClassInstructors table have a one-to-many relationship. When forming the relationship, you want to ensure that if an instructor changes his or her InstructorID in the Instructors table, the related InstructorID will change in the ClassInstructors table. What option
Using your knowledge of the college environment, convert a table with the following notation to an equivalent collection of tables that are in third normal form:Student (StudentNum, StudentName, (CourseNum, Description, Term, Grade))
Open the Employees table. What field contains redundant data that most likely could be moved into a lookup table?a. EmployeeIDb. LastNamec. Titled. Salary
How does normalization relate to the problems identified with data modification anomalies?
Which of the following is not a type of data modification anomaly?a. Entryb. Updatec. Deletiond. Insertion
Again, using your knowledge of the college environment, convert the following data about student activities (Chess Club, Marching Band, Ski Club, and so forth) into third normal form:Student (StudentID, StudentName, ActivityNum, ActivityName, Advisor)
Which normal form do these tables adhere to?a. Unnormalizedb. 1NFc. 2NFd. 3NF
Why are numbers such as StudentID, EmployeeID, or ProductID generally good candidates for primary key fields, and how does that relate to functional dependence?
Which of the following best describes functional dependence?a. It describes the relationship of attributes in an entity.b. It describes the relationship of tuples in an entity.c. It describes the relationship of entities as compared to other entities.d. It describes the relationship of unnormalized
What is the notation for each of the seven current tables in the JC Consulting database?
What foreign key fields does the ProjectLineItems table contain?a. ProjectID and TaskIDb. ProjectLineItemID and ProjectIDc. ProjectLineItemID and TaskIDd. ProjectLineItemID, ProjectID, and TaskID
What are two essential characteristics of a good primary key field?
What foreign key fields does the Projects table contain?a. ClientID and EmployeeIDb. ProjectID and ClientIDc. ProjectID and EmployeeIDd. ProjectID, ClientID, and EmployeeID
Which of the following is not a characteristic of 1NF?a. Data is stored in a single tabular arrangement.b. A column may contain only one value.c. Each column contains an atomic value.d. An entity is related to another entity through the use of the foreign key field.
Examine the Employees table. Note that the data in the Title field contains redundant values and therefore is a candidate for a one-field lookup table. Use your Access Query Design View or SQL skills to create a lookup table named Titles with the unique values in the Title field of the Employees
What might happen if the numbers in a Length column sometimes represented inches and other time represented centimeters? Also, how would you fix that data problem?
Which of the following is not an atomic value?a. 15b. Oklahoma Cityc. IBM Corporationd. Bill Gates
Assume that you designed the field LengthOfTime in the Classes table in the Pitt Fitness database. The LengthOfTime field has data such as 60 minutes, 30 minutes, 1 hour, and 15 minutes. Is this the correct way to record this data? If not, what would be a better method?
What foreign key fields does the Clients table contain?a. ClientIDb. Zipc. ClientID and Zipd. The Clients table does not contain any foreign key fields.
Why is it important to remove transitive dependencies?
Transitive dependencies are removed in which normal form?a. 1NFb. 2NFc. 3NFd. 4NF
Originally, Pitt Fitness had all their data in one large Excel spreadsheet. Suppose you were hired to help Pitt Fitness create a database to replace the spreadsheet. Outline the major steps you would perform to create a normalized database from the data in the spreadsheet.
The Categories table contains one field, Category. Which table will most be used with it to help constrain the values in a particular field?a. Employeesb. Clientsc. Projectsd. TaskMasterList
Repeating values in attributes are removed in which normal form?a. 1NFb. 2NFc. 3NFd. 4NF
When the Sports Physical Therapy database was created, the database designers identified PatientNum and PatientSocialSecurityNumber as candidate keys for the Patient table. Why was PatientSocialSecurityNumber not chosen to be the key field of that table?
Open the Relationships window and examine the field lists. What does the key symbol to the left of certain field names represent?a. the foreign key field for each tableb. the primary key field for each tablec. the composite key field for each tabled. the combination key field for each table
Smaller tables are first removed from a single large list in which normal form?a. 1NFb. 2NFc. 3NFd. 4NF
What is the notation for each table in the Sports Physical Therapy database?
Open the TaskMasterList table in Datasheet View. What field contains redundant data that most likely could be pulled into a lookup table?a. Perb. Descriptionc. TaskIDd. CategoryID or Per
Which of the following is not true of the primary key field of a table?a. It may not include nulls.b. It must contain unique data for every record.c. It must contain numeric data.d. It may be used in a relationship with another table.
Suppose Pitt Fitness offered personal fitness training and the Customers table were designed as follows:Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress, PhoneNumber, BirthDate, InstructorID)This design reflects that instructors also work as personal
What is the purpose of a foreign key field?a. To link a record to data in another tableb. To shorten the normalization processc. To uniquely identify each recordd. To prevent unauthorized access to a table
Is InstructorLastName a candidate key along with InstructorID in the Instructors table?a. Yes, InstructorLastName could be used as a key field because no one instructor has the same last name.b. No, InstructorLastName could not be a key field because an instructor might join the team with the same
Pitt Fitness is starting to sell its own line of clothing. The following Orders table has been created in the database to record the clothing orders, but the table may not be designed properly. The potential problem may be corrected in which normal form?a. First normal formb. Second normal formc.
Who invented normalization?a. Thomas John Watsonb. Edgarf. Coddc. Larry Ellisond. Grace Hopper
Pitt Fitness modified the Orders table as follows, but it may still not be designed properly. The potential problem may be corrected in which normal form?a. First normal formb. Second normal formc. Third normal formd. It is correctly designed. OrderID
Pitt Fitness modified the Reservations table as follows, but it may have an improper design. The potential problem may be corrected in which normal form?a. First normal formb. Second normal formc. Third normal formd. It is correctly designed. Reservation (key)
Which of the following is least likely to be described as an algorithm?a. A recipeb. The Rosetta stonec. The process of normalizationd. A mathematical formula
Pitt Fitness asks you to create a query using the following table to find any repeating values of customer and date. What query function in Access should you use when you design this query?a. Totals – Group byb. Parametersc. Appendd. This cannot be accomplished in an Access query. Reservation
In the following table, which field does not contain an atomic value?a. Reservationb. Datec. InstructorIDd. Name Reservation (key) 2100001 2100002 2100003 2100004 2100005 2100006 2100007 Date 1/5/2021 1/8/2021 1/10/2021 1/10/2021 1/12/2021 1/13/2021 1/13/2021 CustomerlD ClassID
The Reservations table is organized as follows:Reservations (ReservationID, ClassID, ClassInstructors, ClassPrice, OtherFees, CustomerID)Knowing about normalization, what superior way could you use to organize the data?a. Create two tables: Reservations (ReservationID, ClassID, ClassInstructors,
The table ClassInstructors (ClassID, InstructorID) could be considered what type of table?a. Make tableb. Codd tablec. Lookup tabled. Anomaly table
What is the notation for the following new table?a. Orders (OrderID, OrderDate, CustomerID, ItemID)b. Orders (OrderID, OrderDate, CustomerID)c. Orders (OrderID, OrderDate, CustomerID)d. Orders (OrderID, OrderDate, CustomerID) OrderID
Suppose the Session table is set up as follows. Is this design correct? If not, in which normal form would you correct it?a. First normal formb. Second normal formc. Third normal formd. It is correctly designed; it does not violate any form. SessionNum Session Date Patient
How do you diagram the functional dependence on TherapyCode in the Therapies table?a. TherapyCode + Description, UnitOfTimeb. TherapyCode (Description, UnitOfTime)c. TherapyCode ‡ Description, UnitOfTimed. TherapyCode = Description, UnitOfTime
What would be a candidate key for the Session table, besides the current key field of SessionNum? The design of the Session table is Session (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode).a. SessionDateb. PatientNum and TherapistID (compound key)c. TherapyCode and
What foreign key(s) does the Session table contain? Session (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode).a. PatientNum, TherapistID, TherapyCodeb. PatientNum onlyc. PatientNum and TherapistID onlyd. This table does not have any foreign keys.
What field is the link between the Therapist and Session tables?a. PatientNumb. TherapistIDc. SessionNumd. TherapyCode
When a patient comes into the Sports Physical Therapy, they often have insurance to cover some or all of the cost of the therapy sessions. Assuming that a few patients might use two insurance companies (e.g., a spouse’s insurance might supplement the patient’s insurance), how would you record
A new table needs to be added to the Sports Physical Therapy database to track which sports the patients are playing. This data will be used to analyze the results of the therapies. Assuming that many patients play multiple sports, how would you design the table?a. SportsPlayed (PatientNum,
The Sports Physical Therapy clinic uses supplies when conducting therapies on patients. The database administrator is creating a table that lists all the possible supplies that the clinic orders. The design of this table is Supplies (SupplyID, Description, Price, SupplierID, SupplierName,
Patient Number 1014 is receiving three treatments in one session. Is the following design correct for the Session table?a. Yes, this is a good way to record multiple sessions.b. Yes, but the two additional sessions do not need to be recorded. The time for the original session can just be
Suppose the Therapist table is set up as follows. Why is this table not in 1NF?a. The table contains repeating groups.b. A field does not contain atomic values.c. The table includes duplicate records.d. The table is in 1NF. TherapistID AS648 BM273 JR085 SN852 SW124 LastName Anthony
How would you write the DBDL for the five tables in the student-advisor-assignments.accdb Access database?
Which of the following is not a technique that would be used in the process of developing a relational database?a. Normalize the data.b. Review existing data forms and reports.c. Interview those who use the data to understand business rules.d. Combine all attributes into one large table.
What is the relationship between a table of Movies and a table of ActorsActresses and how might it be implemented in a relational database?
If management wanted to start tracking the date the entire project was closed, which table should the field be added to?a. Clientsb. Projectsc. ProjectLineItemsd. TaskMasterList
How would you create the ERM for the five tables in the student-advisor-assignments.accdb Access database without including the attributes?
Which of the following relational database tools does not help you document the relationships between tables?a. SQLb. DBDLc. E-R diagramd. Entity relationship model
What types of business rules might determine the relationship between a table of Volunteers and a table of Activities at a nonprofit?
Which field in the TaskMasterList table is a good candidate for Lookup properties that constrain it with a one-to-many relationship to a one-field table?a. Descriptionb. Perc. Estimated. TaskID
How do you identify the primary key field in DBDL notation?a. With a circleb. With an underline as well as the abbreviation PKc. With a double underlined. With a key symbol
Identify the steps you would take to create a one-field table named Titles that could be used to constrain the values in the Title field of the Employees table to the existing values in that field.
Which of the following best describes the Zips table in DBDL if City is often used for sorting?a. Zips (City, Zip) PK Zip SK Cityb. Zips (City, Zip) PK Zipc. Zips (City, Zip) PK Zip FK Cityd. Zips (City, Zip) FK Zip FK City
Which of the following is not considered a type of E-R diagram?a. DBDLb. ERMc. Crow’s foot notationd. Access Relationship window
In the Relationships window of the JC Consulting database, which primary key field does not participate in a one-to-many relationship?a. ProjectLineItemIDb. ProjectIDc. TaskIDd. All primary key fields participate in one-to-many relationships.
The ERM emphasizes what part of a relational database?a. Attributesb. Relationshipsc. Primary key fieldsd. Foreign key fields
Write the Pitt Fitness database in DBDL notation.
What can you assume based on the existence of the “one” and infinity symbols on all relationships in the Relationships window of the JC Consulting database?a. Referential integrity is applied.b. Referential integrity with the cascade update and cascade delete constraints is applied.c. The
Which of the following statements is true about a one-to-many relationship?a. Every primary key field participates on the “one” side.b. Every foreign key field participates on the “one” side.c. Every primary key field participates on the “many” side.d. Every foreign key field
What prevents a user from entering a reservation for a customer who has not yet been registered in the Customers table?
What is the benefit of using the same names for the primary and foreign key fields?a. It allows you to enforce referential integrity on the relationship.b. It allows you to create one-to-one relationships.c. It clarifies the linking field between the tables.d. It clarifies where Lookup properties
Why might you not be able to enforce referential integrity on a one-to-many relationship?a. The table on the “one” side doesn’t have a matching record(s) in the table on the “many” side.b. The table on the “many” side doesn’t have primary key field.c. The table on the “many”
Create a query in Access that uses two tables, the Patient table and the Session table. Add the LastName, FirstName, and SessionDate fields to the query grid. Run the query. How many records are displayed? Delete the join line between the field lists in Query Design View. Rerun the query. How many
What is true about the relationship link line in the Access Relationships window that isn’t true about generic E-R diagrams?a. The link line can be curved.b. The link line indicates where records in the “one” table exist that do not have matching records in the “many” table.c. The link
Which of the following is not a feature that Access uses to demonstrate and leverage the power of one-to-many relationships?a. Subdatasheetsb. Lookup propertiesc. Automatically refreshing related data in Query Datasheet Viewd. Import wizards
Enter an additional record in the Session table with the PatientNum 1022. What happens when you try to move onto another record? What is the error message? Why?
Which value ties the records in the “many” table to the proper record in the “one” table?a. The value of the surrogate keyb. The value of the primary key field in the “many” tablec. The value of the foreign key field in the “one” tabled. The value of the foreign key field in the
Which of the following is true about a one-to-one relationship?a. They are almost always a mistake.b. They create Cartesian joins in queries.c. They relate two tables using the primary key field in both tables.d. They are only used to import and update data.

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