Are you over 18 and want to see adult content?
More Annotations
A complete backup of hindiworksheet.blogspot.com
Are you over 18 and want to see adult content?
A complete backup of cooperenka.com.co
Are you over 18 and want to see adult content?
A complete backup of austinmaidservice.com
Are you over 18 and want to see adult content?
A complete backup of lasiverkkokauppa.fi
Are you over 18 and want to see adult content?
Favourite Annotations
A complete backup of downloadgbwhatsappapk.com
Are you over 18 and want to see adult content?
A complete backup of skoda-club.org.ua
Are you over 18 and want to see adult content?
A complete backup of placement-berlin.de
Are you over 18 and want to see adult content?
A complete backup of german-mine.life
Are you over 18 and want to see adult content?
A complete backup of super-spanisch.de
Are you over 18 and want to see adult content?
A complete backup of richbitchcooking.com
Are you over 18 and want to see adult content?
A complete backup of surgerymiracles.com
Are you over 18 and want to see adult content?
A complete backup of drexel0.sharepoint.com
Are you over 18 and want to see adult content?
Text
LBS KUTTIPEDIA
* Home
* About
* QUESTION PAPERS
EXTENDED E-R DIAGRAM FOR SPORTS CLUB(S5CS2 ROLL NO 34)September 26, 2013
ssaranya324 Extended ER diagramsLeave a comment
EXTENDED E-R DIAGRAM FOR SPORTS CLUB (S5 CS2 ROLL NO 34) TOPIC: collect one E-R diagram with extended ER features andexplanations
QUESTION:
Create an E-R diagram of a sports club conducted by school. a) A school is decided to setup a sports club outside the school. b) Sports club can be categorized based on the type: cricket club,football club.
c) A student can join in any one of the sports club. d) Each sports club has a coach who trains the students. e) Each student can be identified using id no. f) Salary, experience, name of the coach can also be included.ANSWER:
STEP 3: IDENTIFY THE KEY ATTRIBUTES Sports club: clubname
Student: Sid
Cricket: Cplayerid
Football: Fplayerid
Coach: Cid
STEP4: IDENTIFY OTHER RELEVANT ATTRIBUTESports:
Location
Contactno
Student:
Sname
Address
Phone
Cricket:
Cname
Cclass
Football:
Fname
Fclass
Coach:
Name
Experience
Caddress
Salary
More
ROLL NO.18 AN EER DIAGRAM FOR A SMALL PRIVATE AIRPORT DATABASE.September 25, 2013
darshinipriya Extended ER diagramsLeave a comment
Figure 1 shows an example of an EER diagram for a small private airport database that is used to keep track of airplanes, their owners, airport employees and pilots. From the requirements for this database, the following information was collected. Each airplane has a registration number , is of a particular plane type , and is stored in a particular hangar . Each plane type has a model number [Model}, a capacity , and a location . The database also keeps track of the owners of each plane and the employees who have maintained the plane . Each relationship instance in OWNS relates an airplane to an owner and includes the purchase data . Each relationship instance in MAINTAIN relates an employee to a service record . Each plane undergoes service many times; hence, it is related by to a number of service records. A service record includes as attributes the date of maintenance , the number of hours spent on the work , and the type of work done . We use a weak entity type to represent airplane service, because the airplane registration number is used to identify a serVice record. An owner is either a person or a corporation. Hence, we use a union category that is a subset of the union of corporation and person entity types. Both pilots and employees are subclasses of PERSON. Each pilot has specific attributes license number and restrictions; each employee has specific attributes salary and shift worked . All person entities in the database have data kept on their social security number , name , address, and telephone number [Phone}.For corporation entities, the data kept includes name [Name}, address, and telephone number [Phone}. The database also keeps track of the types of planes each pilot is authorized to fly and the types of planes each employee can do maintenance work on . EXTENDED ER DIAGRAM(ART MUSEUM) ROLL NO: 32, S5CS2September 25, 2013
samaha1 Extended ER diagramsLeave a comment
ART MUSEUM
Design a database to keep track of information for an art museum.Assume that the following requirements were collected: The museum has a collection of art_objects.Each art_object has a unique id,an artist(if known),a year(when it was created,if known) anda title.
Art_objects are categorized based on their types.There are two main types:painting and sculpture. Painting has a paint type and style. Sculpture has a material from which it was created,height and weight. Different exhibitions occur each having a name,start date and end date.Exhibitons are related to all the art objects that were on display on display during the exhibition. Draw an EER schema diagram for this application.ANSWER:
Step 1:
Entities:
1.art_object
2.artist
3.painting
4.sculpture
5.exhibition
Key attributes:
1)Art_object: idno
2)Painting: painttype 3)Sculpture: material4)Artist:Aname
5)Exhibition:Ename
Other attributes:
1)Art_object: year,title.2)Painting: style.
3)Sculpture: height,weight. 4)Artist: country,mainstyle 5)Exhibition: sdate,edate.RELATIONSHIPS:
ER DIAGRAM:
EXTENDED ER-DIAGRAM (INSURANCE COMPANY) ROLL NO; 29 S5CS2September 25, 2013
sabreenakp Extended ER diagramsLeave a comment
INSURANCE COMPANY
Design a database for insurance company.Asume that following are the requirements that were collected: An insurance company has different policies.Policies have pno,term_price and coverage. Policies are categorized based on their types.There are two types:Auto_policy and Home_policy. Policies for vehicles come under Auto policy.Auto_policy has pno,vehicle type and issue date. Policies for house come under home policy.Home_policy has pno,issue date and term_price. Customers take policies policy through policy agent.A customer can take only one policy .ANSWER
ENTITIES:
1)Policy
2)Auto_policy
3)Home_policy
4)Vehicle
5)House
6)Customer
KEY ATTRIBUTES:
1)Policy: pno
2)Auto_policy: polno 3)Home_policy:policyno4)House:hno
5)Vehicle: vehicle_no6)Customer: custid
OTHER ATTRIBUTES:
1)Policy:price,coverage. 2)Auto_policy:type,issue_date 3)Home_policy:date,term_price4)House:name
5)Vehicle:model
6)Customer:address,phnoRELATIONSHIPS:
ER DIAGRAM:
MAPPING E-R TO RELATIONAL (ROLLNO:40,S5CS2)September 25, 2013
sreedevinew007 Mapping ER toRealtional
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 SEVERALALBUMS._
_ _
1.0 MAPPING TO RELATIONAL MODEL1.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 RELATIONSHIPS1.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
SIMPLE ER DIAGRAM ON AIRLINE DATABASE(S5 CS2 ROLL NO 16)September 25, 2013
preethz2408 Simple ER diagramsLeave a comment
TOPIC: IMPLEMENTATION OF A SIMPLE ER DIAGRAM.QUESTION:
Design an ER diagram for an airline reservation system. * The database represents each Airport, keeping its unique Airport Code, the Airport Name, and the City and State in which the Airport islocated.
* Each airline flight has a unique number, the Airline for the flight, and the Weekdays on which the flight is scheduled. * A flight is composed of one or more flight legs. Each flight leg has a leg number, Departure airport and Scheduled Departure Time, and an arrival airport and Scheduled Arrival Time. * A leg instance is an instance of a flight leg on a specific date. The Number of available seats and the airplane used in the leg instance are also kept. * The customer reservations on each leg instance include the customer name, phone, and seat numbers for each reservation. * Information on Airplanes and Airplane Types are also kept. For each Airplane type the Type Name, manufacturing company, and maximum number of seats are kept. The Airports in which planes of this type Can Land are kept in the database. For each Airplane, the Airplane Id, Total number of seats, and Type are kept.SOLUTION:
* Entities
* Airport
* Airplane Type
* Airplane
* Flight leg
* Flight
* Leg Instance
* Relationships
* It is a 1-N relationship between the airport and flight leg based on departure airport. * It is a 1-N relationship between Airport and Flight Leg based onarrival airport.
* It is a M-N relationship between Airport and Airplane Type basedon landing.
* It is a 1-N relationship between Airplane Type and Airplane basedon the type.
* It is a 1-N relationship between Airplane and Leg instance basedon the assignment.
* It is a 1-N relationship between Leg instance and Seat based onreservation.
* It is an N-1 relationship between Flight Leg and Flight based onthe legs.
* It is a 1-N relationship between Flight and Fare based on thefares.
* It is a 1-N relation between Airport and Leg instance based on towhere it departs.
* It is a 1-N relationship between Airport and Leg instance based onthe arrival.
* It is a 1-N relationship between Flight Leg and Leg instance basedon instance.
* Key attributes
* Airport- Airport code * Airplane Type- TypeName * Airplane- AirplaneId * Leg Instance- Date* Seat- SeatNo
* Fare- Code
* Flight Leg- LegNo
* Flight- Number
*
Other relevant attributes * Airport- Name, City, State * Airplane Type- Max-seats, Company * Airplane- Total-no-of-seats * Leg Instance- No-of-avail seats * Fare- Amount, Restrictions * Flight- Weekdays, Airline* ER Diagram
*
MAPPING ER MODEL TO RELATIONAL MODEL-ORDERS AND PRODUCTS(RNO 51,S5CS2)September 25, 2013
thusharanature Mapping ER toRealtional
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 byaddress.
* 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 andsupplier id.
ER DIAGRAM
RELATIONAL MODEL
Older Entries
RECENT POSTS
* extended E-R diagram for sports club(s5cs2 roll no 34) * Roll No.18 An EER Diagram for a small private airport database. * EXTENDED ER DIAGRAM(Art Museum) Roll No: 32, S5CS2 * EXTENDED ER-DIAGRAM (Insurance Company) Roll No; 29 S5CS2 * MAPPING E-R TO RELATIONAL (ROLLNO:40,S5CS2)ARCHIVES
* September 2013
* July 2013
* April 2013
* March 2013
* February 2013
CATEGORIES
* Extended ER diagrams * Inspiring Short Stories * Latest technologies * Mapping ER to Realtional * Our Group Members Blog * OUR Inspiring Scientists* Question Papers
* Simple ER diagrams* Uncategorized
META
* Register
* Log in
* Entries feed
* Comments feed
* WordPress.com
Blog at WordPress.com.LBS kuttipedia
Create a free website or blog at WordPress.com.Post to
Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use. To find out more, including how to control cookies, see here: CookiePolicy
* Follow
*
* LBS kuttipedia
* Customize
* Follow
* Sign up
* Log in
* Report this content * Manage subscriptions* Collapse this bar
Details
Copyright © 2024 ArchiveBay.com. All rights reserved. Terms of Use | Privacy Policy | DMCA | 2021 | Feedback | Advertising | RSS 2.0