New User Special Price Expires in

Let's log you in.

Sign in with Facebook


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


Create a StudySoup account

Be part of our community, it's free to join!

Sign up with Facebook


Create your account
By creating an account you agree to StudySoup's terms and conditions and privacy policy

Already have a StudySoup account? Login here

Database Fundamentals

by: Herminio Grimes

Database Fundamentals IS 4420

Marketplace > University of Utah > Science > IS 4420 > Database Fundamentals
Herminio Grimes
The U
GPA 3.62


Almost Ready


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

Purchase these notes here, or revisit this page.

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

Preview These Notes for FREE

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

Unlock Preview
Unlock Preview

Preview these materials now for free

Why put in your email? Get access to more of this material and other relevant free materials for your school

View Preview

About this Document

Class Notes
25 ?




Popular in Course

Popular in Science

This 4 page Class Notes was uploaded by Herminio Grimes on Monday October 26, 2015. The Class Notes belongs to IS 4420 at University of Utah taught by Staff in Fall. Since its upload, it has received 40 views. For similar materials see /class/229965/is-4420-university-of-utah in Science at University of Utah.


Reviews for Database Fundamentals


Report this Material


What is Karma?


Karma is the currency of StudySoup.

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

Date Created: 10/26/15
IS 4420 Mid Term Exam Review Scope Chapter 1 through 7 Format 0 Close book and close notes 0 730am 7 850am 0 Total 100 points 0 Part A Total 50 points 25 multiple choice and truefalse questions 2 points each Covers basic concepts short answers comparisons de nitions descriptions interpretations and examples 0 Part B Total 50 points 3 problems 1 Conceptual data modeling 2 Logical database design 3 Writing and interpreting SQL commands Sample Exam Questions Question 1 Conceptual data modeling Assignment 2 Chapter 3 Problem 4e Draw an ERD for the following situation A hospital has a large number of registered physicians Attributes of PHYSICIAN include PhysicianiID the identi er and Specialty Patients are admitted to the hospital by physicians Attributes of PATIENT include PatientiID the identi er and PatientiName Any patient who is admitted must have exactly one admitting physician A physician may optionally admit any number of patients Once admitted a given patient must be treated by at least one physician A particular physician may treat any number of patients or may not treat any patients Whenever a patient is treated by a physician the hospital wishes to record the details of TreatmentiDetail include Date Time and Results Please see Assignment 2 Solution for answer Ques on 2 Logical database design Figure 526 INVOICE mmmnuNF Pme Valley Furmlmc Company DvdeLID cram Cusmmer Cuslamer Cumnear Pmducuo PmducL PmducL UmL omemd Dale u Name Address Descnpmm Flmsh Pnce nuanmy mus 7242qu 2 Vame Mam IX 7 DAm39ng Nslulzl auom Fumimm Table Ash mos lama2004 2 Mano 1x 5 Wmer s Cherry 325m 2 Panama Desk mus min200A 2 Vziue Mano 4 Enierlammem Nalural 65mm V Fumnum Center Mapla mm HMSmm s Fumnure aamaen u ArDr 5mm A Game co Diasser mm OQSQDOA s Fumllure Bummer 4 Emenammam Natural 55mm 2 cauevy co Csnier Maple uyuuui Alulumn u Writing on me functional dependencies above What nonnal form is chi relation in Why Draw a relah39 onal dependencies h mamwm Please see page 2177219 Question 3 Introduction to SQL Table Name employee Table Name dependent FName Address SuperS SN DepNo Table Name Dependent a Write a SQL command to delete Frankin Wong from the Employee table DELETE FROM EMPLOYEE WHERE SSN333445555 After you deleted Frankin Wong from the Employee table please write SQL command for the following tasks and show the results b List the name and salary of female employees Whose salary is greater than 30000 SELECT FNAME SALARY FROM EMPLOYEE WHERE SEX IN39F39 391quot AND SALARY gt 30000 FNAME SALARY Joyce 70000 Jennifer 43000 c List the Employee SSN and dependent name for dependents who are male SELECT ESSN DEPEDENTNAME FROM DEPENDEN T WHERE SEX IN39M39 39mquot ESSN DEPEDENTNAME 987654321 Abner 123456789 Michael d List the Employee SSN and number of dependents each employee has SELECT ESSN COUNTESSN FROM DEPEDENT GROUP BY ESSN ESSN COUNTESSN 987654321 1 123456789 3


Buy Material

Are you sure you want to buy this material for

25 Karma

Buy Material

BOOM! Enjoy Your Free Notes!

We've added these Notes to your profile, click here to view them now.


You're already Subscribed!

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

Steve Martinelli UC Los Angeles

"There's no way I would have passed my Organic Chemistry class this semester without the notes and study guides I got from StudySoup."

Jennifer McGill UCSF Med School

"Selling my MCAT study guides and notes has been a great source of side revenue while I'm in school. Some months I'm making over $500! Plus, it makes me happy knowing that I'm helping future med students with their MCAT."

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."


"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


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


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:

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

Satisfaction Guarantee: If you’re not satisfied with your subscription, you can contact us for further help. Contact must be made within 3 business days of your subscription purchase and your refund request will be subject for review.

Please Note: Refunds can never be provided more than 30 days after the initial purchase date regardless of your activity on the site.