GuidedStudy

docx

School

University of Maryland, University College *

*We aren’t endorsed by this school

Course

330

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

Uploaded by ColonelGalaxyGoldfinch4

IFSM 330 7380 Guided Study Assignment – Introduction to Databases 1 Student Name: Instructions Watch the Introduction to Databases video ( 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% 2. Software systems, apps, etc. 10% 2. Data Table 10% 3. Features Analysis Table 40% TOTAL 100% 1 Adapted from an assignment by Karen C. Davis of Miami University submitted for faculty use to the Teradata University Network. 2019-12-06

IFSM 330 7380 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 A large scale or amount such as data within a database. b. Persistent To remain in place after an action. c. Safe Protection from failures or human error. d. Multi-user The ability to allow several users to access current versions of the same data. e. Convenient How easy it is for a user to interact with a database. f. Efficient The ability to process several queries per second successfully. g. Reliable The ability to hold a high up time for user interactions. 2. database concepts: a. data model The way the data is structured, stored, or presented. b. schema vs. data Schema (types) are set, and the variables (Data) adhere to it. 3. purpose of languages associated with a database: a. data definition language Used to set up the structure of a database. 2019-12-06

IFSM 330 7380 b. data manipulation language Used to modify a database or data within. c. query language Used to query the database for information. 4. database-related jobs: a. DBMS implementer Responsible for building the system. b. designer Creates the structure or scheme for the database. c. application developer Creates applications that interact with the database. Often the middleman between the database and end user. d. database administrator Inputs data and ensures the database continues to operate correctly. 2019-12-06

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

IFSM 330 7380 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)? 1000 b. a terabyte (TB)? 1,000,000 c. a petabyte (PB)? 1,000,000,000 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. d. How many photos can be stored in a GB/TB/PB? e. How many audio books can be stored in a GB/TB/PB? GB TB PB (d) Photos 200 200,000 200,000,000 (e) Audio Books 1.2 1,234.6 1,234,567.9 2. In the video, Dr. Widom states that you have probably used a database in the last hour. She is essentially speculating that most students use a database in every waking hour without even realizing it. Think about the last 24/48/72 hours or the last week... what software systems, apps, or embedded hardware/software systems have you used? Narrow it down to those that use some form of stored data. List as many as you can think of, but you should list at least 3 for the next part of the assignment. Software systems, apps, embedded hardware/software systems used/accessed in the last 24 hours: 1. User Accounts portal (Work) 2. Google 3. Package tracking (UPS) 4. 5. 6. 2019-12-06

IFSM 330 7380 a. Choose three of them to analyze and fill in the top row of the table below (1)-(3). b. Predict what data they store in the second row. c. Predict what kinds of queries or requests for data are made by the system in the third row. We’re not looking for a specific SQL query or command. It’s important here to have a specific system/database in mind (a), with specific types of data (b). Think about the system (a) and the data (b) and various users (or applications) that access that data. For example, as an online bank customer, what kinds of data queries/requests might I want to know about my account with that bank? As an HR manager in a large company, what kinds of data (b) might be interesting to retain about employees in an employee database (a) and what kinds of data queries/request might be common on that data? OK, now that you’ve been given two examples (an online banking example and an employee database example), you may use ONE of these examples in your table below but not BOTH. Please develop at least two additional, different examples. A Banking example and an Employee Database example should NOT both appear in your table below. Data Table (a) Systems (sites/apps) Accessed (1) UA Portal (2) Google (3) Tracking (b) Types of data stored Integer, character, string, floating plan, array, varchar, boolean, Date/Time. Integer, character, string, floating plan, array, varchar, boolean, Date/Time, Date/Time, Integer, character, string, floating plan, array. (c) Kinds of data queries/ requests Locate account via account number. True or False for set criteria. Videos matching text input. Articles matching text input. Use tracking number to locate information on package. Locate date and time of last scan. 3. Using the systems identified as (1)-(3) in the previous question, fill in the table below evaluating which features you think the database supports and why? Some cells may be blank, but only if the feature is not relevant to the example system . Your analysis offered within the table should be specific to each feature in the first column. Features Analysis Table (1) UA Portal (2) Google (3) UPS Tracking 2019-12-06

IFSM 330 7380 Massive The portal has access to over half a million use accounts within our system. This amount of data is massive in terms of databases. Google’s search engine is as large as it can get. Within seconds queried information from all over the world will appear on your screen. Having a world reach and millions of packages being shipped daily, the database used to track these packages is massive in scale. Persistent After interaction the data remains in place unless it was requested to be removed. After search all results and their data remain in place to be available for future searches. Tracking information remains in place while package is in transit. Safe All data is backed up with redundancy. All data is backed up with redundancy. All data is backed up with redundancy. Multi-User Portal can handle multiple users on the same account. Results vary per location. Multi-user for viewing results. Convenient Search account number and view/ interact with account. The easiest way to locate information. Click link or input tracking number. Efficient Due to size of company, the database responds fast. Very efficient. Can handle millions of searches per second. Very efficient. Can handle millions of searches per second. Reliable Decent up-time but interruptions are common. Very high up-time. I have never seen it down. Very reliable, stress over high traffic times can slow response. (Holidays) 2019-12-06

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

GuidedStudy

Related Documents