Đang chuẩn bị liên kết để tải về tài liệu:
Bài giảng Cơ sở dữ liệu nâng cao - Chapter 1: Creating databases and database files

Bài giảng Cơ sở dữ liệu nâng cao - Chapter 1: Creating databases and database files. Nội dung chính trong chương này gồm có: Introduction to database, creating database, managing database, maintainance to database. . | Chapter 1 Creating Databases and Database Files 9/25/2011 1 Agenda Introduction to database Creating database Managing database Maintainance to database 9/25/2011 2 Database Database: A collection of data that are related in a meaningful way, which can be accessed in different logical orders Database Management System (DBMS): A general purpose software package designed to store and manage database 9/25/2011 3 Simplified database system environment 9/25/2011 4 Database example A UNIVERSITY database for maintaining information concerning students, courses, and grades in a university environment We have: STUDENT file stores data on each student COURSE file stores data on each course SECTION file stores data on each section of each course GRADE_REPORT file stores the grades that students receive PREREQUISITE file stores the prerequisites 9/25/2011 5 Database example 9/25/2011 6 Database example 9/25/2011 7 DBMS Objectives of DBMS: Data availability: users can easily access the data. Data integrity: the data available in the database is a reliable data Data security: only authorized users can access the data. Data Independence: the user to store,update, and retrieve data in an efficient manner. 9/25/2011 8 Three-Schema Architecture Defines DBMS schemas at three levels: Internal schema at the internal level to describe physical storage structures and access paths (e.g indexes). Conceptual schema at the conceptual level to describe the structure and constraints for the whole database for a community of users. External schemas at the external level to describe the various user views. 9/25/2011 9 Three-Schema Architecture 9/25/2011 10 Introduction to SQL Server 2008 MS SQL Server is a Relational Database Management System (RDBMS) designed for use in a network environment. RDBMS is system for storing, manipulating data in a series of related table. 9/25/2011 11 Introduction to SQL Server 2008 MS SQL Server supports 2 computing models: Client/server application model: 9/25/2011 | Chapter 1 Creating Databases and Database Files 9/25/2011 1 Agenda Introduction to database Creating database Managing database Maintainance to database 9/25/2011 2 Database Database: A collection of data that are related in a meaningful way, which can be accessed in different logical orders Database Management System (DBMS): A general purpose software package designed to store and manage database 9/25/2011 3 Simplified database system environment 9/25/2011 4 Database example A UNIVERSITY database for maintaining information concerning students, courses, and grades in a university environment We have: STUDENT file stores data on each student COURSE file stores data on each course SECTION file stores data on each section of each course GRADE_REPORT file stores the grades that students receive PREREQUISITE file stores the prerequisites 9/25/2011 5 Database example 9/25/2011 6 Database example 9/25/2011 7 DBMS Objectives of DBMS: Data availability: users can easily access the data. Data .