aiseries Microsoft Access New Edition By Asif Iqbal

aiseries

Microsoft Access New Edition By Asif Iqbal aiseries

Grading S. No Graded Activity Exam place Marks 1 Paper (Theory) External 50 4 Practical Internal 100 gtvc. eu 5. org aiseries

Grading Marks Distribution gtvc. eu 5. org aiseries

Lecture - 01 gtvc. eu 5. org aiseries

Data (Definition) Data is a plural form of the Latin Word Datum. Meaning “those that are given” The Collection of raw facts and figures is called data. Example may include Name, Address, Number, Phone Number, Roll No etc gtvc. eu 5. org aiseries

Data (Types) Alphabetic Data Type: It consist from A-Z or a-z like Peshawar, Pakistan, Adnan Numeric Data type: It consist of digit from 0 -9 e. g 123, 567 etc Alphanumeric data type: It consist alphabetic letter as well as numeric digit. Street A/10 etc Graphic Data: It consists tables, charts, graphics Audio data: It consists only sounds. For example: radio waves Video Data: It consists photos, image and moving picture. TV Mixed Data: It consists more than one type of data. Such Combination of any two types of data. gtvc. eu 5. org aiseries

What is Database? gtvc. eu 5. org aiseries

Database (Definition-1) A database is a shared collection of logically related data that is stored to meet the requirements of different users of an organization gtvc. eu 5. org aiseries

Database (Definition-2) A database is a self-describing collection of integrated records gtvc. eu 5. org aiseries

Database (Definition-3) A database models a particular real world system in the computer in the form of data gtvc. eu 5. org aiseries

Electronic Database (Uses) Reduce duplication of data Integrate and shared data User can easily retrieve data from the database of their need Data is secured in so many layers Data modification and updating is controlled by DBA Data Dictionary control schema (Structure) gtvc. eu 5. org aiseries

Database (Concepts) Entity: An entity is any object in the system that we want to model and store information about. E. g: Student, City, Book, Employee, Product. Attribute: The Characteristic of an entity or the column of a table is called Attribute. E. g: Pro. Name, Price, quantity Characters 1: The smallest piece of information is called character. E. g: A-Z, a-z, 0 -9, + & * # ! ) @ ^ ( 1 Obsolete Concept gtvc. eu 5. org aiseries

Database (Concepts) Filed: An Element in which one piece of information is stored. E. g Name, city, ph. No, price Records: Combination of related fields. E. g Admission Record, Employee Salary Files: Combination of related records. Tuple: A single row of a table, which contains a single record for that relation is called a tuple. gtvc. eu 5. org aiseries

Database (Concepts) Fields Student Table (Entity) Records gtvc. eu 5. org aiseries

Lecture 01 (Summing Up) gtvc. eu 5. org aiseries