1 / 25

Database Design

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

clarke
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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Database Design Presenters: Nicolas Lee Tam Nguyen

  2. 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

  3. Let’s do a quick survey .... About Music Your favourite artist..... What type of music Genre ...... Name some of their songs ...... Country of birth .....

  4. Design Process Collecting of raw data. Favourite Music : Artist Name DOB Genre Song Name

  5. 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

  6. Computerised or not? • Advantages • Disadvantages • Computerised databases?

  7. 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

  8. 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

  9. 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”

  10. 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

  11. Logical Structure – Flat file

  12. Relational Database

  13. 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).

  14. 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

  15. 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.

  16. 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

  17. Database inputs - GIGO • Data sources • acknowledge data sources • Validation checks • check against data dictionary • Verification checks • typo and incorrect value – manual validation.

  18. Database Output List/Table Report Form Query

  19. 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

  20. 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

  21. 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

  22. Homework Database Online Quiz http://ict-stage5.wikispaces.com/

  23. Activity – Fighting Crimes Using queries to solve crimes with MS Acess Please go to: http://ict-stage5.wikispaces.com/ Click on >>> Database activity

  24. 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

More Related