The answer is similar to the functions of DBMS
Data Storage, Retrieval and Update
A User-Accessible Catalog
Transaction Support
Concurrency Control Services
Recovery Services
Authorization Services
Support for Data Communication
Integrity Services
Services to Promote Data Independence
Utility Services
-Afif Omar IIUM 2011/2012 (AAFCO)
Least facilities of
Three types of DBMS (Database Management Systems) include relational DBMS, object-oriented DBMS, and NoSQL DBMS. Relational DBMS organizes data into tables with rows and columns, object-oriented DBMS stores data as objects and classes, and NoSQL DBMS handles unstructured and semi-structured data with flexible schemas.
There are four types of DBMS users,Naive UsersOnline UsersApplication Program UsersDatabase AdministratorNote: The description of above points is currently not available.
1. Following are the different types of dbmsMySQLMicrosoft SQL ServerMS AccessFoxproSAPdBASETibero 6
Types of Attributes in Dbms areKey or non key attributesRequired or optional AttributesSimple or composite AttributesSingle-valued and multi-valued AttributesStored, Coded or derived Attributes
Armstrong rules are complete or sound in dbms by clarifying the types of situations which need to be achieved and done.
DataBase Management System (DBMS)is a software package# it allows data to be effectively stored, retrieved and manipulatedand # the data stored in a DBMS packege can be accessed by multiple users and by multiple application programs like (SQL Server, Oracle, Ms-Access) .Types of DBMS# Hierarachical DBMS (HDBMS)# Network DBMS (NDBMS)# Relational DBMS (RDBMS)# Object Oriented DataBase(OODB)# Distributed DBMS (DDBMS)
yes windows is a multiuser OS
sophisticated end user includes engineers scientist ,business man analyst and others too thoroughly familiarize,themselves with facilities of DBMS so in order to implement their application to meet their complex requirements.
total 6 normal forms
Naive end users need to learn very little about the facilities provided by the DBMSCasual users learn only a few facilities that they may use repeatedlySophisticated users try to learn most of the DBMS facilities in order to achieve their complex requirement.Standalone users typically become very proficient in using a specific software package.
Features of DBMS A typical DBMS has the following features: • Provides a way to structure data as records, tables, or objects • Accepts data input from operators and stores that data for later retrieval • Provides query languages for searching, sorting, reporting, and other "decision support" activities that help users correlate and make sense of collected data • Provides multiuser access to data, along with security features that prevent some users from viewing and/or changing certain types of information • Provides data integrity features that prevent more than one user from accessing and changing the same information simultaneously • Provides a data dictionary (metadata) that describes the structure of the database, related files, and record information