×

### Let's log you in.

or

Don't have a StudySoup account? Create one here!

×

or

by: Alayna Veum

15

0

0

# Intr to Database Systems CS 4400

Alayna Veum

GPA 3.81

Leo Mark

These notes were just uploaded, and will be ready to view shortly.

Either way, we'll remind you when they're ready :)

Get a free preview of these Notes, just enter your email below.

×
Unlock Preview

COURSE
PROF.
Leo Mark
TYPE
Class Notes
PAGES
0
WORDS
KARMA
25 ?

## Popular in ComputerScienence

This 0 page Class Notes was uploaded by Alayna Veum on Monday November 2, 2015. The Class Notes belongs to CS 4400 at Georgia Institute of Technology - Main Campus taught by Leo Mark in Fall. Since its upload, it has received 15 views. For similar materials see /class/234021/cs-4400-georgia-institute-of-technology-main-campus in ComputerScienence at Georgia Institute of Technology - Main Campus.

×

## Reviews for Intr to Database Systems

×

×

### What is Karma?

#### You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!

Date Created: 11/02/15
MAPPING ENTITY RELATIONSHIP SCHEMAS INTO THE RELATIONAL MODEL Steps of the Algorithm Chapter 9 pages 290295 STEP 1 Map Entity Types STEP 2 Map Weak Entity Types draw identifier from parent entity type into weak entity type Map Relationship Types STEPS 3 to 5 11 options for setting up one two or three relations 1N the many side provides a key to the one side MN need to set up a separate relation for the relationship STEP 6 Map multivalued attributes set up a new relation Step 7 Map higher order relationships ternary 4 way etc they become separate relations STEP 8 Mapping of generalization hierarchies and set subset relationships possibility of collapsing into one relation vs as many as the distinct classes MAPPING Extended Entity Relationship EER SCHEMAS INTO THE RELATIONAL MODEL Section 92 Pages 295299 Attrs R attributes of relation R PK R Primary Key of relation R Assume there is a specialization of class C into subclasses 1 Sz 3 Sm That is there are m subclsses ofa superclass C STEP 8 in the mapping mentions the following options Option 8A 1 One relation for C with all attributes and primary key 2 m additional relations One relation per subclass S with its own attributes Attrs 8 plus the PK C The primary key of each subclass relation is the same as PK C Option 8B NO Relation corresponding to the superclass M subclass relations one per subclass Each relation for subclass Si includes PK C Attrs C and the Attrs Si The primary key of each subclass relation is the same as PK C Option 8C Create a single FAT relation containing all attributes from C the key PK C the union of all attributes from all subclasses and one type attribute t that determines to which one or more subclasses an entity belongs This works well for disjoint subclasses However the type attribute can be so designed that it can represent all possible valid combinations of subclasses that might exist Option 8D Create a single FAT relation containing all attributes from C the key PK C the union of all attributes from all 39 39 and mboolean tvpe attributes t1 t2 t3 tm The attributes to which an entity belongs are set to one This can work for Disjoint as well as overlapping subclasses

×

×

### BOOM! Enjoy Your Free Notes!

×

Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'

## Why people love StudySoup

Jim McGreen Ohio University

#### "Knowing I can count on the Elite Notetaker in my class allows me to focus on what the professor is saying instead of just scribbling notes the whole time and falling behind."

Allison Fischer University of Alabama

#### "I signed up to be an Elite Notetaker with 2 of my sorority sisters this semester. We just posted our notes weekly and were each making over \$600 per month. I LOVE StudySoup!"

Jim McGreen Ohio University

Forbes

#### "Their 'Elite Notetakers' are making over \$1,200/month in sales by creating high quality content that helps their classmates in a time of need."

Become an Elite Notetaker and start selling your notes online!
×

### Refund Policy

#### STUDYSOUP CANCELLATION POLICY

All subscriptions to StudySoup are paid in full at the time of subscribing. To change your credit card information or to cancel your subscription, go to "Edit Settings". All credit card information will be available there. If you should decide to cancel your subscription, it will continue to be valid until the next payment period, as all payments for the current period were made in advance. For special circumstances, please email support@studysoup.com

#### STUDYSOUP REFUND POLICY

StudySoup has more than 1 million course-specific study resources to help students study smarter. If you’re having trouble finding what you’re looking for, our customer support team can help you find what you need! Feel free to contact them here: support@studysoup.com

Recurring Subscriptions: If you have canceled your recurring subscription on the day of renewal and have not downloaded any documents, you may request a refund by submitting an email to support@studysoup.com