Object-based models - data models, Database Management System

Assignment Help:

Object-based Models: Use objects as key data representation components.

Examples:-

Entity-Relationship Model: It is a collection of real world objects known as entities and their relationships. It is largely represented in graphical form using E-R diagrams. This is very useful in Database design.
Object-Oriented Model: Tells the database as a collection of objects that haves both data members/values and operations that are allowed on the data. The constraints and interrelationships are executed through links, objects and message passing mechanisms. Object-Models are effective for databases where data interrelationships are difficult, for example, Computer Assisted Design based components.

Related Discussions:- Object-based models - data models

What count function return in sql, What Count function return in SQL? C...

What Count function return in SQL? Count function within SQL returns the number of values. (Count function counts all the not null values in the exact column. If we need to cou

Having clause with sub queries, Having Clause with sub queries: First we h...

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

Explain the dependency relationship of object oriented, Explain the depende...

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

Describe dynamic model, Describe Dynamic Model. The dynamic model speci...

Describe Dynamic Model. The dynamic model specifies allowable sequences of changes to the objects from an object model. It contains event trace diagrams describing scenarios. A

What is a homogeneous distributed database, What is a homogeneous distribut...

What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

What are the concurrency issues, Concurrency issues Data integrity...

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Er-diagram, courier company er-diagram

courier company er-diagram

What is stored procedure, What is Stored Procedure? A stored procedure ...

What is Stored Procedure? A stored procedure is a named group of SQL statements that have been previously formed and kept in the server database. Stored procedures accept input

Discuss difference between drop table r and delete from r, Discuss The diff...

Discuss The difference between drop table R and delete from R. DROP TABLE command deletes all the records with the table definition. This command will automatically committed

Define variable-length records arise in database, What are the ways in whic...

What are the ways in which the variable-length records arise in database systems? Storage of many record types in a file. Record types that permit variable lengths for one o

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages