190 likes | 212 Views
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.
E N D
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 • 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.
II. Using Database • Database can be used to store information
II. Using Databases (cont.) • Databases and their Characteristics • Database Examples • Components of a Database System • Database Design
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.
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.
2. Database Examples • Single-User Database Applications • Multiuser Database Applications • E-commerce Database Applications • Reporting and Data Mining Database Applications
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
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.
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, …
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, …
4. Database Design 4.1 Database Design from Existing Data 4.2 Database Design from New Systems Development 4.3 Database Design from Redesign
4.1 Database Design from Existing Data The first type of database design involves databases that are constructed from existing data
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)
4.2 Database Design from New Systems Development The second way that databases are designed is from the development of new information systems
4.3 Database Design from Redesign Database redesign is covered in Chapter Eight, after coverage of SQL in Chapter Seven