Question

**I need rewrite the answer with unique word ... thank you  

Q1:

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

Answer :

An extranet can increase the value of your organization by helping you convey and work together more viably with customers, clients, and accomplices. Especially in the business-to-business market, an extranet can give your organization an edge over the opposition and set aside you cash by smoothing out conventional business capacities and reducing overhead expenses.

Extranets accomplish a similar work as an intranet, however it additionally takes into account correspondence on the planet. An extranet permits client, sellers and providers to get to the data through the PC framework. The organizations use extranets to get strategic like:

1. Expanded efficiency: As you mechanize measures that were generally done physically, bottlenecks will vanish and your organization's profitability will increment. Basic data won't lose all sense of direction via the post office or covered in an email inbox, and occupied representatives won't miss or overlook key functions. An extranet can, for instance, screen business exercises and trigger explicit activities, for example, naturally submitting a request with a provider when your stock dips under a specific level.

2. More limited chance to advertise: In the event that your business isn't moving at "Web speed," you hazard being abandoned. An extranet can assist you with getting your items to showcase all the more rapidly by making proposition and determinations accessible to providers, and surrendering customers and accomplices to-date data on current undertakings.

3. Construct client loyalty : Extranets make business simpler for your clients. The more you make convenient, precise data accessible to your clients, the more probable it is you'll keep their business

4.Reduced stock : One of the signs of a business-to-business extranet is its effect on flexibly chain the board. By connecting your stock framework straightforwardly to a provider, you can handle arranges when the framework realizes you need them, in this manner lessening the stock you keep available and making the acquirement cycle more proficient.

Q2:

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.

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.

• Specification all tables and columns.
• Foreign keys are used to identify relationships between tables.
• Denormalization may occur based on user requirements.
• Physical considerations may cause the physical data model to be quite different from the logical data model.

Answer 1

Ans 1) To explain Strategic Competitive Benefits of companies using extranets, one must understand what extranet is all about and why not intranets?

Lets first compare Intranets and Extranets: -

Both intranets and extranets are secure versions of the Internet that let you share company information. Intranets let employees quickly and easily access all kinds of information, which is published on Web servers, simply by using a browser and a point and click of a mouse. While, Extranets let you do the same with suppliers or customers, securely sharing selected information by linking two companies' intranets together or by providing special applications for business partners.

An extranet can add value to your company by helping you communicate and collaborate more effectively with customers, parteners, and clients.

Now lets have a look at some of the strategic competitive benefits in a company using extranets: -

1. Accurate and timely information: -  you can instantly change, edit, and update sensitive information such as price lists or inventory information.
2. Increased productivity: - As you automate processes that were traditionally done manually, bottlenecks will disappear and your company’s productivity will increase. Critical information won’t get lost in the mail or buried in an e-mail inbox, and busy employees won’t miss or forget key events.
3. Shorter time to market.: - An extranet can help you get your products to market more quickly by making proposals and specifications available to suppliers, and giving clients and partners up-to-date information on current projects.
4. Build customer loyalty: - The more you make timely, accurate information available to your customers, the more likely it is you’ll keep their business.
5. Reduced inventory: - By linking your inventory system directly to a supplier, you can process orders as soon as the system knows you need them.

Ans 2) Data modelling is the first step in the process of database design. It is considered to be a high-level and abstract design phase, also referred to as conceptual design. The main aim is to explain: -

1. The data contained in the database (e.g., entities: students, subjects)
2. The constraints on data (e.g., student number has exactly eight digits).
3. The relationships between data items (e.g., students are supervised by lecturers).

Conceptual data model

Conceptual models the business objects that should exist in a system and the relationships between them.A conceptual model is developed to present an overall picture of the system by recognizing the business objects involved. It defines what entities exist, NOT which tables.

For example, ‘many to many’ tables may exist in a logical or physical data model but they are just shown as a relationship with no cardinality under the conceptual data model.

Physical data model

Physical model represents the actual design blueprint of a relational database. A physical data model elaborates on the logical data model by assigning each column with type, length, nullable, etc.

Since a physical model represents how data should be structured and related in a specific DBMS it is important to consider the convention and restriction of the actual database system in which the database will be created. Make sure the column types are supported by the DBMS and reserved words are not used in naming entities and columns.