Question

I need new and unique answers, please. (Use your own words, don't copy and paste),

Please Use your keyboard (Don't use handwriting) Thank you..

IT101

Q1:Data Modelling is the primary step in the process of database design. Compare and contrast Conceptual data model versus Physical data model. Illustrates with help of example to list down data (entities), relationship among data and constraints on data.

Q2:What strategic competitive benefits do you see in a company’s use of extranets?

Q3:Explain how Internet technologies are involved in developing a process in one of the functions of the business? Give an example and evaluate its business value.

Q4:

What are the basic differences between HRM, Intranet and Internet in terms of Domain and Network Communication Scope?

	HRM Intranet	HRM Internet
Domain
Network Communication Scope

Answer 1

Ans 1) The process of creating a data model for the data that is to be stored in a database is called the data modelling.The data modeling can further be divided into 3 major types -

a)Conceptual data model

b)Logical data model

c)Physical Data model

The conceptual data model is the first stage of the database design or the top level of the data model.The conceptual data model is more helpful to find out the entities and the relationship between them.The example for a conceptual data model can be to select what entities exist in the database design.A cardinality is not shown in a conceptual data model. The conceptual data model uses the generalization.

The logical data model acts as the bridge between the physical and logical data model.

The physical data model is actually the representation which illustrates the actual data storage in the physical database.The physical data model presents the database specific implementation of the physical data.The actual storage of the data in the database is presented in the physical data model. The entities and relationship between them is represented as well as the cardinality of the relations is also shown in the physical data model of the database design process.The physical data model can be thought of as the last or final step in the design of the data model.

An example to list down data (entities), relationship among data and constraints on data :-

Consider an example of database design in which the book and its id and its authors and publisher details is to be stored. In the conceptual data model the entities involved in the database design will be first identified and will be modeled at this stage of conceptual database design. The database design will be further designed using the logical data model to bridge between the conceptual and physical data model. Now the physical data model is designed to get the idea or visualization of the actual database entities and their relationship. The cardinality between the tables or relations is also decides at this level of modeling. The constraints like the author id in the author table should also be updated when a book of that author is updated in the book table is also implemented using the primary and foreign key constraints on the data base tables.