Csc 215 Answers
Parth barot
CISC 215
Chapter 1 review Question and answers
1) Databases are used everywhere, they are key component of heart of organization –wide operation and decision support application.
2) The purpose of this book is to learn the essential database concepts, technology and techniques that you will need to begin a career as database developer.
3) The purpose of a database is to help people to keep track things.
4) A modification problem is a data corruption or loss that occurs when a table uses one row to store about two or more themes. 1) Insert problems missing data 2) update problem, inconsistent data 3) delete problem, data loss.
5) 1)Updating an owner’s name or other data must be done many rows, 2)possibly incorrect , 3)No place to store owner data unless they have …show more content…
8) PET (pet ID, pet name, pet type, pet Breed, pet DOB, owner Phone), OWNER (Owner name, Owner email).
9) 1) We have to change owner data just once for each owner 2) we allow only one row per owner so we can’t have inconsistent data 3) we can add owner data, even if the owner has no pet.
10) Structure query language. It use for combining querying and processing sets of tables and the data in those table.
11) The list has three themes: pet, owner and service
12) PET (Pet ID, Pet Name, Pet Type, Pet Breed, Pet DOB, Owner Phone) OWNER (OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) SERVICE (ServiceID, Service, Date, Charge, PetID)
13) Relationships are represented by storing the key values such as pet id and owner phone number in second table column.
14) User, database application , DBMS, and database
15) A self-describing collection of related tables.
16) It’s important to self-describing the data base because this is the way to know the database structure and content.
17) User data, metadata, indexes and other overhead data.
18) Metadata is data about the structure of the
CISC 215
Chapter 1 review Question and answers
1) Databases are used everywhere, they are key component of heart of organization –wide operation and decision support application.
2) The purpose of this book is to learn the essential database concepts, technology and techniques that you will need to begin a career as database developer.
3) The purpose of a database is to help people to keep track things.
4) A modification problem is a data corruption or loss that occurs when a table uses one row to store about two or more themes. 1) Insert problems missing data 2) update problem, inconsistent data 3) delete problem, data loss.
5) 1)Updating an owner’s name or other data must be done many rows, 2)possibly incorrect , 3)No place to store owner data unless they have …show more content…
8) PET (pet ID, pet name, pet type, pet Breed, pet DOB, owner Phone), OWNER (Owner name, Owner email).
9) 1) We have to change owner data just once for each owner 2) we allow only one row per owner so we can’t have inconsistent data 3) we can add owner data, even if the owner has no pet.
10) Structure query language. It use for combining querying and processing sets of tables and the data in those table.
11) The list has three themes: pet, owner and service
12) PET (Pet ID, Pet Name, Pet Type, Pet Breed, Pet DOB, Owner Phone) OWNER (OwnerLastName, OwnerFirstName, OwnerPhone, OwnerEmail) SERVICE (ServiceID, Service, Date, Charge, PetID)
13) Relationships are represented by storing the key values such as pet id and owner phone number in second table column.
14) User, database application , DBMS, and database
15) A self-describing collection of related tables.
16) It’s important to self-describing the data base because this is the way to know the database structure and content.
17) User data, metadata, indexes and other overhead data.
18) Metadata is data about the structure of the