CS 3410 Lecture Notes - Lecture 1: Object Database, Stored Procedure, Database

26 views12 pages
26 Aug 2016
School
Course
Professor
Black = class notes
Blue = important
Green = textbooks
Lecture 1 Powerpoint and Textbook- Chapter One- “Introduction”
Characteristics of a Database
Data is stored in tables (with rows and columns)
Databases may have multiple tables, where every table may store different things
A database stores data and relationships.
Each row in a table stores data about an occurrence or instance of the thing on interest
Purpose = key track of things
Most common = relational database
oA relational database stores data in tables (w/ rows and columns)
Primary key
oEach row in a table is uniquely identified by a primary key and the values of these keys
are used to create the relationship between the tables. (5) ie. Student Number
Surrogate key: if numbers are used in primary key are automatically generated and assigned to
the database itself, they are also surrogate keys
Foreign key: provides the link between 3 tables, therefore creating an relationship b/t 2 tables
Information
oKnowledge derived from the data; data processed by summing, ordering, auging,
grouping or comparing
Naming Conventions in this textbook
Tables names are in all CAPS: ie. STUDENT
Column names are written like: ie. Team; ClassNumber
Databases Create Information
Data = recorded facts and figures
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.

Already have an account? Log in
Information = knowledge derived from data
Databases record data, in a manner that allows us to produce info from the data
Databases record info in a way that allows them to produce information
Components of a Database System
Users -> Database Application -> DBMS (Create, Process, Administer) -> Database
oSQL (Structured Query Languages): the database app sends SQL statements to the DMBS
for processing
oDatabase: collection of related tables and other structures
oDBMS is a comp. program used to create, process and admin the database; receives
requests encoded in SQL and translates into actions on the database
oDatabase App: set of 1+ computer programs that serve as intermediate b/t the user and
DBMS; read/modify data by SQL statements to the DBMS; represent Data in forms and
reports
oUsers: employ a database app to keep track of things
Components of a Database System w/ SQL
Users -> Database Application -> SQL ->DBMS (Create, Process, Administer) -> Database
Applications, the DBMS and SQL
Applications: computer programs users work with
DBMS creates processes and administers databases
Structured Query Language(SQL): standard database language
Database Applications
Create and process forms
Form hides the structure of the underlying tables from the user
Process user queries
o1. Generate user request and send to the DMBS
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.

Already have an account? Log in
o2. Reformat and send to the user
oA SQL statement is a query statement
oExample:
SELECT LastName, FirstName, EmailAddress
FROM STUDENT
WHERE StudentNumber >2;
Create and process reports
Displayed accordingly to users need
Execute application logic
Control the application
o2 ways:
The app written so that any logical options are presented to the user
The app needs to control data activities w/ the DBMS
Types of Database Applications
Single-User Database Apps: Used by a salesperson to keep track of customers. ie. GoldMine
Multi-User Database Apps: ie. Scheduling at Doctors Appts
oProblems: Booking at the same times
oCustomer Relationship Management(CRM)
oSAP is the leading vendor in Enterprise Resource Planning (ERP)- touches every
department of a manufacturing company [including sales, inventory, pro. Planning…]
E-Commerce Database Apps: order, billing, shipping and Customer support
oIe. Amazon, Drugstore.com
Reporting & Data Database Apps
oUse data generated by order process and operation systems to produce info to help
manage the enterprise (summarize existing data)
DBMS ie. MS Access
find more resources at oneclass.com
find more resources at oneclass.com
Unlock document

This preview shows pages 1-3 of the document.
Unlock all 12 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Notes+

Unlimited access to class notes and textbook notes.

YearlyBest Value
75% OFF
$8 USD/m
Monthly
$30 USD/m
You will be charged $96 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.