1.what is a Relationship in database management system?
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)
DBMS means Data Base Management System, it is not a programming language.
class in dbms is nothing but a collection of attributes.... class in java is defined as collection of objects....:D
A DBMS delivers economy of scale because it is optimized for processing large amounts of data.
MYSQL - a freely distributed DBMS Microsoft SQL Server - the product of old-brand Microsoft Oracle - a strong and powerful DBMS, which is normally used by larger enterprises nowadays.
Many to many relationship in DBMS is usually a mirror of the real-life relationship between objects that tables represent.
relationship instance is an association of entity instances
There are 4 type of relationship ...one to oneone to manymany to manymany to one
when a relationship is optional then the value of the modality is zero. when mandatory then the modality is one.
converting er diagram to table in dbms?
Relationship is purely a construct of the er data model.Relation is a structure of the relational data model.
•A feature of the entity relationship model that allows a relationship set to participate in another relationship set. • • This is indicated on an ER diagram by drawing a dashed box around the aggregation.
NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS
no, Java is not dbms.. Java is a programming language Dbms is database
dbms
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.
Try reading the book recommended for COIS 5310.