Ie 423 design of decision support systems
This presentation is the property of its rightful owner.
Sponsored Links
1 / 26

IE 423 – Design of Decision Support Systems PowerPoint PPT Presentation


  • 48 Views
  • Uploaded on
  • Presentation posted in: General

IE 423 – Design of Decision Support Systems. Database development – Building Tables. http://crimethinc.com/blog/wp-content/uploads/2007/02/table5big.jpg. Important Dates to Remember. St. Patrick’s Day – March 17 th. By now you should have. Read Chapters 1,2,3, 4, 5 and 6 in Pol and Ahuja

Download Presentation

IE 423 – Design of Decision Support Systems

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Ie 423 design of decision support systems

IE 423 – Design of Decision Support Systems

Database development – Building Tables

http://crimethinc.com/blog/wp-content/uploads/2007/02/table5big.jpg


Important dates to remember

Important Dates to Remember

St. Patrick’s Day – March 17th


By now you should have

By now you should have

Read Chapters 1,2,3, 4, 5 and 6 in Pol and Ahuja

Also, read chapter 7 in Pol and Ahuja


Database development

DataBase Development

We are going to skip an important topic

Normalization

…but, will get to this topic very soon


Database development1

DataBase Development

Remember that our earlier modeling efforts resulted in the creation of schemas

In our modeling we defined entities, relations and relationships

In DB development we are interested in

Defining the entities = Tables

…and their attributes = fields

…and the relationships among tables

Later we will add data to create instances = records


Database development2

DataBase Development

In its native form a table is a data grid with –

Columns (fields)

Rows (records)

Fields have properties

Records represent instances of the entity


Database development3

DataBase Development

Start Access

Either open an existing DB, or…

Create a new DB


Database development4

DataBase Development

Create a new DB

Select Blank database

Then define the name and location for the DB file


Database development5

DataBase Development

Four ways to create a table

Create a table in Datasheet view

Create a table in Design view

Create a table with the Table Wizard

Create a table while importing external data


Database development6

DataBase Development

Create a table in Datasheet view


Database development7

DataBase Development

Create a new DB

Next you should see something like this….

Make the Table Object is selected, then

Select Create table by entering data


Database development8

DataBase Development

Create a table in Datasheet view

Enter the field names at the top of the columns

Click close (X) when finished defining the fields

You will asked if you want to save the table definition…

If you click yes you will be prompted for a name for the table


Database development9

DataBase Development

Create a table in Datasheet view

… you will also be told that the table has no primary key,…

And you will be asked if you want Access to create one for you

This is important –

but click No for now


Database development10

DataBase Development

Create a table in Datasheet view

Note: we have a new Table object (People)


Database development11

DataBase Development

Create a table in Design view

Creating a table in datasheet view is easy, but…

It leaves a lot not done

For example, each field has a set of properties, and we have not defined them


Database development12

DataBase Development

Create a table in Design view

Lets create a table to store data about houses

Click create table in Design view

…and you will see something like this


Database development13

DataBase Development

Create a table in Design view

Note our field definition panel (top) needs three things –

Field Name

Data Type

Field Description


Database development14

DataBase Development

Create a table in Design view

Naming rules

Max 64 Characters long

Any combination of Letters,numbers spaces, except

Control characters (ASCII 0-31)

Period(.), Exclamation Point (!), Grave (`), Brackets ([])

Leading spaces

Quote marks

Remember CamelBack notation

Leszynski Naming conventions

( from:http://www.acc-technology.com/namconv.htm )

TablestblXxxxXxxx

QueriesqryXxxxXxxx

FormsfrmXxxxXxxx

ReportsrptXxxxXxxx

MacrosmcrXxxxXxxx

ModulesbasXxxxXxxx


Database development15

DataBase Development

Create a table in Design view

Field Types

Text – max 255 characters (default)

Number – storing numeric data – several specific numeric types (field size*) – 1,2,4,or 8 max 16 bytes

Long Integer(4), Integer(2), Byte(1), Single(4), Double(8), ….

Autonumber – automatically adds a unique number to record

Incremental

Random


Database development16

DataBase Development

Create a table in Design view

Field Types

Date/Time – to store date and time values

Memo – similar to Text except allows very long lengths (65,535 max)

Yes/No – Boolean values

Currency – values represent money

OLE object

Hyperlink – Internet address

Lookup Wizard – we’ll come back to this


Database development17

DataBase Development

Create a table in Design view

So, let’s build a table for Houses

By the way, try to make it a good design!

?


Database development18

DataBase Development

And don’t forget –

Define the table’s Primary Key


Database development19

DataBase Development

MS Access Table Limits


Database development20

DataBase Development

MS Access Reference Card

From

http://www.wcu.edu/it/edtech/handouts/access_2003_quick_reference.pdf


Database development21

DataBase Development

MS Acess Help and Tutorial from Microsoft

http://office.microsoft.com/en-us/access/CH062526191033.aspx


  • Login