Database - An organized collection of data., Data - The actual information being stored., Metadata - The framework or structure that defines how the data is stored and organized., Requirement analysis - Planning system definition., Database designing - Develop database logical and physical model based on requirements., Implementation - Importing and converting data into a new database and testing it., Data integrity - Databases use rules like primary keys, foreign keys, and unique constraints., Backup and recovery - To protect data and ensure availability in case of system failures., Completeness - Ensures that users can access the data they want., Flexibility - Ensures that a database can evolve to satisfy changing requirements., Efficiency - Ensures that users do not have unduly long response times when accessing data., Usability - Ensures that data can be accessed and manipulated., DBMS - A software system that enables users to efficiently store, manage, and retrieve data in a structured format., Centralized database - A system that keeps the data in one single database at one single location., Distributed database - The data exists in several locations or on multiple servers at the same location., External or View Level - Describes the part of the database that a particular user group is interested in user group., Conceptual / Logical level - Describe the structure and constraints for the whole database for a community of users., Internal / Physical level - Describes the physical storage structure of the database., Desktop database - Examples: Microsoft Access, FoxPro, FileMaker Pro, Paradox, Lotus, Server database - Example: Oracle, Microsoft SQL Server, IBM DB2, End user - Those users who need not be aware of the presence of the database system or any other system supporting their usage., Application Programmers - Those who are responsible for developing application programs or user interface., Database Administrator - The person or group in charge for implementing the database system ,within an organization.,

Topic 1 Concept database

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?