Explain the steps for reduction of e-r model, Database Management System

Assignment Help:

Explain the steps for reduction of E-R model into relational model.

Ans:(a) Entity set in E-R model will be considered as table name in relational Model.

(b) Attributes of entity set in E-R diagram will be referred as fields or column name of table.

Related Discussions:- Explain the steps for reduction of e-r model

Objectives-file organisation in dbms, Objectives After reading this un...

Objectives After reading this unit you should be able to: Explain storage of databases on hard disks; Discuss the execution of various file Organisation techniques;

Identification of concurrency, Identification of concurrency Identifica...

Identification of concurrency Identification of concurrency: Dynamic model identifies concurrency. Two objects are said to be parallel (concurrent) if they can receive events a

Explain what is aggregation, Explain what is Aggregation ? Aggregation...

Explain what is Aggregation ? Aggregation: This is used whenever we intend to show a relationship between an entity and the relationship. There is no provision for this in th

Explain concept of inheritance with support of example, Explain concept of ...

Explain concept of inheritance with support of suitable example. Inheritance Inheritance is one of milestone of object-oriented programming language as it allows a creati

Define hash files organization, Define Hash files organization a. Hashi...

Define Hash files organization a. Hashing includes computing the address of a data item by calculating a function on the search key value. b. A hash function h is a functi

Differences among the candidate keys and the primary key, Discuss the diffe...

Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer? A candidate key is one that can be used as primary ke

IT Assignmnet, i need help for assignment ..

i need help for assignment ..

ERD, A student entity type has the following attributes,name..

A student entity type has the following attributes,name..

Give detail description on transactions, Give detail description on Transac...

Give detail description on Transactions. - Using transactions we can group all SQL commands into a single unit. - Transaction begins with some task and finishes only when a

What are the purpose for having variable length records, What are the purpo...

What are the purpose for having variable length records? What kinds of separator characters are required for each? Variable-Length Records - Variable-length records are thos

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages