Database Concepts (7th Edition)

Database Concepts (7th Edition)

Language: English

Pages: 528

ISBN: 0133544621

Format: PDF / Kindle (mobi) / ePub


For undergraduate database management students or business professionals

 

Here’s practical help for understanding, creating, and managing small databases—from two of the world’s leading database authorities. Database Concepts by David Kroenke and David Auer gives undergraduate database management students and business professionals alike a firm understanding of the concepts behind the software, using Access 2013 to illustrate the concepts and techniques. Three projects run throughout the text, to show students how to apply the concepts to real-life business situations. The text provides flexibility for choosing the software instructors want to use in class; allows students to work with new, complete databases, including Wedgewood Pacific Corporation, Heather Sweeney Designs, and Wallingford Motors; and includes coverage for some of the latest information on databases available.

Teaching and Learning Experience
This text will provide a better teaching and learning experience–for you and your students. Here's how:

  • Provides a firm understanding of the concepts behind the software
  • Uses Access 2013 to illustrate the concepts and techniques while also providing flexibility to choose the software used in class
  • Allows students to work with new, complete databases
  • Includes coverage of some of the latest information available

Handbook of Peer-to-Peer Networking

Neural Networks Theory

Reasoning About Knowledge

Ant: The Definitive Guide (2nd Edition)

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

and to create tables and other supporting structures inside that database. As an example of the latter, suppose that we have an EMPLOYEE table with 10,000 rows and that this table includes a column, DepartmentName, that records the name of the department in which an employee works. Furthermore, suppose that we frequently need to access employee data by DepartmentName. Because this is a large database, searching through the table to find, for example, all employees in the accounting department

and to create tables and other supporting structures inside that database. As an example of the latter, suppose that we have an EMPLOYEE table with 10,000 rows and that this table includes a column, DepartmentName, that records the name of the department in which an employee works. Furthermore, suppose that we frequently need to access employee data by DepartmentName. Because this is a large database, searching through the table to find, for example, all employees in the accounting department

the Navigation Pane shrinks to a small band labeled Navigation Pane on the right side of the Microsoft Access 2013 window. The band will then display the Shutter Bar Open/Close button as a right-facing double-chevron button that we can click to restore the Navigation Pane when we want to use it again. Closing a Database and Exiting Microsoft Access The Close button shown in Figure AW-1-5 is actually a close and exit button. You can click it to close the active database and then exit Microsoft

table and any other tables created in previous steps are also in 3NF. D. Define BCNF. Now that ORDER_ITEM is in 3NF, is it also in BCNF? If not, why not, and what would have to be done to put it into BCNF? Make any changes necessary to put ORDER_ITEM into BCNF. If this step requires you to create an additional table, make sure that the new table and any other tables created in previous steps are also in BCNF. Figure 2-26 The ORDER_ITEM Table 110  Part 1  Database Fundamentals Access

can combine two or more conditions in the WHERE clause by using the AND keyword and the OR keyword. As stated previously, if the AND keyword is used, only rows meeting all the conditions will be selected. However, if the OR keyword is used, then rows that meet any of the conditions will be selected. For example, the following query uses the AND keyword to ask for employees that work in accounting and have the phone number 360-285-8310: /* *** SQL-QUERY-CH03-10 *** */ SELECT FirstName, LastName,

Download sample

Download