Get Quote
whatsapp
sample banner

215 Downloads

The relational model was said to be an implementation ready model. In contrast, the ER model is limited to conceptual modeling. Clarify what the preceding means. For each of the following entity set pairs, deduce and succinctly state the business rules that govern them. Be prepared to justify your answer as you deem necessary [your answer is correct once properly justified].

Comparison of relational and ER model

In case of ER (Entity-relationship) model, before information storage, database structure is defined. Methods and diagram notations for database design are provided by ER model. In case of relational model, mathematical definition is provided. This definition is precise. Here, information is stored in tabular format (relational). Foreign key is used for interrelation purpose. A computational mechanism is provided by relational algebra that is formal. Different operations i.e. aggregation, select, join, project etc. can be performed on database. Every row, in table is related with point, instance or observation. Every column is associated with a feature or an attribute. In a data mining project when relational queries are performed - many temporary views or tables are created. Views are dynamic while tables are static. In case of ER model, they are not considered as entity. If queries are disconnected, then software maintenance, database management and software development become difficult. A relational database is shown as D (T, I). Here, T = {S1 …. Sn. Integrity constraint is referred as I. A1, A2 show column in table. Referential integrity and entity are main constraints. Validity of foreign key and primary key is important. From Entity Integrity perspective, primary key should be there for each relation. In case of referential integrity, form Si (K)  Sj (K) is asserted. Considering recent ER tools, each relationship is having a foreign key. Each entity is related to a table. If there is 1:1 relationship, then it can be merged and there may be formation of one entity. In case of M:N relationship that is many to many, then a linking entity is formed. Both entities are connected. In a normalized database one to many to one relationship exists. For conversion of ER conceptual model in to a model that is Physical, The ER is mapped to relational model (Ordonez, 2014).

Semantic Data models

There is a need to have better real world understanding. It can be included in database. Database management systems become more sophisticated. Semantic data models help to get structure and meaning of data. This is done using abstraction i.e. association, inclusion and aggregation. Application’s and user’s view concerning information are presented and modeled by conceptual design. Specifications concerning information processing or information utilization are supported by Entity relationship. Design of logical data model is converted to physical design. It is done as per the specifications of DBMS and hardware. Each entity is converted into different entity relation during transformation of entity relationship model to relational model.

Level of Abstraction

Abstraction has three levels Architecture i.e. internal, external and conceptual. User’s view concerning database is referred as external level abstraction. As per the requirement, different database components are accessed by different users. External model is having external schema, which is its own. Here, data environment is viewed by end user. Internal model is a conceptual model. It is related to specific DBMS i.e. relational, hierarchical and network. It is a software dependent model. For network and hierarchical models, development of internal model is very important. Global view of data is shown by conceptual model. Here, data representation is enterprise wide. Top level managers see this. Entity relationship model is used at a very large scale. It is a conceptual model. Conceptual schema is formed on the basis of this model (Storey, 1993). It is not dependent on hardware or software. So, there is hardware independence as well as software independence.

Download Full Sample Here
HIRE EXPERT
Email ID *
Subject
Pages
Deadline