Database design
Download
1 / 25

Database Design - PowerPoint PPT Presentation


  • 77 Views
  • Uploaded on

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Database Design' - clarke


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




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


    ad