1 / 19

Chapter 0

Chapter 0. Introduction. Contents. Storing Student Information Problem Using Database Databases and their Characteristics Database Examples. Components of a Database System. Database Design. I. Storing Student Information Problem.

czerwinski
Download Presentation

Chapter 0

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 0 Introduction

  2. Contents • Storing Student Information Problem • Using Database • Databases and their Characteristics • Database Examples. • Components of a Database System. • Database Design

  3. I. Storing Student Information Problem • A university need store its student information, lists of classes, student’s grades. • Each student has the following information: Student Number, Student Name, Email Address • A class has Class Number, Name, Term. • Grade information includes Student Number, Class Number, Grade. • All information needs to be computerized and stored logically. • We need a persistent storage. This storage must also be reliable.

  4. II. Using Database • Database can be used to store information

  5. II. Using Databases (cont.) • Databases and their Characteristics • Database Examples • Components of a Database System • Database Design

  6. 1. Databases and their Characteristics 1.1 Databases store data in tables. 1.2 All databases throughout the world, store instances in rows and characteristics in columns.

  7. 1.3 A note on Conventions • Table names in Capital letters. • Column names in Capital of first letter. 1.4 A Database Has Data and Relationships 1.5 Summary: Database store data in tables, and they represent the relationships among the rows of those tables.

  8. 2. Database Examples • Single-User Database Applications • Multiuser Database Applications • E-commerce Database Applications • Reporting and Data Mining Database Applications

  9. 3. Components of a Database System 3.1 Applications 3.2 SQL (Structured Query Language) 3.3 The DBMS (Database Management System) 3.4 Database Applications

  10. 3.1 Applications are computer programs that users interact with directly. 3.2 SQL (Structured Query Language) is an internationally recognized standard language that is understood by all commercial database management system products.

  11. 3.3 The DBMS (Database Management System) Create, processes, and administers the database. A DBMS is a large of complicated product and few organizations write their own DBMS program. Examples: Microsoft, Oracle, IBM, …

  12. 3.4 Database Applications • Desktop applications: • Microsoft: Visual Basic, C++, VB.NET, C#. • Borland: Delphi • Open Source: Java • Web applications: • Microsoft: ASP, ASP.NET • Open source: PHP, JSP, … • Web Server: • IIS (Internet Information Server) • Apache • Browser: Internet Explorer, Firefox, Opera, Netscape, …

  13. 3.4 Database Applications (cont.)

  14. 4. Database Design 4.1 Database Design from Existing Data 4.2 Database Design from New Systems Development 4.3 Database Design from Redesign

  15. 4.1 Database Design from Existing Data The first type of database design involves databases that are constructed from existing data

  16. 4.1 Database Design from Existing Data (cont.) This is an important decision, and based on a set of rules known as normalization (which is covered in Chapter Three)

  17. 4.2 Database Design from New Systems Development The second way that databases are designed is from the development of new information systems

  18. 4.3 Database Design from Redesign Database redesign is covered in Chapter Eight, after coverage of SQL in Chapter Seven

  19. ?

More Related