110A lect 7 access tables

110A lect 7 access tables - Access Lecture 1 Database...

Info iconThis preview shows pages 1–8. Sign up to view the full content.

View Full Document Right Arrow Icon
Access Lecture 1 Database Overview and Creating Tables Create an Employee Table
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Why database for 110A Because businesses generate a lot of data What are some ways in which businesses use data they collect? Data is needed to generate meaningful information The bottom layer of a three tiered app You’ll be more prepared for BUS112 So it is important to have working knowledge of databases.
Background image of page 2
Overview of Access What is a database? A collection of related tables. The SJSU student database has many tables. Some table it might include are: Students personal information table with your name, contact information and student ID Transcripts table WST status
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Components of a Database Field (aka column, attribute): Several Characters (e.g. Name) Record (aka row): Several Fields (e.g. your school record) Primary key: Unique identifier for the record (e.g. SSN) Table: Group of records e.g. (my class record). Database: Group of related tables
Background image of page 4
An example of data stored in a database table
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Different DBMS available in market? Oracle , DB2 , Microsoft Access , Microsoft SQL Server , Firebird , PostgreSQL , MySQL , SQLite , FileMaker and Sybase Adaptive Server Enterprise (From Wikipedia – Click on link to read more) For this class we focus on MS Access (2007) but you will learn a bit about SQL queries as well.
Background image of page 6
Let’s look at one… This is a student database…Called Our_students_in_class_exercise
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 8
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2010 for the course BUS 110A at San Jose State University .

Page1 / 23

110A lect 7 access tables - Access Lecture 1 Database...

This preview shows document pages 1 - 8. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online