Database Management
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Book 1
Book 2
Book 3
Home > Computing and Information Technology > Databases > Database Management: With Website Development Applications
Database Management: With Website Development Applications

Database Management: With Website Development Applications


     0     
5
4
3
2
1



Out of Stock


Notify me when this book is in stock
X
About the Book

Students taking database courses want to know how they'll apply the material to their careers. Database Management: With Web Site Development Applications presents databases in a way that is relevant to today's business environment by applying this information to a world dominated by the Internet. The book discusses basic databases concepts, as well as, how databases are used to support Web sites and organizations. This is the perfect book for students in Information Systems and Information Technology. The book provides a complete overview of the core database concepts for the design, creation, and manipulation of relational data. This material is discussed in the context of how databases are used in business. A running case study brings to life the basic concepts in the context of a video rental database. In this case study, Big Hit Video Inc., readers dissect an existing database to learn about database design, SQL, and the Entity-Relationship model. A second running case study, BigHit Online, allows students to apply database concepts by building an online video store one step at a time. Each chapter concludes with a Case in Point that applies the material from that chapter to BigHit Online. This case study follows the steps of the development process and helps students understand how design decisions that they make early effect what they do later on. The entire BigHit Online system is available on the Web with full source code and sample SQL Server database. After complete coverage of important database concepts, the book discusses how to develop dynamic Web sites with Web applications that interact with databases. Students learn principles of using HTML and CSS to display database information and learn how to design an interactive Web site. They implement their Web sites using SQL Server, JavaScript, Active Server Pages, and HTML. All of this material is accompanied by extensive examples and working Web sites.

Table of Contents:
(Each Chapter concludes with “Chapter Summary,” “Key Terms,” “Questions,” “Exercises,” “Projects,” and “Further Readings.” Chapters One and Two do not contain “Projects.”).I. INTRODUCTION TO INFORMATION TECHNOLOGY AND THE WORLD WIDE WEB. 1. Introduction to Information Systems. What Are Information Systems and Databases? Why Are Databases Important? How Do Databases Represent Information? Who Works with Database Systems? How Do Databases Support the World Wide Web? What Database Concepts and Terms Do You Need to Know? 2. An overview of Internet Architecture and Tools. The Web: What Does It Consist Of? Web Pages and HTML. Web and Information Servers. A Close Look at a Sample Web Site. II. DESIGNING AND SPECIFYING INFORMATION SYSTEMS. 3. Representing Information with Data Models. Data Models. Discovering and Specifying Information Requirements and Terminology. Organizing Information. Relationships and Relationship Types. Case in Point: Determining entity classes, attributes and relationship types for video sales. 4. Designing Entity-Relationship Models. Entity-Relationship Modeling. Entity-Relationship Diagrams. Modeling Video Rentals. Roles in Relationship Types. An E-R Model for BigHit Video. Object-Oriented Data Models. Case in Point: E-R model for video sales for BigHit Video. III. DESIGNING AND CREATING RELATIONAL DATABASES. 5. Developing Relational Data Models. Introduction to the Relational Model. A Closer Look at Relation Schemas and Keys. Translating E-R Diagrams to Relation Schemas. Representing Entity Classes as Relation Schemas. Representing composite, multi-valued, and derived attributes. Composite Attributes. Multi-valued Attributes. Derived Attributes. Representing Relationship Types as Attributes. One-to-many Relationship types. One-to-one Relationship types. Representing One-to-One Relationships by Merging Entities. Representing Many-to-Many Relationships as Tables. Representing Weak Entity Classes. Representing Inheritance as Tables. Case in Point: Relational model for video sales for BigHit Video. 6. Defining Relational Databases with Microsoft Access. Creating an Access Database. Creating Tables in Access. Creating Forms from Tables. Configuring Access for Multiple Users. Specifying Relationship Types in Access. Case in Point: Creating an Access database for Bighit Online Video Sales. 7. Improving Relational Schemas and Normalization. Redundancy and Anomalies in Relation Schemas. Functional Dependencies Between Attributes. Superkeys and Keys. Inferring Additional Functional Dependencies. Determining Keys from Functional Dependencies. Normalization. Third Normal Form (3NF). Boyce-Codd Normal Form (BCNF). Case in Point: Normalization of a Car Registration. IV. MANIPULATING RELATIONAL INFORMATION. 8. Manipulating Database Content with Relational Algebra and Microsoft Access. Manipulating Information in Relational Databases. Projection Queries. Selection Queries. Product Queries. Queries with multiple join. Combining Relational Operations. Defining Complex Queries with Microsoft Access. Applying Set Operators to Tables. Creating User Interfaces in Access. Case in Point: A Video Rental Checkout Form. 9. Using SQL to Manipulate Database Content and Structure. Using SQL Select Statements for Queries. Modifying Database Content with SQL. Creating and Manipulating Schemas with SQL. Case in Point: Manipulating BigHit Online Information with SQL. V. CREATING INTERACTIVE WEB SITES. 10. Presenting Information on the Web with HTML. Introduction to HTML. Example of an HTML Document. Anchor tags, URLs, and references to other documents. Presenting information in tables. Controlling format with style sheets. Using external style sheets and style classes. Case in Point: Design of the BigHit Online Web Site. 11. Creating Interaction between Users and Servers with ASP and JavaScript. Active URLs and Forms in HTML. Server-side scripting with ASP. Processing forms with ASP and JavaScript. Using objects and functions to improve code. Case in Point: Forms and Interaction for BigHit Online. 12. Developing Database Applications for the Web. Connecting to databases with ASP. Executing select queries with ASP. Creating objects from queries. A general purpose query execution script. Inserting new customer information. Handling quote marks in SQL statements. Case in Point: BigHit Online Web-Database Application. VI. DEVELOPING AND MANAGING WEB-DATABASE INTERACTION. 13. Designing an Interactive Web Site. Components of the BigHit Online Web site. Data modeling for BigHit Online. Relational Model for BigHit Online. Creating a SQL Server Database. Web Site Design, Pages, and Flow. 14. Implementing BigHit Online in ASP and JavaScript. Viewing Source Code and SQL Statements. Login and Customer Information. Searching and Adding Items to a Shopping Cart. Checkout Processing. 15. Advanced Issues in Website Design and Implementation. Forms checking with client-side JavaScript. Error handling in server-side JavaScript. Transactions and transaction management. Backup and Recovery from Failures. Security in Information Systems. Stored Procedures and Functions. Case in Point: Transactions and Security in BigHit Online.

