In: Computer Science
*** please don't copy and paste and don't use handwriting
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 |
Q1.
Data modelling is the first step in database design. It is the process of creating a data model for the data to be stored in a database. It is considered as the high level. It is also referred as the conceptual design. Data modeling helps in the visual representation of data and enforces business rules, regulatory compliances, and government policies on the data. Data Models ensure consistency in naming conventions, default values, semantics, security while ensuring quality of the data..It describes the data contained in the database, relationship between data items and the constraints on the data.
Conceptual data model
This Data Model defines WHAT the system contains. The purpose is to organize, scope and define business concepts and rules. It is an organized view of database concepts and their relationships.. It does not have the complete data of the database. It is used to create entities, their attributes, and relationships.
·Includes the important entities and the relationships among them.
·No attribute is specified.
·No primary key is specified.
Physical Data model
This Data Model describes HOW the system will be implemented using a specific DBMS system. The purpose is actual implementation of the database.It offers database abstraction and helps generate the schema. The physical data model also helps in visualizing database structure by replicating database column keys, constraints, indexes, triggers and other schemas.
.