JellyPages.com

Tuesday 23 July 2013

Topic 4


 
From TOPIC 4 lessons, I learnt about Database System. After the week lesson, we did a text on the topic.Database is an organized collection of data or a collection of information arranged and presented in alphabetical order.Database performs the functions as follows to store data,organize data and control data.They are also two components of database namely Data Item and Schema.the types of database include Individual database,Company shared database and Distributed Database.Furthermore, the types of database model are Hierarchical and Network,Rational and   Object-relational database. Actually, Data base management System is a software package for manipulating databases.ed includes Microsoft access,clipper, Filemaker, dBASE, Oracle etc. Also DBMS users are End users,Application users and Data Administrator users. Moreover, modern  database architecture consists of actual database contents,hardware to process and store data, software to manipulate the contents and people to administer the access control and modification of data. The features of a DBMS includes allowing users to create new databases, giving users the ability to query and modify the data using appropriate language and provides information to the decision makers that they need to make important decisions. The components of DBMS includes Field,Record,Table, Key field etc.the Hierarchical model organizes data in a tree structured (upside down tree) whiles the network model is represented by records using links among them.Among the language database uses are DDL- data definition language ,DML-data manipulation language AND SQL- structured query language.

    





This and among other things is what i learnt in topic 4.

No comments:

Post a Comment