About the Author :
Greg Riccardi is a professor of computer science at Florida State University and an associate of the Supercomputer Computations Research Institute. Professor Riccardi's research interests include scientific databases, object-oriented databases, and parallel computation. He is also affiliated with the Thomas Jefferson National Accelerator Facility where he works on the acquisition, management, and analysis of data for experimental physics. He received a University Teaching Award in 1997 from Florida State University.


Best Sellers


Product Details
  • ISBN-13: 9780201743876
  • Publisher: Pearson Education (US)
  • Publisher Imprint: Pearson
  • Height: 285 mm
  • No of Pages: 417
  • Sub Title: With Website Development Applications
  • Width: 223 mm
  • ISBN-10: 0201743876
  • Publisher Date: 19 Sep 2002
  • Binding: Hardback
  • Language: English
  • Spine Width: 20 mm
  • Weight: 1171 gr


Similar Products

Add Photo
Add Photo

Customer Reviews

REVIEWS      0     
Click Here To Be The First to Review this Product
Database Management: With Website Development Applications
Pearson Education (US) -
Database Management: With Website Development Applications
Writing guidlines
We want to publish your review, so please:
  • keep your review on the product. Review's that defame author's character will be rejected.
  • Keep your review focused on the product.
  • Avoid writing about customer service. contact us instead if you have issue requiring immediate attention.
  • Refrain from mentioning competitors or the specific price you paid for the product.
  • Do not include any personally identifiable information, such as full names.

Database Management: With Website Development Applications

Required fields are marked with *

Review Title*
Review
    Add Photo Add up to 6 photos
    Would you recommend this product to a friend?
    Tag this Book Read more
    Does your review contain spoilers?
    What type of reader best describes you?
    I agree to the terms & conditions
    You may receive emails regarding this submission. Any emails will include the ability to opt-out of future communications.

    CUSTOMER RATINGS AND REVIEWS AND QUESTIONS AND ANSWERS TERMS OF USE

    These Terms of Use govern your conduct associated with the Customer Ratings and Reviews and/or Questions and Answers service offered by Bookswagon (the "CRR Service").


    By submitting any content to Bookswagon, you guarantee that:
    • You are the sole author and owner of the intellectual property rights in the content;
    • All "moral rights" that you may have in such content have been voluntarily waived by you;
    • All content that you post is accurate;
    • You are at least 13 years old;
    • Use of the content you supply does not violate these Terms of Use and will not cause injury to any person or entity.
    You further agree that you may not submit any content:
    • That is known by you to be false, inaccurate or misleading;
    • That infringes any third party's copyright, patent, trademark, trade secret or other proprietary rights or rights of publicity or privacy;
    • That violates any law, statute, ordinance or regulation (including, but not limited to, those governing, consumer protection, unfair competition, anti-discrimination or false advertising);
    • That is, or may reasonably be considered to be, defamatory, libelous, hateful, racially or religiously biased or offensive, unlawfully threatening or unlawfully harassing to any individual, partnership or corporation;
    • For which you were compensated or granted any consideration by any unapproved third party;
    • That includes any information that references other websites, addresses, email addresses, contact information or phone numbers;
    • That contains any computer viruses, worms or other potentially damaging computer programs or files.
    You agree to indemnify and hold Bookswagon (and its officers, directors, agents, subsidiaries, joint ventures, employees and third-party service providers, including but not limited to Bazaarvoice, Inc.), harmless from all claims, demands, and damages (actual and consequential) of every kind and nature, known and unknown including reasonable attorneys' fees, arising out of a breach of your representations and warranties set forth above, or your violation of any law or the rights of a third party.


    For any content that you submit, you grant Bookswagon a perpetual, irrevocable, royalty-free, transferable right and license to use, copy, modify, delete in its entirety, adapt, publish, translate, create derivative works from and/or sell, transfer, and/or distribute such content and/or incorporate such content into any form, medium or technology throughout the world without compensation to you. Additionally,  Bookswagon may transfer or share any personal information that you submit with its third-party service providers, including but not limited to Bazaarvoice, Inc. in accordance with  Privacy Policy


    All content that you submit may be used at Bookswagon's sole discretion. Bookswagon reserves the right to change, condense, withhold publication, remove or delete any content on Bookswagon's website that Bookswagon deems, in its sole discretion, to violate the content guidelines or any other provision of these Terms of Use.  Bookswagon does not guarantee that you will have any recourse through Bookswagon to edit or delete any content you have submitted. Ratings and written comments are generally posted within two to four business days. However, Bookswagon reserves the right to remove or to refuse to post any submission to the extent authorized by law. You acknowledge that you, not Bookswagon, are responsible for the contents of your submission. None of the content that you submit shall be subject to any obligation of confidence on the part of Bookswagon, its agents, subsidiaries, affiliates, partners or third party service providers (including but not limited to Bazaarvoice, Inc.)and their respective directors, officers and employees.

    Accept

    Fresh on the Shelf


    Inspired by your browsing history


    Your review has been submitted!

    You've already reviewed this product!