1.3 Understand Data Model

Database design chapter 1.3

Get Started. It's Free
or sign up with your email address
1.3 Understand Data Model by Mind Map: 1.3 Understand Data Model

1. - physical representation of the DB on the computer

2. Internal level

3. - Offer organisations the ability to manage large amount of data and in manner that enables many users to access and update the data simultaneously.

4. #Benefits

4.1. Inexpensive

4.2. User friendly

4.3. Offer web solution

5. Example - Microsoft SQL server, Oracle and IBM DB2

6. Example - Microsoft access , FoxPro, FileMaker Pro, Paradox and Lotus Approach are the major players.

7. - Desktop database offer an inexpensive , simple solution to many less complex data storage and manipulation requirements.

8. - the relationships among the data

9. Flexibility -can handle just about any data management problem, Available for multiple operating system.

10. Database server is a software which runs on the server computer to provide database services to the database client.

10.1. Client – presents the user interface and process applications. Workstation (usually a PC) that requests and uses a service. manages user interface and runs applications.

11. Three-schema architecture of DBMS

11.1. External level

11.1.1. - the user's view of the database

11.1.2. - Consists of a number of different external views of thr DB

11.1.2.1. - The logical structure of the entire database as seen by DBA

11.1.2.1.1. - What data is stored in the database

11.1.3. - Describes parts of the DB for particular group of users

11.2. Conceptual level

11.2.1. - how the data is stored in the database

12. Categories of DBMS

12.1. 2. Server Database

12.1.1. Powerful Performance - can manage multiple high speed processors, clustered servers , high bandwidth connectivity and fault tolerant storage technology.

12.2. 1. Desktop Database

12.2.1. #Benefits

12.2.1.1. Scalability - able to gracefully handle a rapidly expanding amount of users and data.

13. Client-Server Architecture of DBMS

13.1. Database and DBMS are stored in a computer known as server.

13.2. Server – Computer (PC/mini/mainframe) that provides a needed services to the client. Holds database and DBMS. For DBMS, server is a database server.