MAPPING E-R TO RELATIONAL (ROLLNO:40,S5CS2)

Leave a comment

MUSICIAN RECORD

 

NOTOWN RECORD HAS DECIDED TO STORE INFORMATION ABOUT MUSICIANS WHO PERFORMED ON ITS ALBUMS IN A DATABASE .EACH MUSICIANS IDENTIFIED BY AN SSN, A NAME, AND AN AGE.EACH MUSICIANS LIVED IN DIFFERENT PLACES. PLACES ARE IDENTIFIED BY AN ADDRESS AND A PH.NO. EACH INSTRUMENTS IS IDENTIFIED BY A NAME AND A KEY .EACH ALBUM HAS A TITLE ,DATE AND A FORMAT.EACH SONG HAS A TITLE AND AN AUTHOR. EACH MUSICIANS PLAYED SEVERAL INSTRUMENTS AND A GIVEN INSTRUMENT PLAYED BY SEVERAL  MUSICIONS .EACH ALBUM HAS NO:OF SONGS ON IT, BUT NO SONG MAY APPEAR ON MORE THAN ONE ALBUM .EACH SONG IS PERFORMED BY ONE OR MORE MUSICIAN S AND A MUSICIAN MAY PERFORM A NO:OF SONGS.EACH ALBUM HAS EXACTLY ONE MUSICIAN  WHO ACTS ITS PRODUCER.A MUSICIAN MAY PRODUCE SEVERAL ALBUMS.

 

 

 

 

 

 

 

 

 

1.0           MAPPING TO RELATIONAL MODEL

 

1.1 ENTITIES

 

 

1.1.1 MUSICIAN

 

SSN

AGE

M_NAME

 

 

 

 

 

 

 

1.1.2 PLACE

 

PH_NO

ADRESS

 

 

 

 

 

1.1.3 ALBUM

 

TITLE

FORMAT

DATE

 

 

 

 

 

                 

 

                 1.1.4  SONG

S_TITLE

AUTHOR

 

 

 

 

 

 

 

 

       1.1.5 INSTRUMENT

NAME

KEY

 

 

 

 

1.2    RELATIONSHIPS

 

 

 

1.2.1  LIVES

SSN

ADDRESS

 

 

 

 

1.2.2  PRODUCE

SSN

TITLE

 

 

 

 

 

1.2.3 APPEAR

TITLE

S_TITLE

   

 

 

 

 

1.2.4 PERFORM

SSN

S_TITLE

 

 

 

 

 

 

1.2.5 PLAY

SSN

NAME

   

 

 

Advertisements

MAPPING ER MODEL TO RELATIONAL MODEL-ORDERS AND PRODUCTS(RNO 51,S5CS2)

Leave a comment

ORDERS AND PRODUCTS

THE ER DIAGRAM FOR ORDERS AND PRODUCTS IS GIVEN BELOW

  • There are many workers working under a project.
  • Each worker is identified by name,workerid and by address.
  • The project may include several departments under which many products are being produced.
  • Several workers may belong to single department and may participate in many projects.
  • Each department is been identified by name,department id and by address.
  • Similarly the projects have got it’s own project id and name.
  • The products too got their own name and product id.
  • The project may include several buyorders that may contain the product details and suppliers who delivers the buy orders.
  • The buyorders are specified by their ordered,orderdate and deliverydate.Same way,suppliers are specified by their name and supplier id.

ER DIAGRAM

RELATIONAL MODEL

 

 

MAPPING ER MODEL TO REALTIONAL MODEL-ENROLLMENT (RNO 46 S5 CS2)

Leave a comment

 

TOPIC : Collect one example for mapping of ER model to relational model.

ENROLLMENT SYSTEM

ER diagram of an enrollment system is given below.

Student enrolls lectures by enrollment. Lecturer leactures subject through lecture.

Student is uniquely identified by NID. It also consists Lastname, Firstname, Address, birthdate.

Lecturer is uniquely identified by lecture_ id . It also consists of lectures lastname , firstname, email id, address.

Lecture is uniquely identified by cc#. It also consists of subject, time, date, lecture name.

Enrollment  is uniquely identified by student_num. It also consist of date of enrollment , coursename, cc#.

