logo

ICT701 Introduction of Database Systems

   

Added on  2020-05-08

9 Pages1215 Words36 Views
ICT701 Introduction of Database Systems_1
Table of ContentsDatabase Systems History...................................................................................................................2Introduction of Database Systems......................................................................................................2Entity Relational Modelling................................................................................................................3Relational Schema...............................................................................................................................4Normalization......................................................................................................................................4Introduction to DBMS.........................................................................................................................5Introduction to SQL............................................................................................................................5SQL Data Definition Language..........................................................................................................6SQL Data Manipulation Language....................................................................................................6Advanced SQL.....................................................................................................................................7References............................................................................................................................................81
ICT701 Introduction of Database Systems_2
Database Systems History Data contains the block of information. The systems of the database contains the set ofdatabases. The collection of data is called as database and it manipulates the data in a basicway (CORONEL, 2017). It provides the proper storage and it requires the large amount ofdata. In Ancient History of data base systems, data are not stored on the disk. The databaseprogrammers are defining the physical and logical data structure like I/O modes,access methods and more. It requires the high data redundancy. It very expensive andlimited. In 1968 (file based), data are maintained in a flat file by using the magnetic tapemedium. It does not provide the security and maintenance cost is high.1968-1980 (Non- relational database), It provides the collection of integrated andstructured stored data. The database can be used and shared by application systems. Ituses hierarchical and network data model to store the data. But it is very complex anddifficult to manage. Above 1970 (DBMS), Using the various database methods like object oriented, objectrelational, java, XML, Embedded, IMDM and mobile. It effectively manages the data.2
ICT701 Introduction of Database Systems_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Database and Analytics (Database and Analytics) for the Auto Sale's
|33
|5085
|217

Different Database Models Assignment
|11
|1627
|160

Data Modelling in Database Design
|8
|1351
|159

QAC020C155H Data Modelling And SQL Language
|18
|3233
|178

DBMS Principles and Applications
|8
|1379
|60

Data Modelling and Sql Language - Assignment
|18
|2256
|44