Questions and Answers of Concepts Of Database Management

In the Customers table, which field would be ideal for creating an index?a. BirthDateb. PhoneNumberc. FirstNamed. LastName InstructoriD InstructorLastName InstructorFirstName InstructorStreetAddress
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
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
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,
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,
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.
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
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,
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
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
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
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,
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
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
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
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,
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
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,
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
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
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
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
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
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
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
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
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
Suppose Pitt Fitness offered personal fitness training and the Customers table were designed as follows:Customers (CustomerID, LastName, FirstName, StreetAddress, City, State, ZipCode, EmailAddress,
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
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,
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
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.
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.
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
In the following table, which field does not contain an atomic value?a. Reservationb. Datec. InstructorIDd. Name Reservation
The Reservations table is organized as follows:Reservations (ReservationID, ClassID, ClassInstructors, ClassPrice, OtherFees, CustomerID)Knowing about normalization, what superior way could you use
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
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
How do you diagram the functional dependence on TherapyCode in the Therapies table?a. TherapyCode + Description, UnitOfTimeb. TherapyCode (Description, UnitOfTime)c. TherapyCode ‡ Description,
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,
What foreign key(s) does the Session table contain? Session (SessionNum, SessionDate, PatientNum, LengthOfSession, TherapistID, TherapyCode).a. PatientNum, TherapistID, TherapyCodeb. PatientNum
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
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
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
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
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
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
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
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
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.
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”
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
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.
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
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
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
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
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

Showing 100 - 200 of 497