1 / 26

Databases

Databases. Database. A database is an organized collection of related data. Types of Databases. There are manual databases and computerized databases. Manual Database.

channing-snow
Download Presentation

Databases

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

  2. Database • A database is an organized collection of related data.

  3. Types of Databases • There are manual databases and computerized databases.

  4. Manual Database • In a school, a filing cabinet in which student paper based files are placed within manila folders which are filed away in a particular order within the filing cabinet, is a common example of a Manual Database.

  5. Manual Database • If you draw up a table in your book to keep track of your monthly expenses this is an example of a simple paper based (manual database).

  6. Manual Database • Table of monthly expenses

  7. Computerized Databases • A Computerized database is created and managed on a computer system using a software called a Database Management System (DBMS).

  8. DBMS • A set of programs that allows the creation of data files and the alteration, extractioin and deletion of data within these files. • Eg. Access., Oracle, MySQL, Ms FoxPro, Dbase, SQL Server.

  9. Types of DBMSs • The most common types of DBMSs are Relational DBMSs and Object Oriented DBMSs.

  10. Relational Database • Relational DBMSs are the most common type and are used to create Relational databases. • A relational database is one in which the data is stored in the form of a table/s with rows and columns. Each table should contain data about one particular subject alone. • All the above named DBMSs are examples of Relational DBMSs.

  11. Object Oriented Database • An Object Oriented DBMS is one in which the data is stored in the form of a set of interacting objects, this type of DBMS is not very common at this time.

  12. Student Table Field Records

  13. Field • A column in a database table that contains data on ONE specific data item only.

  14. Record / Tuple • A row in a database table that consists of a group of related fields.

  15. Primary Key • Each table must contain a field that uniquely identifies each record in a database. • In normal life persons are also assigned unique identifiers e.g. birth certificate number, id card number, credit card number, car license plate etc.

  16. Student Table Redone

  17. Data type • The data type is the type of data that can be permitted for a particular field.

  18. Field Size • The amount of data can be entered into a particular field.

  19. Class Exercise • You own a video club. Create a database to store data on movies and customers.

  20. Foreign Key • This is the primary key of a table placed into another table, so as to create a link between the two tables.

  21. Import • When data is imported into a database, the data from one file is inserted into the database. • Data can be inserted from several formats: excel, access, comma delimited text files, tab delimited text files.

  22. Question • Import the files ExcelData and CommaData, into the database table Customers

  23. Export • When data is exported into a database, the data from a database table is sent to another file format.

  24. Question • Export the Movie table as a Rich Text format into My Documents.

  25. Query • A query allows the user to ask the database questions about the data within the tables or allows changes to be made to the tables and the data within the tables.

  26. Query types • Select Query: This is used to ask the database questions about the stored data within the tables. • Update Query: Makes changes to records in the tables. • Adds groups of records from one table to another. • Deletes records from a table.

More Related