Search for notes by fellow students, in your own course and all over the country.
Browse our notes for titles which look like what you need, you can preview any of the notes via a sample of the contents. After you're happy these are the notes you're after simply pop them into your shopping cart.
Title: SQL Database Theories Week 1-Chapter 1
Description: These are notes to help prepare for the College level SQL Database Concepts course taken as a Freshman. This helps define Tables and other SQL terms.
Description: These are notes to help prepare for the College level SQL Database Concepts course taken as a Freshman. This helps define Tables and other SQL terms.
Document Preview
Extracts from the notes are below, to see the PDF you'll receive please use the links above
Assignment 1
You may use any word processor to complete these questions, but I’ve only offered help for Microsoft Word
...
There is a Web version of Word in Falcon Mail, but you will lose some formatting
...
To delete columns in MS Word, select the entire column and then right-click any cell in the column to be deleted and choose Delete Columns
...
Right-click any cell in the selected row and choose Delete Rows
...
The strikethrough font option in MS Word is on the Home tab, Font section, on a button that shows abc
...
Poodle
Cashmier
Std
...
Downs@somewhere
...
James@somewhere
...
Downs@somewhere
...
Frier@somewhere
...
James@somewhere
...
James@somewhere
...
Trent@somewhere
...
In each of the 3 copies, show an example of an insert, update, and a delete anomaly
...
Insert: A new, blank line has been added for convenience
...
Then, describe the
problem
...
Poodle
Cashmier
Std
...
Downs@somewhere
...
James@somewhere
...
Downs@somewhere
...
Frier@somewhere
...
James@somewhere
...
James@somewhere
...
Trent@somewhere
...
Trent@somewhere
...
The pet is the basis for the data
...
Update: Illustrate an update anomaly by modifying data and highlighting the updated cells in yellow
...
PetName
PetType PetBreed
PetDOB
OwnerLastName
OwnerFirstName
King
Dog
Std
...
Poodle
17-Jul-11 Downs
Marsha
AJ
Dog
Collie Mix
5-May-11 Frier
Liz
Cedro
Cat
Unknown
6-Jun-06 James
Richard
Woolley
Cat
Unknown
???
James
Richard
Buster
Dog
Border Collie
11-Dec-05 Trent
Miles
What is the problem: The owners email was updated to show the email of another owner
...
James@somewhere
...
James@somewhere
...
Downs@somewhere
...
Frier@somewhere
...
James@somewhere
...
James@somewhere
...
Trent@somewhere
...
Delete: Illustrate a delete anomaly by changing the font of an entire row to strikethrough
...
PetName
PetType PetBreed
PetDOB
OwnerLastName
OwnerFirstName OwnerPhone OwnerEmail
King
Dog
Std
...
Downs@somewhere
...
James@somewhere
...
Poodle
17-Jul-11 Downs
Marsha
201-823-5467 Marsha
...
com
AJ
Dog
Collie Mix
5-May-11 Frier
Liz
201-823-6578 Liz
...
com
Cedro
Cat
Unknown
6-Jun-06 James
Richard
201-735-9812 Richard
...
com
Woolley
Cat
Unknown
???
James
Richard
201-735-9812 Richard
...
com
Buster
Dog
Border Collie
11-Dec-05 Trent
Miles
201-634-7865 Miles
...
com
What is the problem: You would be deleting the owner, who has more than one pet in the table
...
4
...
Copy the parts of the table from Figure 1-26 above to make 2 separate tables in the space
below
...
Create an ID column for pets and populate it
...
PetName
King
PetType
Dog
PetBreed
Std
...
Poodle
201-823-5467
AJ
Dog
Collie Mix
201-823-6578
Cedro
Cat
Unknown
201-735-9812
Woolley
Cat
Unknown
201-735-9812
Buster
Dog
Border Collie
201-634-7865
17-Jul-11
5-May-11
6-Jun-06
???
11-Dec-05
OwnerLastName
James
Downs
Frier
Trent
OwnerFirstName
Richard
Marsha
Liz
Miles
OwnerPhone
201-735-9812
201-823-5467
201-823-6578
201-634-7865
OwnerEmail
Richard
...
com
Marsha
...
com
Liz
...
com
Miles
...
com
5
...
Each pet can have only 1 owner, but an owner can have multiple pets
...
Poodle
27-Feb-10
Downs
Marsha
201-823-5467
Marsha
...
com
Ear Infection
17-Aug-11
$65
...
James@somewhere
...
50
Filo
Dog
Std
...
Downs@somewhere
...
Frier@somewhere
...
50
Cedro
Cat
Unknown
James
Richard
201-735-9812
Richard
...
com
Nail Clip
5-Sep-11
$27
...
James@somewhere
...
00
Buster
Dog
Border Collie
11-Dec-05
Trent
Miles
201-634-7865
Miles
...
com
Laceration Repair
5-Oct-11
$127
...
In each of the 3 copies, show an example of an insert, update, and a delete anomaly
...
6
...
Illustrate an insert anomaly by adding data that causes a data anomaly
...
PetName
PetType
PetBreed
PetDOB
OwnerLastName
OwnerFirstName
OwnerPhone
OwnerEmail
Service
Date
Charge
King
Dog
Std
...
Downs@somewhere
...
00
Teddy
Cat
Cashmier
1-Feb-09
James
Richard
201-735-9812
Richard
...
com
Nail Clip
5-Sep-11
$27
...
Poodle
17-Jul-11
Downs
Marsha
201-823-5467
Marsha
...
com
AJ
Dog
Collie Mix
5-May-11
Frier
Liz
201-823-6578
Liz
...
com
One year shots
5-May-11
$42
...
James@somewhere
...
50
Woolley
Cat
Unknown
???
James
Richard
201-735-9812
Richard
...
com
Skin Infection
3-Oct-11
$35
...
Trent@somewhere
...
00
AJ
Dog
Collie Mix
8-May-11
Frier
Liz
201-823-4478
Liz
...
com
One year shots
8-May-11
$31
...
7
...
Then, describe the problem
...
Poodle
27-Feb-10
Downs
Marsha
201-823-5467
Marsha
...
com
Ear Infection
17-Aug-11
Charge
$65
...
James@somewhere
...
50
Filo
Dog
Std
...
Downs@somewhere
...
Frier@somewhere
...
50
Cedro
Cat
Unknown
6-Jun-06
James
Richard
201-735-9812
Richard
...
com
Nail Clip
5-Sep-11
$27
...
James@somewhere
...
00
Buster
Dog
Border Collie
11-Dec-05
Trent
Miles
201-634-7865
Miles
...
com
Laceration Repair
5-Oct-11
$127
...
A new owner will be created with info that is the same as the original
entry
...
Delete: Illustrate a delete anomaly by changing the font of an entire row to strikethrough
...
PetName
PetType
PetBreed
PetDOB
OwnerLastName
OwnerFirstName
OwnerPhone
OwnerEmail
Service
Date
Charge
King
Dog
Std
...
Downs@somewhere
...
00
Teddy
Cat
Cashmier
1-Feb-09
James
Richard
201-735-9812
Richard
...
com
Nail Clip
5-Sep-11
$27
...
Poodle
17-Jul-11
Downs
Marsha
201-823-5467
Marsha
...
com
AJ
Dog
Collie Mix
5-May-11
Cedro
Cat
Unknown
6-Jun-06
Frier
Liz
201-823-6578
Liz
...
com
One year shots
5-May-11
$42
...
James@somewhere
...
50
Woolley
Cat
Unknown
???
James
Richard
201-735-9812
Richard
...
com
Skin Infection
3-Oct-11
$35
...
Trent@somewhere
...
00
What is the problem: Again, removing this entire row would cause an owner with multiple pets to be deleted, leaving the other pets without an owner
...
Break the above list into 3 tables, each with data for a single theme
...
Poodle
Teddy
Cat
Cashmier
Filo
Dog
AJ
Dog
Cedro
PetDOB
OwnerPhone
27-Feb-10
201-823-5467
1-Feb-09
201-735-9812
Std
...
Frier@somewhere
...
James@somewhere
...
Downs@somewhere
...
Trent@somewhere
...
00
5-Sep-11
$27
...
50
201-823-5467
201-823-6578
One year shots
201-735-9812
Nail Clip
5-Sep-11
$27
...
00
201-634-7865
Laceration Repair
5-Oct-11
$127
...
Describe how relationships are represented in a relational database using the 3 tables above
...
Title: SQL Database Theories Week 1-Chapter 1
Description: These are notes to help prepare for the College level SQL Database Concepts course taken as a Freshman. This helps define Tables and other SQL terms.
Description: These are notes to help prepare for the College level SQL Database Concepts course taken as a Freshman. This helps define Tables and other SQL terms.