Database Processing: Fundamentals, Design, and ImplementationRevised to reflect the needs of today's users, this 10 th edition ofDatabase Processingassures that you will learn marketable skills. By presenting SQL SELECT statements near the beginning of the book readers will know early on how to query data and obtain resultsseeing firsthand some of the ways that database technology is useful in the marketplace. By utilizing free software downloads, you will be able to actively use a DBMS product by the end of the 2 nd chapter. Each topic appears in the context of accomplishing practical tasks. Its spiral approach to database design (incorporating all 3 sources: from the integration of existing data, from new information, and the need to redesign an existing database) provides users with enhanced information not available in other database books on the market. Topics include: SQL, database design, implementation, processing, access standards, and business intelligence.An excellent reference and handbook for information systems professionals such as database administrators, database designers, systems analysts, web-database developers, and programmers of database applications. |
Contents
Getting Started 1 | 1 |
Query Language | 27 |
Database Design | 67 |
Copyright | |
35 other sections not shown
Other editions - View all
Database Processing: Fundamentals, Design, and Implementation David Kroenke No preview available - 2006 |
Common terms and phrases
1:N relationship Access application ARTIST ArtistID attributes BCNF Buyer candidate key Chapter child column CREATE TABLE cursor CUSTOMER CustomerID data model data type database design database processing dataset DBMS products default defined delete Department DepartmentName determine E-R model Email EMPLOYEE EmployeeNumber enforce entity-relationship example ExtendedPrice FirstName foreign key functional dependencies ID-dependent entity IDEF1X identifier INSERT intersection table Java Jerry Martin lock Microsoft minimum cardinality multivalued dependencies MySQL Nancy Meyers NULL object ODBC OLE DB Oracle ORDER_ITEM OrderNumber parent Pete Hansen Phone PhoneNumber Price primary key problem query record referential integrity referential integrity constraint relation result SalesPrice SELECT shown in Figure shows SKU_DATA SKU_Description specify SQL Server SQL statement stored procedures strong entity structure STUDENT StudentNumber subtypes surrogate key transaction triggers update users View Ridge Water Sports WorkID XML document XML Schema xsd:element