IMS1907 Database Systems - PowerPoint PPT Presentation

Loading...

PPT – IMS1907 Database Systems PowerPoint presentation | free to download - id: 6ad8e1-MzA5M



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

IMS1907 Database Systems

Description:

IMS1907 Database Systems Summer Semester 2004/2005 Lecture 2 Relational DBMS Software An Overview of Microsoft Access – PowerPoint PPT presentation

Number of Views:23
Avg rating:3.0/5.0
Date added: 30 October 2019
Slides: 25
Provided by: DavidG252
Category:

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: IMS1907 Database Systems


1
IMS1907 Database Systems
  • Summer Semester 2004/2005
  • Lecture 2
  • Relational DBMS Software
  • An Overview of Microsoft Access

2
Database Systems
Database Application
DBMS
Database
Users
  • Database applications are an intermediary between
    users and DBMS
  • DBMS processes application requests against
    database
  • create definitions, write, read, update

3
Relational Database Systems
  • Relational database systems are currently the
    most common used in industry
  • Access, SQL Server, Oracle, Ingres, DB2, Sybase,
    MySQL, Informix
  • Organises the database as groups of related
    tables
  • Tables are organised by business themes
  • reflect practices and policies of organisation
  • Tables can be joined to discover related
    information occurring across themes

4
Relational Database Terminology
  • Table
  • storage entity for a database
  • a grid made up of rows and columns
  • each row is a record
  • each column is a field
  • made up of records containing data about a
    thing
  • customer, sale, rental, loan, supplier, product
  • like a folder in a filing cabinet

5
Relational Database Terminology
  • Record
  • unit within a table, normally a row of the table
  • contains related data about the entity
  • a single transactions details, summary details,
  • like a sheet of paper in a folder
  • Field
  • a smaller unit within a record, a column in the
    table
  • contains a single fact about the entity
  • like a field on a sheet of paper in a folder

6
Relational Database Terminology
  • Keys
  • defined from one or more fields of a table
  • used to order, identify and retrieve data
  • Primary Key (PK)
  • a unique identifier for a particular record
  • no two records can share the same PK
  • often an ID number useful to a business
  • customer number, student number, licence number,

7
Relational Database Terminology
  • Secondary Key
  • defined from one or more other fields of a a
    table
  • used to arrange database in some other order
  • can be multiple occurrences in a database
  • Foreign Key (FK)
  • one or more fields of a table that appear as a PK
    in another table
  • can be multiple occurrences in a database
  • used to join tables based on common information

8
Relational Database Terminology
  • Table Structure
  • metadata definitions
  • instructions regarding arrangement and format of
    data in record
  • keys, data type, length
  • formats, masks, validation rules
  • constraints, rules

9
Relational Database Terminology
  • Forms
  • alternative method to datasheet for entering and
    accessing data
  • screen-based form appears similar to paper-based
    equivalent of the record
  • can be used to both capture and display data
  • allow entry, editing, viewing and deletion of
    records in one or more table

10
Relational Database Terminology
  • Reports
  • provide the ability to arrange data from one or
    more tables, and view and print the data for
    later use
  • can also be used to perform calculations,
    summarise, and group information before viewing
  • screen-based report can appear similar to
    paper-based equivalent of the report
  • primarily a display mechanism only

11
Relational Database Terminology
  • Queries
  • allow you to answer specific questions about data
    in the database
  • can be used to display records based on criteria,
    perform calculations, summarise information, sort
    and group information, or delete data from one or
    more tables in database
  • can be regular or ad hoc

12
Creating Access Tables
design options
  • DB objects

existing DB objects
13
Creating Access Tables - Design View
Primary key
data description
data type
  • properties

14
Access Tables Datasheet View
field names
datasheet
15
Sorting Tables
Unsorted data
Sort filters
Field to sort on
Data sorted by Member_No
16
Relationships Between Tables
related fields
relationship
edit relationship
17
Subdatasheets
datasheet
subdatasheet
Click to open subdatasheet
18
Access Forms
form
datasheet
19
Access Forms and Sub-forms
form
sub-form
20
Access Queries
related tables
query design
21
Access Queries
query response
22
Access Reports
table for report
report design screen
23
Access Reports
24
References
  • Duffy, T., (2000), Microsoft Access 2000,
    Prentice-Hall, Upper Saddle River, NJ, USA.
  • Kroenke, D.M., (2004), Database Processing
    Fundamentals, Design and Implementation, (9th
    edn.), Pearson Education Inc., Upper Saddle
    River, NJ, USA.
About PowerShow.com