All Matches
Solution Library
Expert Answer
Textbooks
Search Textbook questions, tutors and Books
Oops, something went wrong!
Change your search query and then try again
Toggle navigation
FREE Trial
S
Books
FREE
Tutors
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
Ask a Question
Search
Search
Sign In
Register
study help
computer sciences
databases
Questions and Answers of
Databases
Create a System DSN ODBC connection called Ch02_SaleCo using the Administrative Tools section of the Windows Control Panel.
Use MS Excel to list all of the invoice lines for Invoice 1003 using the Ch02_SaleCo System DSN.
Create a System DSN ODBC connection called Ch02_TinyCollege using the Administrative Tools section of the Windows Control Panel.
Use MS Excel to list all classes taught in room KLR200 using the Ch02_TinyCollege System DSN.
Create a sample XML document and DTD for the exchange of customer data.
Create a sample XML document and DTD for the exchange of product and pricing data.
Create a sample XML document and DTD for the exchange of order data.
Explain the difference between data and information. Give some examples of raw data and information.
Define dirty data and identify some of its sources.
What is data quality, and why is it important?
Explain the interactions among end user, data, information, and decision-making. Draw a diagram and explain the interactions.
Suppose that you are a DBA. What data dimensions would you describe to top-level managers to obtain their support for endorsing the data administration function?
How and why did database management systems become the organizational data management standard in organizations? Discuss some of the advantages of the database approach over the file-system approach.
Define security and privacy. How are these two concepts related?
What special considerations must you take into account when introducting a DBMS into an organization?
Describe the DBA's responsibilities.
How can the DBA function be placed within the organization chart? What effect(s) will such placement have on the DBA function?
Why and how are new technological advances in computers and databases changing the DBA's role?
What are the typical activities involved in the maintenance of the DBMS and its utilities and applications? Would you consider application performance tuning to be part of the maintenance activities?
In Oracle, what is a datafile? How does it differ from a file systems file?
In Oracle, what is a database schema?
How is it possible to get more information from the same amount of data by using a database approach as opposed to a nondatabase approach?
What is a DBA? What kinds of responsibilities does a DBA have in a database environment?
How does consistency result from controlling redundancy?
What is an integrity constraint? When does a database have integrity?
What is security? How does a DBMS provide security?
What is data independence? Why is it desirable?
How is file size a disadvantage in a database environment?
How can the complexity of a DBMS be a disadvantage?
Besides redundancy, what other problems are associated with the nondatabase approach to processing data?
Why can a failure in a database environment be more serious than an error in a nondatabase environment?
Why might recovery of data be more difficult in a database environment?
What is an entity? An attribute?
What is a relationship? A one-to-many relationship?
What is an E-R diagram?
1. List the names of all customers that have a credit limit less than $10,000.2. List the descriptions of all parts in item class AP and located in warehouse number 3.3. List the order numbers for
1. List the name of each publisher that’s not located in New York.2. List the title of each book published by Penguin USA.3. List the title of each book that has the type MYS.4. List the title of
1. List the owner number, last name, and first name of every boat owner.2. List the names of all boats that are stored in a slip with a length of less than 30 feet.3. List the last name, first name,
What is a relation?
In which row of the Access design grid do you include functions? What functions can you use in Access queries?
When sorting data on more than one field in an Access query, which field is the major sort key? Which field is the minor sort key? What effect do these keys have on the order in which the rows are
What is relational algebra?
Describe the shorthand representation of the structure of a relational database. Illustrate this technique by representing the database for Henry Books as shown in Chapter 1.
What does it mean to qualify a field name? How would you qualify the Street field in the Customer table?
What is a primary key? What is the primary key for each table in the Henry Books database shown in Chapter 1?
1. List the number and name of all customers.2. List the complete Part table.3. List the number and name of all customers represented by sales rep 35.4. List the number and name of all customers that
1. List the number and name of all sales reps.2. List all information from the Part table for part FD21.3. List the order number, order date, customer number, and customer name for each order.4. List
1. List the name of each publisher that’s not located in New York.2. List the title of each book published by Penguin USA.3. List the title of each book that has the type MYS.4. List the title of
1. List the owner number, last name, and first name of every boat owner.2. List the complete Marina table (all rows and all columns).3. List the last name and first name of every owner located in
Describe the process of creating a table in SQL and the different data types you can use for fields.
How do you qualify the name of a field in an SQL query? When is it necessary to do so?
How do you take the union of two tables in SQL? What criteria must the tables meet to make a union possible?
Describe the three update commands in SQL.
What is the purpose of the WHERE clause in SQL? Which comparison operators can you use in a WHERE clause?
How do you write a compound condition in an SQL query? When is a compound condition true?
What is a computed field? How can you use one in an SQL query? How do you assign a name to a computed field?
How do you use the LIKE and IN operators in an SQL query?
How do you sort data in SQL? When there is more than one sort key, how do you indicate which one is the major sort key? How do you sort data in descending order?
How do you group data in SQL? When you group data in SQL, are there any restrictions on the items that you can include in the SELECT clause? Explain.
1. List the number and name of all customers.2. List the complete Part table.3. List the number and name of every customer represented by sales rep 35.4. List the number and name of all customers
1. List the name of each publisher that’s not located in New York.2. List the title of each book published by Penguin USA.3. List the title of each book that has the type MYS.4. List the title of
1. List the owner number, last name, and first name of every boat owner.2. List the complete Marina table (all rows and all columns).3. List the last name and first name of every owner located in
What is a view? How do you define a view? Does the data described in a view definition ever exist in that form? What happens when a user accesses a database through a view?
Why is it a good idea for the DBMS to update the catalog automatically when a change is made in the database structure? Could users cause problems by updating the catalog themselves? Explain.
What are nulls? Which field cannot accept null values? Why?
State the three integrity rules. Indicate the reasons for enforcing each rule.
The Orders table contains a foreign key, CustomerNum, that must match the primary key of the Customer table. What type of update to the Orders table would violate referential integrity? If deletes do
How would you use SQL to change a table’s structure? What general types of changes are possible? Which commands are used to implement these changes?
What are stored procedures? What purpose do they serve?
What are triggers? What purpose do they serve? How do you gain the functionality of a trigger using Access 2010?
Using data from the Premiere Products database, define a view named TopLevelCust. It consists of the number, name, address, balance, and credit limit of all customers with credit limits that are
Define a view named PartOrder. It consists of the part number, description, price, order number, order date, number ordered, and quoted price for all order lines currently on file.a. Using SQL, write
What is an index? What are the advantages and disadvantages of using indexes? How do you use SQL to create an index?
Describe the GRANT statement and explain how it relates to security. What types of privileges may be granted? How are they revoked?
Write the SQL commands to obtain the following information from the system catalog:a. List every table that you created.b. List every field in the Customer table and its associated data type.c. List
Create the TopLevelCust view described in Review Question 2. Display the data in the view. Review Question 2 Using data from the Premiere Products database, define a view named TopLevelCust. It
Write the code for the following triggers following the style shown in the text.a. When adding a customer, add the customer’s balance times the sales rep’s commission rate to the commission for
If you are using Access 2010, create the following data macros.a. Create a data macro associated with the After Insert event for the Customer table to implement the trigger in Step 12a. Test the data
Create the PartOrder view described in Review Question 3. Display the data in the view. Review Question 3 Define a view named PartOrder. It consists of the part number, description, price, order
Create a view named OrdTot. It consists of the order number and order total for each order currently on file. (The order total is the sum of the number ordered multiplied by the quoted price on each
Create the following indexes. If it is necessary to name the index in your DBMS, use the indicated name.a. Create an index named PartIndex1 on the PartNum field in the OrderLine table.b. Create an
Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Class field are AP, HW, and
Add a field named Allocation to the Part table. The allocation is a number representing the number of units of each part that have been allocated to each customer. Set all Allocation values to zero.
Increase the length of the Warehouse field in the Part table to two characters. Change the warehouse number for warehouse 1 to 1a. Display all the data in the Part table.
1. Create a view named PenguinBooks. It consists of the book code, book title, book type, and book price for every book published by Penguin USA. Display the data in the view.2. Create a view named
1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data
If you are using Access 2010, complete the following steps.a. Add the TotalValue field to the Branch table. Create and run a query on the Copy table to determine the appropriate values for this
Assume the Branch table contains a column called TotalValue that represents the total price for all books at that branch. Following the style shown in the text, write the code for the following
1. Using the types of entities found in the Henry Books database (books, authors, and publishers), create an example of a table that is in first normal form but not in second normal form and an
1. Using the types of entities found in the Alexamara Marina Group database (marinas, owners, boat slips, categories, and service requests), create an example of a table that is in first normal form
Consider a Student table containing StudentNum, StudentName, student’s StudentMajor, student’s AdvisorNum, student’s AdvisorName, student’s AdvisorOfficeNum, student’s AdvisorPhone,
Using your knowledge of the college environment, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an
Again, using your knowledge of the college environment, determine the functional or multivalued dependencies that exist in the following table. After determining the functional dependencies, convert
Define primary key.
Define candidate key.
Define second normal form. What types of problems would you find in tables that are not in second normal form?
Define third normal form. What types of problems would you find in tables that are not in third normal form?
Define fourth normal form. What types of problems would you find in tables that are not in fourth normal form?
Define interrelation constraint and give one example of such a constraint. How are interrelation constraints addressed?
Using your knowledge of Premiere Products, determine the functional dependencies that exist in the following table. After determining the functional dependencies, convert this table to an equivalent
Showing 900 - 1000
of 2962
First
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
Last