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

 

 

 

 

 

 

 

 

 

 

Note that some columns on the right side of the datasheet do not appear in the window, but you can access them by scrolling or minimizing the Navigation Pane. ■■ Note:  As in a worksheet, the intersection of a row and column in a datasheet is called a cell. 2. Click the Shutter Bar Open/Close button to collapse the Navigation Pane. This makes more of the CUSTOMER datasheet visible, as shown in Figure AW-1-26. Figure AW-1-25 The CUSTOMER Table in Datasheet View The TABLE TOOLS tab If you need to

paper on normal forms, it was pointed out to him that even relations in 3NF could have anomalies. As a result, he and R. Boyce defined the Boyce-Codd Normal Form (BCNF), which eliminated the anomalies that had been found with 3NF. As stated earlier, a relation is in BCNF if and only if every determinant is a candidate key. For BCNF, ask yourself: (1) Is the table in 3NF, and (2) are all determinants also candidate keys? If the answers are yes and yes, then the table is in BCNF. 1NF through BCNF

BC-400-10 BLDG01-140 360-285-8400 Human Resources BC-500-10 BLDG01-180 360-285-8500 Production BC-600-10 BLDG02-100 360-287-8600 Marketing BC-700-10 BLDG02-200 360-287-8700 InfoSystems BC-800-10 BLDG02-270 360-287-8800 B. For the DEPARTMENT table, create a data input form named WPC Department Data Form. Make any necessary adjustments to the form so that all data display properly. Use this form to enter into your DEPARTMENT table the data in the DEPARTMENT table shown in

to query data in many ways. You can also use it to change and delete data, but the SQL statements for these activities will be easier to learn if we begin with the query statements. In the following discussion, assume that the sample data shown in Figure 3-2 have been entered into the database. 144  Part 1  Database Fundamentals The SQL SELECT/FROM/WHERE Framework This section introduces the fundamental statement framework for SQL query statements. After we discuss this basic structure, you

EMPLOYEE AS E, ASSIGNMENT AS A WHERE E.EmployeeNumber = A.EmployeeNumber GROUP BY LastName, FirstName; Note another use for the AS keyword, which is now used to assign aliases to table names so that we can use these aliases in the WHERE clause. This makes it much easier to write queries with long table names. The result of this query is: Chapter 3   Structured Query Language   167 Or we could apply a WHERE clause during the process of creating the join as follows: /* *** SQL-QUERY-CH03-46

Download sample

Download