Database design
This presentation is the property of its rightful owner.
Sponsored Links
1 / 25

Database Design PowerPoint PPT Presentation


  • 51 Views
  • Uploaded on
  • Presentation posted in: General

Database Design. Presenters: Nicolas Lee Tam Nguyen. Database Design - Option. Student will learn about: http://ict-stage5.wikispaces.com/Syllabus+Outcome Student will learn to: explain the purpose of a database

Download Presentation

Database Design

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Database design

Database Design

Presenters:

Nicolas Lee

Tam Nguyen


Database design option

Database Design - Option

  • Student will learn about:

    http://ict-stage5.wikispaces.com/Syllabus+Outcome

  • Student will learn to:

    • explain the purpose of a database

    • describe the relationships between a database, file, record, field , and character.

    • create an effective design for database form

    • construct query searches and sorts on given data

    • input data via import function


Let s do a quick survey

Let’s do a quick survey ....

About Music

Your favourite artist.....

What type of music Genre ......

Name some of their songs ......

Country of birth .....


Design process

Design Process

Collecting of raw data.

Favourite Music :

Artist Name

DOB

Genre

Song Name


What is a database

What is a database?

  • Data – are raw facts.

  • Database is way of organising and storing collection of similar facts.

    Give some examples of databases

    http://edweb.sdsu.edu/courses/edtec570/lfd/dblist.html


Computerised or not

Computerised or not?

  • Advantages

  • Disadvantages

    • Computerised databases?


Social issues

Social Issues

  • How database changes the workplace?

    • Shopping

    • Online personal profiles eg: Linkedin

    • Tax office, government, and banks.

    • Google and social networking databases ....

    • Voting system.

    • http://www.youtube.com/watch?v=hsnr_4ccceY&feature=bulletin


Security issues

Security Issues

  • User name and password security - to protect from unauthorised users.

  • Design backup procedure - such as making regular backup and store them is secure location.

  • Protected from viruses and worms. By having the latest virus and update patches.

  • Physical security – Lockup server room

    http://www.youtube.com/watch?v=z0Npw0SbL6Y&feature=related


Ethical issues

Ethical Issues

  • Privacy & Security

    • When collecting any personal data - company must published a “privacy policy” to explain how they will use the data.

  • Inappropriate use of data

    • Computer operators, programmers, and other personnel are in positions where they could easily misuse data, if they choose to act unethically. This is known as hacking.

    • Employee always sign a “Code of conduct”


Past current and emerging

Past, current and emerging

1950s– Flat File data

1960s – Hierarchical data structure (Directory structure)

1970s – Relational DBMS (Berkley UC, and IBM DB2)

(Ted Codd from IBM)

1980s – Object DBMS

1990s and now– Relational and object DBMS


Logical structure flat file

Logical Structure – Flat file


Relational database

Relational Database


Database management systems dbms

Database Management Systems(DBMS)

  • Allows you to:

    • Organise data - by applying rules for the set of data (data dictionary for validations)

    • Add, update, and delete records (form)

    • Locate, sort & manipulate data (SQL – query)

    • Display data (report)

    • Control security and data integrity (management).


Data handling

Data Handling

  • Data types

    • Text, Memo

    • Number, Yes/No,

    • Checkbox,

    • Date, Currency,

    • Link, Images, and objects

  • Data dictionary – Rules of database

    • Name of fields

    • Type of data

    • How many character

    • Special features


Special fields relational db

Special Fields – Relational DB

  • Primary Key - Uniquely identifies the contents of a particular table. Most table have a primary key.

  • Foreign Key - A special identifier, that allows relationship to form between two tables.


Design process1

Design Process

Collecting of raw data.

Favourite Music :

Artist Name

DOB

Genre

Song Name

  • Data Dictionary

  • ArtistID number

  • ArtistName text

  • DOB date

  • Genre list

    • Pop

    • Jazz

    • Classical

  • SongID number

  • SongName text

  • Lyrics memo


  • Database inputs gigo

    Database inputs - GIGO

    • Data sources

      • acknowledge data sources

    • Validation checks

      • check against data dictionary

    • Verification checks

      • typo and incorrect value – manual validation.


    Database output

    Database Output

    List/Table

    Report

    Form

    Query


    Design process2

    Design Process

    Collecting of raw data.

    Favourite Music :

    Artist Name

    DOB

    Genre

    Song Name

    • Data Dictionary

    • ArtistID number

    • ArtistName text

    • DOB date

    • Genre list

      • Pop

      • Jazz

      • Classical

  • SongID number

  • SongName text

  • Lyrics memo

  • Query

    Form

    Report


    Structured query language sql

    Structured Query Language (SQL)

    List all artists and songs with a pop genre.

    SELECT

    [Artist].[ArtistName], [Songs].SongName, [Song].Lyrics

    FROM [Songs] ,[Artist]

    WHERE

    ((([Genre].GenreName)=“pop"));

    Order by ArtistName


    Dbms software

    DBMS Software

    • Common desktop databases:

      • MS Access (only for PCs)

      • File Maker Pro (both Macs & PCs)

      • MySQL

      • Oracle

    • Online databases

      • Zoho DB - http://www.zoho.com/creator/pricing.html


    Homework

    Homework

    Database Online Quiz

    http://ict-stage5.wikispaces.com/


    Activity fighting crimes

    Activity – Fighting Crimes

    Using queries to solve crimes with MS Acess

    Please go to:

    http://ict-stage5.wikispaces.com/

    Click on >>> Database activity


    References

    References

    • Betts, G. (2007). DBMS (Database Management Systems) Retrieved 10 May 2011, from http://www.bettscomputers.com/dbms.htm

    • Clark, A. (2010). Database software, from http://www.ictgoodies.com/tags/databases

    • Jones, D. (2002). Teach-ICT Retrieved 27/04/2011, 2011, from http://www.teach-ict.com/as_a2/topics/databases/databases.htm

    • Ware, P. (2005). IST: Information and software technology 7-10. Milton, QLD: John Willey.

    • Zoho. (2011). Zoho Report Retrieved 5 May 2011, 2011, from http://reports.zoho.com/login/login.jsp

    • Learning from Databases: Using Existing Online Databases - http://edweb.sdsu.edu/courses/edtec570/lfd/dblist.htm


  • Login