130 likes | 340 Views
Database management systems. By Stephanie Wood And Nedziba Bubregovic. What exactly is a database management system?. A very large collection of data A database management system is a software package designed to store and manage data Models real-world Entities (Ex: Students, courses)
E N D
Database managementsystems By Stephanie Wood And Nedziba Bubregovic
What exactly is a databasemanagement system? • A very large collection of data • A database management system is a software package designed to store and manage data • Models real-world • Entities (Ex: Students, courses) • Relationships (Ex: Joe Smith is taking CSIS)
Why use a database management system? • Provides end users with quick, easy access to information stored in a database • Data integrity and security • Efficiently organizes data • Manages effectively • Logical and physical data independence
Database Models • 5 functional database structures are the hierarchal, network, relational, object-oriented, and multidimensional • The relational model is widely used today
Database development is in the hands of….. • Database administrator • Designs • Improves integrity and security • Uses data definition language • Data availability, crash recovery • Usually well paid
? How is a DBMS different thana database?
Typical Examples of DBMS • Oracle • DB2 • Microsoft Access • Firebird • FileMaker • Microsoft SQL Server
Company that sells DBMS • Oracle is one of the major companies developing and selling DBMS. • Oracle was founded in California, 1977. • Price rage is …
Oracle is known as a Relational Database Management System (RDBMS) ORACLE