Database Processing: Fundamentals, Design, and by David M. Kroenke, David J. Auer

By David M. Kroenke, David J. Auer

Get scholars instantly to the purpose of database processing. Database Processing displays a brand new educating process that will get scholars instantly to the purpose with its thorough and sleek presentation of database processing fundamentals.

The 13th variation has been completely up to date to mirror the most recent software program.

Show description

Read or Download Database Processing: Fundamentals, Design, and Implementation (13th Edition) PDF

Best databases books

Oracle9i DBA JumpStart

Drawn to a profession as an Oracle database expert yet have no idea the place to start? The Oracle9i OCA and OCP certifications are of the most popular IT certifications round, and the Oracle9i DBA JumpStart from Sybex grants you with the forged beginning in database management and programming fundamentals you have to prior to embarking on a entire research application.

Using FileMaker Bento

Get happy with the most recent model of FileMaker Bento. Don’t simply examine it: See it and listen to it with step by step video tutorials and invaluable audio sidebars introduced during the unfastened internet version that incorporates each utilizing booklet. For the cost of the ebook, you get on-line entry wherever with an internet connection–no books to hold, up-to-date content material, and the good thing about video and audio studying.

Microsoft SQL server 2008 R2 master data services : implementation & administration

Most sensible Practices for Deploying and dealing with grasp facts companies (MDS) successfully deal with grasp info and force higher selection making throughout your small business with particular guideline from MDS specialists. Microsoft SQL Server 2008 R2 grasp info prone Implementation ' management indicates you the way to take advantage of MDS to centralize the administration of key information inside your company.

Extra resources for Database Processing: Fundamentals, Design, and Implementation (13th Edition)

Example text

This fact is not ­surprising when we consider that every information system needs to store data and the relationships among those data. Still, the vast array of applications that use this technology is staggering. Consider, for example, the applications listed in Figure 1-5. Single-User Database Applications In Figure 1-5, the first application is used by a single salesperson to keep track of the customers she has called and the contacts that she’s had with them. com) or ACT! com/sage-act). Multiuser Database Applications The next applications in Figure 1-5 are those that involve more than one user.

In this case, the query asks for the last name, first name, and e-mail address of all students having a StudentNumber greater than 2. The results of this SQL statement are shown (as displayed in Microsoft Access 2013) in Figure 1-10. As shown in Figure 1-10, running this SQL statement will produce the LastName, FirstName, and EmailAddress for students Harris and Greene. The third function of an application is to create and process reports. This function is somewhat similar to the second because the application program first queries the DBMS for data (again using SQL).

The DBMS in an Enterprise-Class Database System As stated earlier, the DBMS manages the database. It processes SQL statements and provides other features and functions for creating, processing, and administering the database. Figure 1-17 presents the five most prominent DBMS products. The products are shown in order of increasing power, features, and difficulty of use. Microsoft Access (really the Microsoft ADE) is the easiest to use and the least powerful. Oracle MySQL is a powerful, open source DBMS frequently chosen for Web applications.

Download PDF sample

Rated 4.09 of 5 – based on 17 votes