Guided Study Assignment – Introduction to Databases[1]
|
|
Student Name: | < Replace this text with your name >
|
Instructions
Watch the Introduction to Databases video (v=D-k-h0GuFmE“>https://www.youtube.com/watch?v=D-k-h0GuFmE ) by Dr. Jennifer Widom of Stanford University and respond to the items in Part 1. Feel free to pause the video to respond to the items and re-watch segments as necessary. Alternatively, you may prefer to view the presentation once through and then again to complete the assignment. The presentation is 13 minutes long.
Note that this presentation is part of a database course for computer science students at Stanford University. When Dr. Widom states ‘in this course we will cover’ or that ‘we will cover’ a given topic in greater detail later in the course, she is referring to her course, not ours.
To complete the Guided Study Assignment Worksheet, you should type your responses below. Feel free to expand the size of the various cells of each table to accommodate your response (just keep typing, the cell will expand).
Part 2 will require you to do some additional investigation and prediction.
Point Values
The sections of this assignment are scored as follows:
Part I: Terminology
1-4. Definitions 30%
Part II: Investigation
1 (a-3). Calculations 10%
TOTAL 100%
Part 1: Terminology
In your own words, define/describe what each of these terms means in a database context. Do not attempt to copy specific sentences from the video word for word. Examples to support definitions and descriptions are welcome, but are insufficient on their own. You should establish that you understand the significance of each term.
1. Database Functionality: | |
a. Massive |
|
b. Persistent |
|
c. Safe |
|
d. Multi-user |
|
e. Convenient |
|
f. Efficient |
|
g. Reliable |
|
2. database concepts: | |
a. data model |
|
b. schema vs. data |
|
3. purpose of languages associated with a database: | |
a. data definition language |
|
b. data manipulation language |
|
c. query language |
|
4. database-related jobs: | |
a. DBMS implementer |
|
b. designer |
|
c. application developer |
|
d. database administrator |
|
Part 2: Investigation
In this question, you’ll need to look up some information and do some computations. You may use a calculator or Excel for the calculations in (d) and (e).
1. How many megabytes (MB) in | |
a. a gigabyte (GB)? | |
b. a terabyte (TB)? | |
c. a petabyte (PB)? |
An uncompressed, high quality photograph is about 5MB. An audio book requires about 30MB per hour.
The audiobook of The Order of the Phoenix by J.K. Rowling is about 27 hours long.
Fill in the table below using The Order of the Phoenix as an example of the size of an audio book and the 5MB uncompressed high quality photo as an example of a typical photo.
GB | TB | PB | |
(d) Photos |
|
||
(e) Audio Books |
|
Software systems, apps, embedded hardware/software systems used/accessed in the last 24 hours: | |
1. |
|
2. |
|
3. |
|
4. |
|
5. |
|
6. |
|
Data Table | |||
(a)
Systems (sites/apps) Accessed |
(1)
|
(2) | (3) |
(b)
Types of data stored |
|
||
(c) Kinds of data queries/ requests |
|
Features Analysis Table | |||
(1) |
(2) |
(3) |
|
Massive |
|
||
Persistent |
|
||
Safe |
|
||
Multi-User |
|
||
Convenient |
|
||
Efficient |
|
||
Reliable |
|
[1] Adapted from an assignment by Karen C. Davis of Miami University submitted for faculty use to the Teradata University Network.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more
Recent Comments