Entity relationship model, Database Management System

Assignment Help:

Let us first look into some of the important features of ER model.

Entity relationship model is a high-level conceptual data model.
It permits us to define the data involved in a real-world enterprise in terms of objects and their relationships.
It is widely used to develop a first design of a database.
It gives a set of useful concepts that make it convenient for a developer to move from a basic set of information to a detailed and defined description of information that can be easily executed in a database system.
It defines data as a collection of relationships, entities and attributes.

Related Discussions:- Entity relationship model

Describe identifying relationship, Describe identifying relationship? ...

Describe identifying relationship? Identifying relationship: It is relationship among strong entity and a weak entity it is represented through a doubly outlined diamond in C

Prove that a relation which is 4nf must be bcnf, Prove that a relation whic...

Prove that a relation which is 4NF must be BCNF. Ans Let R be in 4NF. Suppose it is not in BCNF. Hence, there exists an FD X→Y in R such that x is not a super key. Although

Transaction, what is cascading rollback

what is cascading rollback

Define the five basic operators of relational algebra, Define the five basi...

Define the five basic operators of relational algebra? Five basic operators of relational algebra are: 1. Union (∪∪∪∪) - Selects tuples which are in either P or Q or in both

Data Warehousing Job Scheduling, 1) Define a job scheduling strategy that w...

1) Define a job scheduling strategy that will meet business requirement of reporting availability by 6am CST for the following cubes? Show the job scheduling dependencies in a pict

Dbms, Retrieve the S&S In-Chapter Database (in Microsoft Access format) fro...

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

What is called as recursive partitioning, What is called as recursive parti...

What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

Provide examples of different types of time and date formats, Provide Examp...

Provide Examples of different types of Time and Date formats. It's most common store dates using a dash (-) as a colon (:)and the delimiter as the time delimiter. The given fo

Design and implement a database system, Safe Banking is a Canberra based cr...

Safe Banking is a Canberra based credit union, which has several branches around Canberra and Queanbeyan. YOU have taken over Safe Banking. YOU need to create a database that organ

Define network dbms, Define Network DBMS The NDBMS is built primarily o...

Define Network DBMS The NDBMS is built primarily on a one-to-many relationship, but where a parent-child representation between the data items cannot be ensured. This may occur

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages