intro to access and data management. announcements chapter 5 – thursday entropy registration quiz...
TRANSCRIPT
![Page 1: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/1.jpg)
Intro to Access and Data Management
![Page 2: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/2.jpg)
Announcements
• Chapter 5 – Thursday• Entropy Registration Quiz Due Date
• Extended to Weds.• Dreamspark Registration• Questions?
![Page 3: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/3.jpg)
The Database Approach
Database management system (DBMS)
Minimize the following problems:
Maximize the following:
![Page 4: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/4.jpg)
How is data organized in a DB:Data Hierarchy
Field
Record
File (or table)
Database
Is a grouping of
Is a grouping of
Is a grouping of
![Page 5: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/5.jpg)
Data Hierarchy (continued)
Field
RecordDatabase
Table
![Page 6: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/6.jpg)
Database Management Systems
Focus of this course: Relational database model Related Tables (Primary Keys Important) Data dictionary
How do you request data? Structured Query Language (SQL) - keywords
Query by Example (QBE) – forms/templates
![Page 7: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/7.jpg)
Relational DB Effectiveness: Normalization
Normalization (most streamlined DB)
![Page 8: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/8.jpg)
Steps in Creating Databases
1. Create the Tables Including a primary key
2. Create the Relationships between Tables
3. Enter data into the Tables
![Page 9: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/9.jpg)
Create the Tables
Tables are how information are stored within the database.
When creating tables, you have to define:Field NameData Type Field Size
![Page 10: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/10.jpg)
Create the Tables - Tips
Consider the type of data you are entering to determine what the data type and size should be.
Make sure when you setup foreign keys that they are the same type/size as the primary
Most frequently, you will be using the text for typeNumbers are typically used for fields where calculations will be usedDate/Time
Don’t forget to set a primary key
![Page 11: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/11.jpg)
Create the Relationships
To create information in a database, you must have relationships between tables.
Tips: Close all your tables before creating relationships
![Page 12: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/12.jpg)
Entering Data
To enter data, you need to be Datasheet View and you enter it like any other program
Once you go to the next row, the previous row is saved in the table.
![Page 13: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/13.jpg)
Exercise #1 – Car Parts Store
Create a new DB called ServiceShop that will consist of two tables.
CarsParts
![Page 14: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/14.jpg)
Exercise #1 – Car Parts Store
Cars Data_Type Field Size
VehicleID Text 5VehicleName Text 50Manufacturer Text 50VehicleYear Text 4VehicleType Text 20
Part Data_Type Field Size
PartID Text 5PartName Text 50VehicleID Text ?Cost ?
![Page 15: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/15.jpg)
Exercise #1 – Create Relationships
Create the appropriate relationships for the tables in your database.
Cars (VehicleID) -> Parts (VehicleID)
![Page 16: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/16.jpg)
Exercise #1 – Enter Information
VehicleID VehicleName Manufacturer VehicleYear VehicleType
00001 Avalon Toyota 1999 Sedan
00002 Camry Toyota 2005 Sedan
00003 Tundra Toyota 2010 Truck
00004 Sienna Toyota 2014 Minivan
PartID PartName VehicleID Cost11111 Muffler 00004 $150.0022222 Wipers 00001 $10.0033333 Transmission 00002 $1,000.00
![Page 17: Intro to Access and Data Management. Announcements Chapter 5 – Thursday Entropy Registration Quiz Due Date Extended to Weds. Dreamspark Registration Questions?](https://reader036.vdocuments.us/reader036/viewer/2022081520/5697bf8a1a28abf838c8abf8/html5/thumbnails/17.jpg)
Project #1 – Database Creation
Remainder of class begin working on project #1. You should be able to
complete:
Table Creation Relationships Data Entry