Database Management Systems
1
Docsity.com
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Guidelines and tips
Prepare for your exams
Study with the several resources on Docsity
Earn points to download
Earn points by helping other students or get them with a premium plan
Community
Ask the community
Ask the community for help and clear up your study doubts
University Rankings
Discover the best universities in your country according to Docsity users
Free resources
Our save-the-student-ebooks!
Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors
Build Applications - Database Management Systems - Lecture Slides, Slides of Introduction to Database Management Systems
Some concept of Database Management Systems are Access Methods Layer, Basic Structure, Common Structures, Designing Systems, Join Processing, Modern Computers, Query Evaluation Techniques. Main points of this lecture are: Build Applications, Build Applications, Major Components, Management System, Advantages, Database, Main Database, Management Systems, Database Management Systems, Databases
Typology: Slides
2012/2013
1 / 44
This page cannot be seen from the preview
Don't miss anything!
Related documents
Partial preview of the text
Download Build Applications - Database Management Systems - Lecture Slides and more Slides Introduction to Database Management Systems in PDF only on Docsity!
Database Management Systems
1
Objectives
• What is a database?
• How are databases used to build applications?
• What are the major components of a database
management system?
• What are the advantages of using a database
management system?
• What are the main database management systems?
• How have database management systems changed
over time?
• What databases are used with this book?
• What are the first steps to start a project?
2
Goal: Build a Business Application
4
Tools:
Database Design
SQL (queries)
Programming
Design SQL Program
Design^ SQL^ Program
Best: Spend your time on design and SQL.
Worst: Compensate for poor design and limited SQL with programming.
DBMS: Database Management System
- Database
- A collection of data stored in a standardized
format, designed to be shared by multiple users.
- Database Management System
- Software that defines a database, stores the data,
supports a query language, produces reports, and creates data entry screens.
5
DBMS Application Design
7
1. Identify business rules.
2. Define tables and relationships.
3. Create input forms
and reports.
4. Combine as
applications for users.
DBMS Features/Components
- Database engine
- Storage
- Retrieval
- Update
- Query Processor
- Data dictionary
- Utilities
- Security
- Report writer
- Forms generator (input screens)
- Application generator
- Communications
- 3GL Interface
8
Database Tables (Access)
10
Database Tables (Oracle)
11
DBMS Report Writer
13
All Data
Database Engine Data Dictionary
Query Processor
Report Writer
Report Format
and Query
Report Writer (Oracle)
14
DBMS Components
16
All Data
Database Engine Data Dictionary Security
Query Processor
Form Builder
Report Writer
Communication
Network
3GL Connector
Program
Application Generator
Advantages of Database Approach
• Minimal data redundancy.
• Data consistency.
• Integration of data.
• Sharing of data.
• Enforcement of standards.
• Ease of application development.
• Uniform security, privacy and integrity.
• Data independence.
17
Modifying Data with DBMS
- Add cell number to
employee table
- Open table definition
- Add data element
- If desired, modify reports
- Use report writer
- No programming
- Existing reports, queries,
code will all run as before with no changes.
19
Field Name Data Type Description
EmployeeID Number Autonumber.. TaxpayerID Text Federal ID LastName Text FirstName Text
... Phone Text ...
CellPhone Text Cellular...
Web Databases
20
Developers
Database
Web Server
Web forms and reports
data
Users
Reports