Database Design

Get Started. It's Free
or sign up with your email address
Database Design by Mind Map: Database Design

1. Data are facts about object, thing, person, entity, event or anything similar to it

2. 5. Physical Design

3. What is Data?

4. Common Features of DBMS

4.1. Database Definition

4.1.1. To define entities, relationships, integrity, constrain and authorization.

4.2. Nonprocedural Access

4.2.1. Access data without complicated coding

4.3. Application Development

4.3.1. Graphical tools to develop menus, data entry forms, and report.

4.3.2. Data requirement for form and report.

4.4. Procedural Language

4.4.1. Combines nonprocedural access with full capabilities.

4.5. Transaction Processing

4.5.1. Tools to monitor and improve database perfomance

4.5.2. To prevent interference from simultaneous user. Recover lost data after failure.

4.6. Database Tuning

5. What is Information?

5.1. Data that has been processed

5.2. Can be used to make decision

6. Categories of DBMS

6.1. 1.Desktop Databases

6.2. Desktop databases offer an inexpensive, simple solution to many less complex data storage and manipulation requirements.

6.3. Examples - Microsoft Access, FoxPro,FileMaker Pro ,Paradox and Lotus Approach are the major players.

6.3.1. BENEFITS a) Inexpensive. b) User-friendly. c) Offer web solutions.

6.4. 2.Server Databases

6.4.1. Offer organizations the ability to manage large amounts of data efficiently and in manner that enables many users to access and update the data simultaneously.

6.4.2. Example - Microsoft SQL Server ,Oracle and IBM DB2 . BENEFITS a) Flexibility - can handle just about any data management problem . Available for multiple operating system . b) Powerful performance - can manage multiple high-speed processors, clustered servers, high bandwidth connectivity and fault tolerant storage technology . c) Scalability - able to garcefully handle a rapidly expanding amount of users and/or data .

7. What is Database?

7.1. Collection of related data that is shared by the various categories of users to meet the requirements of an organization's information

8. What is DBMS?

8.1. A software system that enables to define, create and maintain the database

9. Database Development Process

9.1. 1. Project identification

9.2. 2. Project Initiation and Planning

9.3. 3. Analysis

9.4. 4. Logical Design

9.5. 6. Implementation

9.6. 7. Maintenance

10. What is Data Sharing?

10.1. The ability to share the same data resource with multiple applications or users.

11. Properties of Database

11.1. Completeness

11.2. Integrity

11.3. Flexibility

11.4. Efficiency

11.5. Usability (ease of use)

12. DBMS Usage Requirement

12.1. Store Data Efficiently

12.2. Maintains Data Easily

12.3. Combining The Data

12.4. User Accessible Catalog

12.5. Transaction Support

12.6. Concurrency Control Services

12.7. Recovery Services

13. Data Model

13.1. Hierarchical Database

13.1.1. Develop to manage large amount of data

13.1.2. Assume data relationships are hierarchical

13.1.3. One to many (1:M) relationship

13.1.4. Represented by an upside down tree

13.2. Network Database

13.2.1. Similar to Hierarchical Model. Records linked by pointer.

13.2.2. Composed of sets

13.2.3. Many to Many (M:N) relationships

13.3. Entity Relationship Model

13.3.1. Graphical representation of entities

13.3.2. Based on Entity, Attributes & Relationship

13.3.3. Complements the relational data concept

13.4. Relational Database

13.4.1. Problem with legacy database systems Required excessive effort to maintain. hard to manipulate by end-users

14. Client-Server Architecture of DBMS

14.1. A network architecture in which each computer or process on the network is either a client or a server.

15. Three-Schema Architecture of DBMS

15.1. 1. External Level / Schema

15.1.1. The user's view of the database

15.1.2. Consists of a number of different external views of the DB

15.1.3. Describes part of the DB for particular group of users

15.2. 2. Conceptual Level / Schema

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

15.2.2. What data is stored in the database

15.3. 3. Internal Level / Schema

15.3.1. Physical representation of the DB on the computer

15.3.2. How the data is stored in the database

15.3.3. The relationships among the data