Subject_is uniquely identified by subject_code. It also consists of subject_unit, subject_udsc.

ER DIAGRAM

RELATIONAL MODEL

 

 

MAPPING E-R TO RELATIONAL MODEL (ROLL NO:35 ,S5 CS2)

Leave a comment

E-R diagram of library management system is given:

Books are published by publisher and are borrowed by members of the library .

Books are managed by staffs of the library and are categorized on separate sections .

Each book is uniquely identified by book-id and publisher is identified by pub-id.

Also each member has his /her own unique member-id (M-id).

Staffs are identified by their staff-id and also each section has unique section code.

Each book hasauthor, title and price also.

Each publisher has name and address .All staffs has name ,post and salary .

Each section of the library has number and name. Each member has address, name, membership type  and date of membership.

Books are borrowed on the basis of return date, due date and date of issue.

E-R DIAGRAM

Mapping into relational model

Entities:

Publisher

Pub_id Name Address

Member

M_id M_date M_type mname maddr

Books

Book_id Author Title Price

 

Section

    S-code S-name S-no

Staff

S-id S-name Post Salary

Relationships

Published by:

Book_id Pub_id

Borrow by:

Duedate returndate issuedate Book-id M_id

 

 

Managed by:

S_id Book_id

Categorized by:

S_code Book_id

 

MAPPING ER MODEL TO RELATIONAL MODEL-SUPPLIES CONTRACT SYSTEM (RNO-44 S5 CS2)

2 Comments

TOPIC: Collect one example for mapping of ER model to Relational model

SUPPLIES CONTRACT SYSTEM

ER diagram of a supplies contract system is given below. Suppliers contract with contracters. Contracters supplied orders needed for the projects. Items are made according to the orders.

  • Supplier is uniquely identified by Sno#. It also consist Name & Address. Name consists of Fname & Lame. Address consists of State,City & Street.
  • Contracter is uniquely identified by Contract ID#. It also consists of Name & Phone.
  • Items are uniquely identified by Item No#. It also consists of Item_discription. Item_discription consist of Item size & Quantity.
  • Orders are uniquely identified by Order No. It also consists of Date Completed & Date Required.
  • Projects are uniquely identified by Project No#. It also consist Project Date.

ER DIAGRAM

sumi5

MAPPING ER DIAGRAM FOR BOOK STOCK(RNO:43,S5CS2)

Leave a comment

 

 

TOPIC : BOOK STOCK MANAGEMENT SYSTEM

 

 

Question:

 

ER Diagram of a BOOK STOCK MANAGEMENT SYSTEM is given below.Books are written by authors and published by the publishers.Shopping basket contains books.Ware house stocks books.Customer takes book from shopping basket.

 

 

Author is uniquely identified by Name.It also consist of address,URL

Book is uniquely identified by ISBN.It also consist of year,title,price

Publisher is uniquely identified by Name.It also consist of Address,Phone,URL

Customer is uniquely identified by email.It also consist of Name,Address,phone

Shopping basket is uniquely identified by basketID

Ware house is uniquely identified by code.It also consist of Address,phone.

ER DIAGRAM

RELATIONAL MODEL

 

 

MAPPING ER DIAGRAM TO RELATIONAL MODEL(RESTAURANT SYSTEM)- ROLL NO:38

Leave a comment

TOPIC: Collect one example for mapping from ER Model to

              Relationship Model

RESTAURANT SYSTEM:The entities are represented by Chef,Meal,Ingredients,Customer and Supplier.

1.A chef is represented by a chef id and chef name and also by his salary

2.Meal prepared by chef is identified by its name and price.

3.Ingredients of meal are identified by its name and description

4.Every customer has a name,id,phone no: and address.

5.Supplier is identified by his name,id and city.

Corresponding ER diagram:

Image

ENTITIES:

CHEF

Chef_id

Chef_name

Chef_salary

     

MEAL

Meal_name

Meal_price

   

INGREDIENTS

Ing_name

description

   

CUSTOMER

Cust_id

Cust_name

Cust_address

Cust_phoneno

       

SUPPLIER

S_id

S_name

S_city

     

RELATIONSHIPS:

Prepares

qty

time

   

Consists of

qty

price

   

Orders

date

time

   

Attends

time

tableno

   

Older Entries