CS409 Assignment 2 Solution and Discussion

[zaasmi]

Re: CS409 Assignment 2 Solution and Discussion

Assignment No. 02

SEMESTER SPRING 2020
CS409- Introduction to Database Administration
Total Marks: 20
Due Date: 23/06/2020

The objectives of this assignment are,

• To give students the idea of the most commonly used RDBMS for designing logical data model.
• To learn how to convert entities and attributes into tables and columns.
• To make relationship between them.

Lectures Covered: This assignment covers topics discussed in Week # 04-05

Task Description:

Scenario:

CarMatch is a franchising company that is being set up to promote car sharing. CarMatch seeks to promote car sharing and to provide a service to potential car sharers by matching up people who both live and work near one another. . People who join up will pay a small membership fee, which will be refunded if the local CarMatch franchise is unable to match them up with one or more other people who require or are offering transport. The CarMatch franchise will draw up model agreements between the participants, to prevent the money that changes hands to cover fuel costs being treated as taxable income, and advice on the insurance implications of car sharing. It will act as an agent for companies that sell insurance policies that specifically cover car sharing.

Consider the given below the ERD of a scenario given here. You are required to convert it into its logical model.

For any query about the assignment, contact at CS409@vu.edu.pk

GOOD LUCK

[zaasmi]

How do you convert logical data model to physical?

[Doll Doll]

@zaasmi said in CS409 Assignment 2 Solution and Discussion:

How do you convert logical data model to physical?

The logical data model defines the structure of the data elements and set the relationships between them. The physical Data Model describes the database-specific implementation of the data model.

[zaasmi]

What is the purpose of a logical data model?

[zareen]

@zaasmi said in CS409 Assignment 2 Solution and Discussion:

What is the purpose of a logical data model?

Logical data models add further information to the conceptual model elements. It defines the structure of the data elements and set the relationships between them. The advantage of the Logical data model is to provide a foundation to form the base for the Physical model.

[zaasmi]

@zaasmi said in CS409 Assignment 2 Solution and Discussion:

Consider the given below the ERD of a scenario given here. You are required to convert it into its logical model.

Logical ERD is a detailed version of a Conceptual ERD. A logical ER model is developed to enrich a conceptual model by defining explicitly the columns in each entity and introducing operational and transactional entities.

[zaasmi]

@zaasmi said in CS409 Assignment 2 Solution and Discussion:

Logical ERD is a detailed version of a Conceptual ERD. A logical ER model is developed to enrich a conceptual model by defining explicitly the columns in each entity and introducing operational and transactional entities.

A logical data model describes the data in as much detail as possible, without regard to how they will be physical implemented in the database. Features of a logical data model include:

Includes all entities and relationships among them.
All attributes for each entity are specified.
The primary key for each entity is specified.
Foreign keys (keys identifying the relationship between different entities) are specified.
Normalization occurs at this level.
The steps for designing the logical data model are as follows:

Specify primary keys for all entities.
Find the relationships between different entities.
Find all attributes for each entity.
Resolve many-to-many relationships.
Normalization.
The figure below is an example of a logical data model.

[zareen]

@zaasmi said in CS409 Assignment 2 Solution and Discussion:

Consider the given below the ERD of a scenario given here. You are required to convert it into its logical model.

Logical data model example

[zareen]

@zareen said in CS409 Assignment 2 Solution and Discussion:

Consider the given below the ERD