New Semester
Started
Get
50% OFF
Study Help!
--h --m --s
Claim Now
Question Answers
Textbooks
Find textbooks, questions and answers
Oops, something went wrong!
Change your search query and then try again
S
Books
FREE
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
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Modern Database Management 13th Global Edition Jeff Hoffer, Ramesh Venkataraman, Heikki Topi - Solutions
. Which tutors have a Dropped status and have achieved their certification after 4/01/2018?
. How long had each student studied in the adult literacy program?
. Show the average, maximum, and minimum Read score per student group.
. Which student has the highest Read score?
. How many students were matched with someone in the first five months of the year?
. What are the TutorIDs for tutors who have not yet tutored anyone?
. List the IDs of the tutors who are currently tutoring more than one student.
. What is the average Read score for all students? What are the minimum and maximum Read scores?
. How many tutors have a status of Temp Stop? Which tutors are active?
. Write SQL queries to answer the following questions:a. For each course included in the QUALIFIED table, list CourseID and the number of faculty members qualified to teach it.b. For each section included in the REGISTRATION table, list SectionNo and the number of students registered for it.
. Write SQL queries to answer the following questions:a. List the numbers of all sections of course ISM 3113 that are offered during the semester “I-2018.”b. List the course IDs and names of all courses that start with the letters “Data.”c. List the IDs of all faculty members who are
. Write SQL queries to answer the following questions:a. What are the courses included in the Section table? List each course only once.b. List all students in alphabetical order by Student-Name.c. List the students who are enrolled in each course in Semester I, 2018. Group the students by the
. Write SQL queries to answer the following questions:a. Which students are enrolled in Database and Networking?(Hint: Use SectionNo for each class so you can determine the answer from the REGISTRATION table by itself.)b. Which instructors cannot teach both Syst Analysis and Syst Design?c. Which
. Write SQL queries to answer the following questions:a. How many students are enrolled in Section 2714 in the first semester of 2018?b. What are the numbers of the faculty members who are currently qualified to teach the course ISM 3113?c. Which faculty members have qualified to teach a course
. Write SQL queries to answer the following questions:a. Which students have an ID number that is less than 50000?b. What is the name of the faculty member whose ID is 4756?c. What is the smallest section number used in the first semester of 2018?
. Write SQL commands for the following:a. Create two different forms of the INSERT command to add a student with a student ID of 65798 and last name Lopez to the STUDENT table.b. Now write a command that will remove this student from the STUDENT table.c. How would your command look like if your
. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the STUDENT table?b. How would you remove the REGISTRATION table?c. What would you need to take into account if you wanted to remove the COURSE table?d. How would you change the
. To enforce referential integrity, before any row can be entered into the SECTION table, the CourseID to be entered must already exist in the COURSE table. Write an SQL assertion that will enforce this constraint.
. Use SQL to define the following view:STUDENTID STUDENTNAME 38214 Letersky 54907 Altvater 54907 Altvater 66324 Aiken
. Analyze the database to determine whether or not it is fully normalized.
. Write a database description for each of the relations shown, using SQL DDL (shorten, abbreviate, or change any data names, as needed for your SQL version). Assume the following attribute data types:StudentID (integer, primary key)StudentName (25 characters)FacultyID (integer, primary
. What is the purpose of the EXPLAIN or EXPLAIN PLAN command?
. Explain the difference between the WHERE and HAVING clause.
. What can be changed about a table definition using the SQL command ALTER? Can you identify anything about a table definition that cannot be changed using the ALTER command?
. Explain the purpose of the CHECK clause within a CREATE TABLE SQL command.
. How can an SQL command be structured to allow parallel execution?
. State four rules for choosing indexes for a relational database.
. What is a materialized view, and when would it be used?
. SQL:2006 and SQL:2008 introduced a new key word, MERGE. Explain how using this key word allows one to accomplish updating and merging data into a table using one command rather than two.
. What is an identity column? Explain the benefits of using the identity column capability in SQL.
. What considerations should be kept in mind when using indexing?
. Explain why SQL is called a set-oriented language.
. How do you determine the order in which the rows in a response to an SQL query appear? What options do you have when specifying this order?
. In what clause of a SELECT statement is an IN operator used? What follows the IN operator? What other SQL operator can sometimes be used to perform the same operation as the IN operator? Under what circumstances can this other operator be used?
. How is the HAVING clause different from the WHERE clause?
. If an SQL statement includes a GROUP BY clause, the attributes that can be requested in the SELECT statement will be limited. Explain that limitation.
. What is the evaluation order for the Boolean operators(AND, OR, NOT) in an SQL command? How can a query writer be sure that the operators will work in a specific, desired order?
. What is the difference between COUNT, COUNT DISTINCT, and COUNT(*) in SQL? When will these three commands generate the same and different results?
. How is the order in which attributes appear in a result table determined? How are the column heading labels in a result table changed?
. Explain and provide at least one example of how to qualify the ownership of a table in SQL. What has to occur for one user to be allowed to use a table in a database owned by another user?
. Explain the factors to be considered in deciding whether to create an index for a column in SQL.
. What are the potential consequences of inappropriate indexing decisions?
. Explain the purpose of indexing in database implementation.
. Explain how referential integrity is established in databases that are SQL:1999 compliant. Explain how the ON UPDATE RESTRICT, ON UPDATE CASCADE, and ON UPDATE SET NULL clauses differ from one another.What happens if the ON DELETE CASCADE clause is set?
. What are the primary data integrity constraints in SQL?
. Explain the three classes of SQL commands and when they would be used.
. Describe the components and structure of a typical SQL environment.
. What are some of the advantages and disadvantages of an SQL standard?
. Describe a relational DBMS (RDBMS), its underlying data model, its data storage structures, and how data relationships are established.
. Explain what capabilities the new temporal features added to the SQL standard in SQL:2011.
. What are SQL-92, SQL:1999, SQL:2011, and SQL:2016?Briefly describe how SQL:2016 differs from SQL:1999.
. Contrast the following terms:a. scalar aggregate; vector aggregateb. DDL; DMLc. catalog; schema
. Match the following terms to the appropriate definitions:referential integrity constraint SQL:2016 null value scalar aggregate vector aggregate catalog schema host languagea. list of valuesb. description of a databasec. missing or nonexistent valued. descriptions of database objects of a
. Define each of the following terms:a. data definition languageb. data manipulation languagec. referential integrity constraintd. relational DBMS (RDBMS)e. schema
If necessary, revisit and modify the EER diagram you created in Chapter 3, 3-44, to reflect any changes made in answering 4-64 and 4-65 above.
Does it make sense for FAME to use enterprise keys? If so, create the appropriate enterprise keys and revise the relational schema accordingly.
Analyze and document the functional dependencies in each relation identified in 4-63 above. If any relation is not in 3NF, decompose it into 3NF, using the steps described in this chapter. Revise your relational schema accordingly.
Map the EER diagram you developed in Chapter 3, 3-44, to a relational schema using the techniques described in this chapter. Be sure to appropriately identify the primary and foreign keys as well as clearly state referential integrity constraints.
Look for a receipt from a supermarket or other retail store you have purchased from. Based on the receipt, draw an EER diagram of the data in this form or report. Transform the diagram into a set of 3NF relations.
Using the online Appendix B, available on the book’s Web site, as a resource, interview a database analyst/designer to determine whether he or she normalizes relations to higher than 3NF. Why or why not does he or she use normal forms beyond 3NF?
Obtain an EER diagram from a database administrator or system designer. Based on what you have learned in this book, convert this into a relational schema in 3NF.Now interview the administrator on how they convert the diagram into relations. How do they impose integrity constraints? What was the
Interview system designers and database designers at several organizations. Ask them to describe the process they use for logical design. How do they transform their conceptual data models (e.g., E-R diagrams) to relational schema? What is the role of CASE tools in this process? Do they use
A university library system is responsible for tracking information about its books and users. At present, it offers lending facilities to over 5,000 students and has a catalog exceeding 1,000 books and periodicals. It is essential for the library to effectively keep track of what items have been
A price aggregator system provides users with a onestop portal where they can compare the price of products across multiple Web sites. The portal allows users to not only compare prices but also view customer feedback and reviews of the different Web sites. Users are required to first create an
Jack Patel is a huge comic book fan who is looking to turn his hobby into a business. Spotting a gap in the market, he intends to create a comic rental business to provide locals with access to comics and tap into the growing interest in superheroes. Jack currently has over 5,000 comics and graphic
The following attributes form a relation that includes information about the issue and return of books by students from a university library. Students of each department in the university are authorized to issue and return the books after a specific time period (characterized with attributes Issue
Explore the data included in Table 4-9.Assume that the primary key of this relation consists of two components: Author’s ID (AID) and Book number BNbr). The relation includes data regarding authors, books, and publishers. In addition, it tells what an individual author’s per book royalty amount
Figure 4-40 shows an EER diagram for a university dining service organization that provides dining services to a major university.a. Transform the EER diagram to a set of relations and develop a relational schema.b. Diagram the functional dependencies and determine the normal form for each
How would Problems and Exercises 4-50 and 4-51 change if a type of fish could be supplied by multiple suppliers?
For Problem and Exercise 4-50, draw the ER diagram based on the normalized relations.
A pet store currently uses a legacy flat file system to store all of its information. The owner of the store, Peter Corona, wants to implement a Web-enabled database application.This would enable branch stores to enter data regarding inventory levels, ordering, and so on. Presently, the data for
Examine the set of relations in Figure 4-39. What normal form are these in? How do you know this? If they are in 3NF, convert the relations into an EER diagram. What assumptions did you have to make to answer these questions?
Figure 4-38 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
Figure 4-37 includes an EER diagram describing a publisher specializing in large edited works. Transform the diagram into a relational schema that shows referential integrity constraints(see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
Figure 4-36 includes an EER diagram describing a car racing league. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
For your answers to Problem and Exercise 3-33 from Chapter 3, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form.
Figure 4-35 shows an EER diagram for Vacation Property Rentals. This organization rents preferred properties in several states. As shown in the figure, there are two basic types of properties: beach properties and mountain properties.a. Transform the EER diagram to a set of relations and develop a
Table 4-8 shows extracts from a customer’s flight booking confirmation. The booking is identified by the booking reference, which in turn identifies the customer id, their flight origin, and final destination. This booking reference also states the number of air miles eligible, which can also be
The materials manager at Pine Valley Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors.Table 4-7 shows the essential data required for this application.a. Draw a dependency diagram for this data. You may assume the
The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.)a. Convert this table to a relation in first normal
Transform Figure 2-15a, attribute version, to 3NF relations.Transform Figure 2-15b, relationship version, to 3NF relations.Compare these two sets of 3NF relations with those in Figure 4-10. What observations and conclusions do you reach by comparing these different sets of 3NF relations?
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form.a. Chapter 3, Problem and Exercise 3-30b. Chapter 3, Problem and
Transform the relational schema developed in Problem and Exercise 4-37 into an EER diagram. State any assumptions that you have made.
Table 4-5 shows a shipping manifest. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation?c. Decompose MANIFEST into a set of 3NF relations.d. Draw a relational schema for your 3NF relations and
Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation?c. Decompose GRADE REPORT into a set of 3NF relations.d. Draw a relational
Figure 4-34 shows an EER diagram for a restaurant, its tables, and the waiters and waiting staff managers who work at the restaurant. Your assignment is to:a. Develop a relational schema.b. Show the functional dependencies.c. Develop a set of 3NF relations using an enterprise key.
Table 4-3 contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions)uniquely identify parts and that vendor names uniquely identify vendors.a. Convert this table to a relation (named PART SUPPLIER)in
Figure 4-33 shows an EER diagram for a simplified credit card environment. There are two types of card accounts:debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge as well as the primary keys of merchant
Figure 4-32 shows a class list for Millennium College.Convert this user view to a set of 3NF relations using an enterprise key. Assume the following:• An instructor has a unique location.• A student has a unique major.• A course has a unique title.
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form:a. Chapter 2, Problem and Exercise 2-39bb. Chapter 2, Problem and
For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies(other than those implied by the primary key) are shown where appropriate.a. EMPLOYEE(EmployeeNo, ProjectNo)b.
For each of the following EER diagrams from Chapter 3:I. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).II. For each relation, diagram the functional dependencies(see Figure 4-23 for an example).III. If
For each of the following E-R diagrams from Chapter 2:I. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).II. For each relation, diagram the functional dependencies(see Figure 4-23 for an example).III. If any
What are the benefits of the use of an enterprise key?
Why is the natural key preserved whenever a surrogate key is created?
Describe the difference between how a 1:M unary relationship and an M:N unary relationship are implemented in a relational data model.
What is an enterprise key, and why is it important?
Under what conditions must a foreign key not be null?
What are the properties that a candidate key must satisfy?
In the context of unary relationships, what is a recursive foreign key?
Showing 1300 - 1400
of 3225
First
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
Last
Step by Step Answers
Get 50% OFF
Claim Now
