Database Processing: Fundamentals, Design, and Implementation
Revised 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.
40 pages matching functional dependencies in this book
Results 1-3 of 40
What people are saying - Write a review
Other editions - View all
Access ARTIST ArtistID attributes BCNF Buyer candidate key Chapter child CREATE TABLE cursor CUSTOMER CustomerlD 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 exist Explain ExtendedPrice FirstName foreign key functional dependencies ID-dependent entity identifier INSERT intersection table isolation level Java lock Microsoft minimum cardinality multivalued dependencies MySQL N:M relationship Nancy Meyers NULL object ODBC OLE DB Oracle OrderNumber parent Pete Hansen Phone PhoneNumber primary key problem query record referential integrity referential integrity constraint relation result rowcount 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 weak entity WorkID XML document XML Schema