Access 2016 chapter 4 enhancing tables pdf download

Books Video icon An illustration of two cells of a film strip. Video Audio icon An illustration of an audio speaker. Audio Software icon An illustration of a 3. Software Images icon An illustration of two photographs. Images Donate icon An illustration of a heart shape Donate Ellipses icon An illustration of text ellipses.

Excel - - - Bible Item Preview. EMBED for wordpress. Want more? It is the version of SQL supported by most commonly used relational database management systems. Why is SQL described as a data sublanguage?

A data sublanguage consists only of language statements for defining and processing a database. To obtain a full programming language, SQL statements must be embedded in scripting languages such as VBScript or in programming languages such as Java or C. What does DML stand for? What are DML statements? DML stands for data manipulation language. DML statements are used for querying and modifying data.

What does DDL stand for? What are DDL statements? DDL stands for data definition language. DDL statements are used for creating tables, relationships. In this framework:. All data manipulation is expressed in SQL in these products.

The eight tables in the revised Cape Codd database schema are shown in Figure You may have already created this database as suggested in Chapter 2 and used it to run the SQL queries discussed in the chapter.

Whenever possible, all results were obtained by. As explained in the text, some queries cannot be run in Microsoft Access , and for those queries the correct result was obtained using Microsoft SQL Server Solutions to Review Questions 2. Specifically, why did we include it? Otherwise, a two table query would be required. Sort the results in ascending order by WarehouseID. Note that, as discussed in Chapter 2, Microsoft Access uses wildcard characters that differ from the SQL standard.

Include meaningful column names in the result. To correct this, we use an SQL statement with the un-aliased computation:. In your answer to Review Question 2. Otherwise there would be ambiguity in the SQL statement and the results would differ according to which clause was applied first.

Do not use the IN keyword. Use the IN keyword. Since we want the query output for warehouses that are not Atlanta or Bangor or Chicago as a set, we must ask for warehouses that are not in the group Atlanta and Bangor and Chicago.

This happens because each OR eliminates only one warehouse, but that warehouse still qualifies for inclusion in the other OR statements. Do not be concerned with removing leading or trailing blanks. Use a subquery. Warehouse—the query will NOT work without them.

Explain why you cannot use a subquery in your answer to question 2. In a query that contains a subquery, only data from fields in the table used in the top-level query can be included in the SELECT statement.

If data from fields from other tables are also needed, a. In question 2. Therefore, we had to use a join. Explain how subqueries and joins differ. If data from fields from other tables are also needed, a join must be used. See the answer to question 2. In Chapter 8, correlated subqueries will be discussed, and correlated subqueries do not have an equivalent join structure—you must use subqueries.

Run this statement. SKU, I. QuantityOnHand, I. SKU, CS Founded in in Seattle, Washington, WPC has grown into an internationally recognized organization. The company is located in two buildings.

One building houses the Administration, Accounting, Finance, and Human Resources departments, and the second houses the Production, Marketing, and Information Systems departments. The company database contains data about company employees, departments, company projects, company assets such as computer equipment, and other aspects of company operations. In the following project questions, we have already created the WPC.

Solutions to Project Questions 2. In the Edit Relationship dialog box, enable enforcing of referential integrity and cascading of data updates, but do not enable cascading of data from deleted records.

We will define cascading actions in Chapter 6. In the Edit Relationship dialog box, enable enforcing of referential integrity, but do not enable either cascading updates or the cascading of data from deleted records. In the Edit Relationship dialog box, enable enforcing of referential integrity and cascading of deletes, but do not enable cascading updates.

In Project Question 2. Why was the data entered after the referential integrity constraints were created instead of before the constraints were created? If data was entered into these columns before the referential integrity constraints were established, it would be possible to enter foreign key data that had no corresponding primary key data.

Thus, we establish the referential integrity constraints so that the DBMS will not allow inconsistent data to be entered into the foreign key columns. Save each query using the query name format SQL-Query , where the sign is replaced by the letter designator of the question. Show all information for each project. Investor Relations. Review a Brill Book. Reference Works.

Primary source collections. Open Access Content. Contact us. Sales contacts. Publishing contacts. Social Media Overview. Terms and Conditions. Privacy Statement. Login to my Brill account Create Brill Account. Authors: Nicola Poole and Sophie Leslie. Login via Institution. Purchase instant access PDF download and unlimited online access :.

Add to Cart. PDF Preview. Save Cite Email this content Share link with colleague or librarian You can email a link to this page to a colleague or librarian:. Your current browser may not support copying via this button. Higher Education. Educational Technology. Table of Contents.