1 / 20

Fundamentals of Database

Fundamentals of Database. CVSL Grade VII & VIII. Topics to be covered . “ what is a database;” Understand the difference between data and information; What is the purpose of a database system; Database definitions and fundamental building blocks;. What is a database.

cheung
Download Presentation

Fundamentals of Database

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. Fundamentals of Database CVSL Grade VII & VIII

  2. Topics to be covered • “what is a database;” • Understand the difference between data and information; • What is the purpose of a database system; • Database definitions and fundamental building blocks;

  3. What is a database A database is any organized collection of data.Some examples of databases you may encounter in your daily life are: • a telephone book • T.V. Guide • airline reservation system • motor vehicle registration records • Forms you are filling for Admission

  4. Data vs. information:What is the difference? • What is data? • Data can be defined in many ways. Information science defines data as unprocessed information. • What is information? • Information is data that have been organized and communicated in a coherent and meaningful manner. • Data is converted into information, and information is converted into knowledge. • Knowledge; information evaluated and organized so that it can be used purposefully.

  5. What is the ultimate purpose of a database management system? Is to transform Data Information Knowledge Action

  6. Why do we need a database? • Keep records of • Students • Staff • Library • Stocks • To keep a record of activities and interventions; • Keep sales records; • Develop reports; • Perform search • Tracking a particular record

  7. Example of Database • Ms Access • FileMaker • Lotus Notes • Oracle • SQL Server

  8. What is the purpose of the database ? • A database management system (DBMS) provides you with the software tools you need to organize that data in a flexible manner. • It includes tools to add, modify or delete data from the database, ask questions (or queries) about the data stored in the database and produce reports summarizing selected contents.

  9. Some Important Definitions • A File: A group or collection of similar records, like Student File, American History 1850-1866 file, Basic Food Group Nutrition File • A field: one category of information, i.e., Name, Address, Semester Grade, Academic topic • A record: one piece of data, i.e., one student's information, a recipe, a test question • A layout: a design for a database that contains field names and possibly graphics.

  10. Fundamental building blocks Tables comprise the fundamental building blocks of any database.  If you're familiar with spreadsheets, you'll find database tables extremely similar.  Take a look at this example of a table sample database: The table above contains the employee information for our organization -- characteristics like name, date of birth and title.  Examine the construction of the table and you'll find that each column of the table corresponds to a specific employee characteristic (or attribute in database terms).  Each row corresponds to one particular employee and contains his or her information.  That's all there is to it!  If it helps, think of each one of these tables as a spreadsheet-style listing of information.

  11. What is Microsoft Access Used For? Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.  Microsoft Access can help you overcome the limitations found when trying to manage large amounts of information in Microsoft Excel or other spreadsheet applications.

  12. What is Microsoft Access made up of? • The Microsoft® Access Database is made up of 7 major components: • Tables; • Relationships; • Queries; • Forms; • Reports; • Macros; • Modules.

  13. Tables • The tables are the backbone and the storage container of the data entered into the database. • The tables that contain data look a bit like a table in Microsoft® Word or a Microsoft® Excel Spreadsheet, when opened. They have columns and rows as does a table in Microsoft® Word and an Excel worksheet. Each of the columns will have a field name at the top and each of the rows will represent a record. • As an example:

  14. Primary Key • The primary key of a relational table uniquely identifies each record in the table. • This can be a unique identification number such as a Medicare number, Employee ID number, Pension number, etc.: • A primary key cannot contain duplicate values, e.g. a person’s last name is not suitable as a primary key as there is often more than one person with the same last name; • A primary key cannot contain null values, therefore a field such as a phone number is not suitable, as you may not know the person’s phone number when you first enter them into the database; • Also, if the information contained in the Primary Key is likely to be altered, then it is best to avoid this field as well. • If a unique identifier cannot be identified (which is more than likely), you can add a field, which will automatically increase sequentially by one, thus providing the record with a unique identifier.

  15. Data type • The data type of a programming element refers to what kind of data it can hold and how that data is stored. Data types apply to all values that can be stored in computer memory or participate in the evaluation of an expression. • Example • Name – hold alphabets • Marks – number

  16. MS ACCESS DATATYPES • AutoNumber    Numbers that are automatically generated for each record. • Currency    Monetary values. • Date/Time    Dates and times. • Hyperlink    Hyperlinks, such as e-mail addresses. • Memo    Long blocks of text and text that use text formatting. A typical use of a Memo field would be a detailed product description. • Number    Numeric values, such as distances. Note that there is a separate data type for currency. • OLE Object    OLE objects, such as Word documents. • Text    Short, alphanumeric values, such as a last name or a street address. • Yes/No    Boolean values.

  17. You can view your Microsoft Access tables in two different views - Datasheet view and Design view. • Datasheet view : Access allow you to view the contents of a table. When opened, you will see something similar to a spreadsheet, with columns of data with the field names identifying each column, whilst each row is a single record within the table. This is called the datasheet view. • 'Design view' where you see the structure of the table rather than the contents. It shows the field names and their datatype. From design view you can add and delete fields within the table, although you have to be careful with deleting the primary key in the table as that would cause problem with data integrity.

  18. Query • A query is a request for information from a database which matches a set of criteria. • You use queries all the time when you use a search engine such as Google. You type in the term that you want some information about and click 'search'. The search engine looks through its database and displays a list of results which match the term that you used.

  19. Other objects of Ms Acess • Forms provide non-technical users the ability to add data to your database. • Reportreport is a document (paper or electronic) that presents data in an easy-to-read, professional format. Reports can be created within database applications such as Access. In this case the results of database queries are presented in an attractive format, with headings, fonts and colours designed to enhance understanding of the data. • A "macro" refers to a set of actions that can be run automatically, and on demand. You could make a macro run when a user presses a certain key, or you could make a macro run everytime your database is opened. • Module A module is a collection of user-defined functions, subroutines, and global variables written in VBA code. These objects can then be used/called from anywhere in your Access database.

  20. Thank you

More Related