.

Friday, March 8, 2019

Data Base Management

Data BaseIt is the collection of cultivation regarding an individual, group of people working together, a department in an brass or an organization.1Types of Data BaseDepending on the number of people, database is classified into 4 types.1. Personal Database It is for an individual or single user.2. Workgroup Database If the employees number is in amidst 10-15 people.3. Department Database It is for 15-50 employees.4. Enterprise Database If the no of employees is more than 50 people.Database ModelA Database Model is a visual plan for building a database. It focuses on representing the data as the user actually sees it, bridging between the concepts that make up real-world events.Raw DataThis is the military operation in which, raw data is collected and is converted into information which is the filtered raw data. Then, the information is described in the proper form called as the meta data which is the data description and this data is collected to form a database. So, database is the organized collection of related data.Data DefinitionOne in truth outstanding role of a database anxiety system is to maintain the data definitions for severally table and columns in the database. Each piece of data must be assigned a name, a data type (e.g. date, alphanumeric, numeric) and a compulsory/optional status.2ArchitectureThere are three levels in the aspiration computer architecture of the database.1. User design It can be used by any(prenominal) no of users. It is operational database.2. Logical design It is the logical structure of database. It is regardless of the hardware or other things. It concerns only with logical structure.3. Physical design It concerns with the hardware requirements of the data base. It is not related to either the user or the logical structure.There are different types of DBMS products relational, network and hierarchical etc still the about commonly used database caution system by most of the commercial organization is the Rel ational Database Management Systems (RDBMS).Data Structures Data structures (fields, records, files and objects) optimized to deal with very large amounts of data stored on a permanent data shop device (which implies relatively slow access compared to volatile main memory).Database swanThe database project would be developed in different stages like1. Initiation which includes the forum and defining the data and their types.2. Planning of the requirement and how to generate the ask outputs.3. convention which includes two parts1. Physical stick out Gathering the hardware requirements.2. Logical Design Designing the logical structure of database.4. Implementation in which we provide the needed data to the database.5. Maintenance It includes the proper co-ordination of the input and the requirement.MaintenanceThe database project will be maintained using a repository server which provides all the required data and logical functions that are used in the project.DeployIt is a pro cess of delivery of the output obtained in the project to the client who sends the feed spine depending on the report he receives.ReferencesEncyclopediaData base management systems, Retrieved 1206, 17 December 2007.https//en.wikipedia.org/wiki/DatabaseBookRobert V.Henry, Data Base Management System.Internet blog1. Information Technology Toolbox, Inc. (1998-2007)2. Database Management systems.1 EncyclopediaData base management systems, Retrieved 1206, 17 December 2007.https//en.wikipedia.org/wiki/Database 2 Information Technology Toolbox, Inc. (1998-2007)http//database.ittoolbox.com/

No comments:

Post a Comment