VUSuperior Chat Room

Saturday, 6 June 2015

CS403 Database Management Systems Assignment No 2 Discussion and Solution

14:54    7 comments

Assignment No. 2
Graded
Semester Spring 2015
Database Management Systems – CS403

Total Marks: 20

Due Date: 12th Jun 2015

Objective:
The assignment has been designed to develop your ability to identity the Entities and their Attributes  and to draw the ER Diagram
Instructions:
Please read the following instructions carefully before solving & submitting assignment:

1.      The assignment will not be accepted after due date.
2.      Zero marks will be awarded to the assignment that does not open or the file is corrupt.
3.      The assignment file must be an MS Word (.doc) file format; Assignment will not be accepted in any other format.
4.      Zero marks will be awarded to the assignment if copied (from other student or copied from handouts or internet).
5.      Zero marks will be awarded to the assignment if the Student ID is not mentioned in the assignment file.

For any query about the assignment, contact only at CS403@vu.edu.pk
Do not post queries related to assignment on MDB.

GOOD LUCK
 

Question 1                                                                                                                                         [10 Marks]

Case Study:
A garment brand “Orchid Textile” is using a Retail Management System for management of Sales. It is currently dealing in readymade garments. Mentioned software has following features:
·         It will save Product Information like Product Code, Price, Specification related attributes including garment picture. Sales Manager will be able to Save, Delete, Edit and Search Products.
·         It will record every transaction details like Trans id, Date, Time and other details.
·         Billing invoice will be created against each Transaction. Invoice will have Date, No. of Items, Time, Total Price etc. Sales manager will be able to print invoice
·         Admin of Orchid Textile is able to view different reports of Sales like Daily report, monthly report and yearly report. They are also able to view “Top Ten Items Sold “in specific duration.
·         Sales Manager is also able to view Stock details to manage items according to customer demand. Moreover, customer data will also be saved to inform them about future promotions.


For above mentioned scenario (“Orchid Retail MGT System”), provide
a)      Draw Entity Relationship Diagram.

Question 2                                                                                                                                         [10 Marks]
Draw the ER Diagram to represent the following entity types and the natural relationships among them: VEHICLE, AIR VEHICLE, WATER VEHICLE, OCEAN VESSEL, RIVER RAFT, HELICOPTER, RAIL VEHICLE, BICYCLE, AIRPLANE, ROAD VEHICLE and CAR.

7 comments:

  1. Unknown8 June 2015 at 16:38

    Dear students plz sharer your ideas.....

    ReplyDelete
  2. Unknown8 June 2015 at 17:21

    This comment has been removed by the author.

    ReplyDelete
  3. Unknown8 June 2015 at 17:26

    Entity Relationship Diagram (ERD)

    Also called an entity-relationship (ER) diagram, a graphical representation of entities and their relationships to each other, typically used in computing in regard to the organization of data within databases or information systems. An entity is a piece of data-an object or concept about which data is stored.


    A relationship is how the data is shared between entities. There are ypes of relationships between entities:

    ReplyDelete
  4. Unknown8 June 2015 at 17:28

    . One-to-One
    One instance of an entity (A) is associated with one other instance of another entity (B). For example, in a database of employees, each employee name (A) is associated with only one social security number (B).One-to-Many
    One instance of an entity (A) is associated with zero, one or many instances of another entity (B), but for one instance of entity B there is only one instance of entity A. For example, for a company with all employees working in one building, the building name(A) is associated with many different employees (B), but those employees all share the same singular association with entity

    ReplyDelete
  5. Unknown8 June 2015 at 17:29


    . Many-to-Many
    One instance of an entity (A) is associated with one, zero or many instances of another entity (B), and one instance of entity B is associated with one, zero or many instances of entity A. For example, for a company in which all of its employees work on multiple projects, each instance of an employee (A) is associated with many instances of a project (B), and at the same time, each instance of a project (B) has multiple employees (A) associated with it.

    ReplyDelete
  6. Unknown8 June 2015 at 17:31

    Definition - What does Cardinality mean?
    In the context of databases, cardinality refers to the uniqueness of data values contained in a column. High cardinality means that the column contains a large percentage of totally unique values. Low cardinality means that the column contains a lot of “repeats” in its data range.

    It is not common, but cardinality also sometimes refers to the relationships between tables. Cardinality between tables can be one-to-one, many-to-one, or many-to-many.

    ReplyDelete
  7. Unknown8 June 2015 at 17:37

    Definition - What does Entity-Relationship Diagram (ERD) mean?

    An entity-relationship diagram (ERD) is a data modeling technique that graphically illustrates an information system’s entities and the relationships between those entities. An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure.

    The elements of an ERD are:

    Entities
    Relationships
    Attributes

    Steps involved in creating an ERD include:

    Identifying and defining the entities
    Determining all interactions between the entities
    Analyzing the nature of interactions/determining the cardinality of the relationships
    Creating the ERD

    ReplyDelete

Subscribe to: Post Comments (Atom)