Essentials of Database Management 1st edition Jeffrey A. Hoffer, Heikki Topi, Ramesh Venkataraman - Solutions

List all sales territories (TerritoryID) that have more than one salesperson.
For each customer who had more than two orders, list the CustomerID and the total number of orders placed.
For each salesperson, list the total number of orders.
For each customer, list the CustomerID and the total number of orders placed in 2010.
Display the product ID and the number of orders placed for each product. Show the results in decreasing order by the number of times the product has been ordered and label this result column NumOrders.
For each salesperson, display a list of CustomerIDs.
For each customer, list the CustomerID and total number of orders placed.
For every product that has been ordered, display the product ID and the total quantity ordered (label this result TotalOrdered). List the most popular product first and the least popular last.
What can be changed about a table definition, using the ALTER SQL command? Can you identify anything about a table definition that cannot be changed using the ALTER SQL command?
Display the product line ID and the average standard price for all products in each product line.
List all raw materials that are made of cherry and that have dimensions (thickness and width) of 12 by 12.
Within which clauses of an SQL statement can a derived table be defined?
Which employees were hired during 1999?
List the employees whose last names begin with an L.
When would the use of the LIKE keyword with the CREATE TABLE command be helpful?
Add an order to the Order_T table and include a sample value for every attribute.a. First, look at the data in the Customer_T table and enter an order from any one of those customers.b. Enter an order from a new customer. Unless you have also inserted information about the new customer in the
Enter sample data of your own choosing into QtyOnHand in the Product_T table. Test the modification you made in Problem and Exercise 16 by attempting to update a product by changing the inventory to 10,000 units. Test it again by changing the inventory for the product to –10 units. If you do not
Modify the Product_T table by adding an attribute QtyOnHand that can be used to track the finished goods inventory. The field should be an integer field of five characters and should accept only positive numbers.
Write SQL queries to answer the following questions: a. Which students are enrolled in Database and Networking? (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 2008?b. Which faculty members have qualified to teach a course since 1993? List the faculty ID, course, and date of qualification.The class scheduling 3NF relations along
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 2008?The class scheduling 3NF relations along with some
Use SQL to define the following view: StudentID StudentName Letersky 38214 Altvater 54907 54907 Altvater Aiken 66324
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 key)
Refer to Figure 4-4. For each of the following reports (with sample data), indicate any indexes that you feel would help the report run faster as well as the type of index:a. State, by products (user-specified period)State, by Products Report, January 1, 2010, to March 31,2010b. Most frequently
Explain the reasons why some observers are against the practice of denormalization.
What options are available for controlling data integrity at the field level?
Consider the following normalized relations for a sports league:TEAM(TeamID, TeamName, TeamLocation) PLAYER(PlayerID, PlayerFirstName, PlayerLastName, PlayerDateOfBirth, PlayerSpecialtyCode) SPECIALTY(SpecialtyCode, SpecialtyDescription) CONTRACT(TeamID, PlayerID, StartTime, EndTime, Salary)
Explain why you sometimes have to reserve much more space for a numeric field than any of the initial stored values requires.
Consider the following normalized relations from a database in a large retail chain:STORE (StoreID, Region, ManagerID, SquareFeet) EMPLOYEE (EmployeeID, WhereWork, EmployeeName, EmployeeAddress) DEPARTMENT (DepartmentID, ManagerID, SalesGoal) SCHEDULE (DepartmentID, EmployeeID, Date)What
What are the objectives of selecting a data type for a field?
You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter? What E-R notations did not translate well to your tool? How did you incorporate the E-R notation that
There is a bulleted list associated with Figure 2-21 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-21 described by that point. SALESPERSON TERRITORY DOES BUSINESS IN PK Salesperson ID Serves PK
Explain the distinction between entity type and entity instance.
Give three reasons why many system designers believe that data modeling is the most important part of the systems development process.
Consider the SQL query in Figure 1-19.a. How is Sales to Date calculated?b. How would the query have to change if Helen Jarvis wanted to see the results for all of the product lines, not just the Home Office product line? SELECT Product.ProductID, Product.ProductDescription,
Consider Figure 1-14. Explain the meaning of the line that connects ORDER to INVOICE and the line that connects INVOICE to PAYMENT. What does this say about how Pine Valley Furniture Company does business with its customers? PRODUCT CUSTOMER LINE Places Includes Contains Has ORDER PRODUCT
List three additional entities that might appear in an enterprise data model for Pine Valley Furniture Company (Figure 1-3a). CUSTOMER Places Is Placed By ORDER Contains Is Contained In PRODUCT
Consider Figure 1-12, which depicts a hypothetical threetiered database architecture. Identify potential duplications of data across all the databases listed on this figure. What problems might arise because of this duplication? Does this duplication violate the principles of the database approach
Figure 1-21 shows an enterprise data model for a pet store. a. What is the relationship between Pet and Store (one-toone, many-to-many, or one-to-many)?b. What is the relationship between Customer and Pet?c. Do you think there should be a relationship between Customer and Store? STORE Has Sold
Great Lakes Insurance would like to implement a relational database for both its in-house and outside agents. The outside agents will use notebook computers to keep track of customers and policy information. Based on what you have learned in this chapter, what type (or types) of database(s) would
Consider a student club or organization in which you are a member. What are the data entities of this enterprise? List and define each entity. Then, develop an enterprise data model showing these entities and important relationships between them.
In the three-schema architecture:a. The view of a manager or other type of user is called the______schema.b. The view of the data architect or data administrator is called the______ schema.c. The view of the database administrator is called the______ schema.
In which of the five phases of the SDLC do database development activities occur?
Name the five phases of the traditional systems development life cycle (SDLC), and explain the purpose and deliverables of each phase.
Contrast the following terms:A. Data dependence; data independenceB. Structured data; unstructured dataC. Data; informationD. Repository; databaseE. Entity; enterprise data modelF. Data warehouse; erp systemG. Two-tier databases; multitier databasesH. Systems development life cycle; prototypingI.
Reread the definitions for data and database. Database management systems only recently began to include the capability to store and retrieve more than numeric and textual data. What special data storage, retrieval, and maintenance capabilities do images, sound, video, and other advanced data types
Define each of the following terms:A. DataB. InformationC. MetadataD. Database applicationE. Data warehouseF. ConstraintG. DatabaseH. EntityI. Database management systemJ. Client/server architectureK. Systems development life cycle (sdlc)L. Agile software developmentM. Enterprise data modelN.

Showing 100 - 200 of 147

1
2

Step by Step Answers