Questions and Answers of Essentials Database Management

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
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
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
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
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
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)
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)
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?
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
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
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
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
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
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
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
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
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;
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
Define each of the following terms:A. DataB. InformationC. MetadataD. Database applicationE. Data warehouseF. ConstraintG. DatabaseH. EntityI. Database management systemJ. Client/server

Showing 100 - 200 of 129

1
2