1

.pdf

School

Simon Fraser University *

*We aren’t endorsed by this school

Course

354

Subject

Computer Science

Date

Oct 30, 2023

Type

pdf

Pages

35

Uploaded by Sahajkaran21

Report
CMPT 354 Acknowledgements Slides are combination of – 354 instructors’ notes and slides – The main text: Database Management Systems , Raghu Ramakrishnan/Johannes Gehrke – Reference: Database systems: the complete book , H. G. Molina, J.D. Ullman, and J. Widom.
CMPT 354 Introduction to Database Systems Chapter 1
CMPT 354 Questions What is a DBMS (Database Management System) Why should we consider a DBMS to manage data? How is application data represented in a DBMS? How is data in a DBMS retrieved and manipulated ? How does a DBMS support concurrent access and protect data during system failure? Who is involved with databases in real life?
CMPT 354 Database Applications Any application that has to store large amounts of data probably needs a database – Financial industry – Government agencies – Airlines – Universities – Utilities – High street retailers – Online retailers – Manufacturing – Human resources – Social media sites – Online games – …
CMPT 354 Data Storage Without DBMS File systems: data would be collected in many different files and used by many application programs File 1 File 2 … File m Application Program 1 Application Program 2 … Application Program n
CMPT 354 What Happens If … Information that is in more than one file is changed by a program that only interacts with one file? We need to repeatedly access a single record out of millions of records? We need to retrieve data stored in multiple files? Several programs need to access and modify the same record at the same time? The system crashes while one of the application programs is running?
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
Recommended textbooks for you
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
SEE MORE TEXTBOOKS

Browse Popular Homework Q&A

Q: L x2 dx Compute the approximations Tn, Mn, and Sn for n = 5, 10, 20 and compute the corresponding…
Q: A 26.00 mL sample of an unknown H3PO4 solution is titrated with a 0.130 M NaOH solution. The…
Q: cricital numbers of f(x): ng the second derivative value test, list the critical point(s) that can…
Q: A 35.0 N force stretches a vertical spring 0.250 m. Part A What mass must be suspended from the…
Q: It didn't work,it still printed 'you chose' when it's outside of the range
Q: On March 25, you borrow some money for 120 days.  What is the maturity date?
Q: A 1.00 L flask is filled with 1.30 g of argon at 25 °C. A sample of ethane vapor is added to the…
Q: A compound is 80.0% carbon and 20.0% hydrogen by mass. Assume a 100.-g sample of this compound. The…
Q: Find the critical numbers of the function. (Enter your answers as a comma-separated list. If an…
Q: Calculate the mass of Mg (g) Mass of watch glass, evaporating dish, and reacted Mg after cooling:…
Q: 5. y = √x² - 1
Q: Find the number in the interval [0, 4] such that the number minus its square is as follows. (a) as…
Q: the system below, find the general solution, sketch the trajectories, bei lude the eigenvector…
Q: Acoma, Inc., has determined a standard direct materials cost per unit of $6.20 (2 feet x $3.10 per…
Q: You want to buy a home.  You can borrow 95% of the purchase price.  Assuming you can make a down…
Q: The December 31, Year 1, balance sheet for Deen Company showed total stockholders' equity of…
Q: rials in an experiment with a polygraph include 98 results that include 24 cases of wrong results…
Q: The range of a linear transformation T: V→W is a subspace of W. Explain what properties must hold…
Q: Bacon Inc. has the following stockholders’ equity section in its May 31, 2019, comparative balance…
Q: uy a truck for $25,200.  You must also pay tax and license fees of $1,700.  You borrow $23,000 at 9%…
Q: PROBLEM (6) (Optimal tariff setting without the small country assumption) US demand and supply for…
Q: two recommendations to improve the process of perinatal care for exclusive breast milk feeding
Q: for each pair of functions, perform the indicated operation.Let f(x) = 5x + 3 and g(x) = x 2 + 3x -…
Q: C++ Help. Declare a Boolean variable named allOdd. Read in an input value for variable numInput.…
Q: Use the properties of natural logarithms to simplify the function. f(x) = ln(x/4)+ln(4)