LANGKAH-LANGKAH MEWUJUDKAN PANGKALAN DATA

• To start the Microsoft Access.

1. Click on the START BUTTON.
2. Point cursor at ALL Programs in the START MENU.A menu with list application software is display.
3. Move cursor to Microsoft Office and click on.
4. Click on the Microsoft Access 2003 in the list of programs.

• The three main window displays under the Getting Started task pane are:

1. Microsoft Access Office Online.
2. Open of the existing database-files and
3. Create a new database.

TITLE BAR : contains the control icon, the name program, minimize, maximize, restore  and close button.

MENU BAR : a set of options the little bar that lead to associated menus.

TOOLBAR : display button, which provide short cuts to menu.

  *  To create a new database.

1.     Click on file button.

2.     Click on new button.

3.     Select BLANK DATABASE on the new file task pane or press( CTR-N)

4.     Task name group in file name.

 


*Click table and design view.   

*TABLE

a)It stories information about special topic: DOCTOR,  PATIENT,

REGISTRATION, TREATMENT.

--> Size DOCTOR.

DocNO :text(4)

DocName : text (50)

TypeofSick : text(150)

Price :number( long integer)

MC :yes/no

TreatID:text (4)   

-->Size PATIENT.

PatientNo: text(4)

Name: text(50)

Address:text (100)

NoTEL:number( long integer)

Mobile:number( long integer)

RedID: text(4)

-->Size REGISTRATION

RegID: text(4)

RdIC: text(12)

RegDATE:

-->Size TREATMENT.

TreatID: text (4)

TreatDate: date/time

PatienNO: text(4)

*Click RELATIONSHIP and between 4 table.

*RECORD AND FINISH.

FIRST ASSIGNMENT DADD. :)

1st assignment had arrived last week and i'm thinking about how am i gonna do it.
Well, I'm using Microsoft Access 2003 :)




in chapter 2:)

CHAPTER 1 DADD.

• DATA:consists of facts,text,graphic&figure that can be recorded& that have implicit meaning
•    INFORMATION:data that have been processed&being made to be useful for user or decision makers.

a)DATA HIERARCHY.

• for the data hierarchy ,perfomed from top-down& the left to right.
• eg:student node first then follow by these nodes
• names,ic,age,student id,adderess,college-branch.

b)DATA HIERARCHY IN A DATABASE SYSTEM.

• BITS-BYTES-FIELDS-RECORDS-FILES-DATABASE.
• EG:

1. BITS:0 (OFF) OR 1 (ON).
2. BYTES:letter,dgit /8 bits=1 bytes.
3. FIELD:character (bytes)., column of data,contains the same type of data item.
4. RECORDED: full set of data in the row,name,address of a person.
5. FILES:collection of relation recorded.
6. DATABASE:collection of related filer or table.

• DATA TYPE.

1. TEXT:text field can be from 1 to 255 character ling.
2. NUMBER: *INTEGER:a two-byte whole number from-32,768 to 32,767. EG:0,+1,-1.
3. *REAL:decimal places. EG:1.5cm,48.4kg,RM20.10,36.7.
4. BOOLEAN:2 bytes true or false.
5. CURRENCY:dolar sing are automatically added. EG:$2000.00
6. DATE/TIME: for the year 100 throug 9999.

• TRADITIONAL FILE PROCESSING.

1. PERSONAL DEPT= employer.
2. SALE DEPT=customer.
3. ACCOUNTING DEPT=sales.

• DISADVANTAGE OF FILE BASED APPROACH.

1. DUPLICATION OF DATA: some data is help by different program 7 stored in several location.

• DATA INTEGRITY PROBLEM: files are stored within each application program that access  a given that.
• LIMITED DATA SHARING: private files   7 user have little opportunity to share data outside their own application.

DEFINITION OF DATA BASE.

collection of related data,design to meet the information needed in an organization and stores it in one specific.

DEFINITION OF DATABASE MANAGEMENT SYSTEM(DBMS).

DBMS is a collection of programs that enable user to create and maintain a database in an organization & stores it in one specific location.

• USER--> APPLICATION-->DBMS---> student database,lect database, greed database.

ADVANTAGE OF DATABASE APPROACH.

a) minimal data redundancy.

b) sharing of data.

c)economy in distributing database.

d) improved data consistency.

EVOLUTION OF DATABASE.

a)1960 s= traditional files.

b)1970 s= hierarchical / network

c)1980 s=relational.

d)1990s = object oriented / object relational.

d)2000s = data mining / data warehousing.

a)1960 :file processing system were still dominat during his period. 

b)1970 : * HIERARCHICAL DBMS MODEL; 

it was use commonly for business information.

    *NETWORK DBMS MODEL.

it use physical file pointer to model the relations between files.

   *RELATIONS DBMS MODEL.

it was introduction by E.F CODD and other.

c)1980 : RELATIONAL MODEL(by E.F. CODD,1970)

become the second generation of DBMS.

d)1990 :OBJECT-RELATIONAL DATABASE(ORDB)

due to the advancement of the client 7 internet computing technology &the popularity of the multimedia data.

e)2000 :THE data warehouse, THE universal server, THE distributes database, THE content-appreciable storage, COMBINATION of database &other technology.




CHAPTER 2.

• Step open Microsoft Access 2003.
• Create database,name database,location database.
• Create table in design,field name,data type,field size,list all field properties.
• description,add primary key,insert delete row,data sheet view.
• design  view and show to highlight row.
• Create table  using wizard,personal.
• ><
• finish.
• :):):):)

WEEKLY REFLACTION 1 IN DADD.

1/2/2011

• Introduction self.
• Buat group & setiap group ada 4 org.
• Name group: INTELENGTSIA TECH.
• Motto: kreatif, ivolusi & berwawasan.
• PENERANGA CHAPTER 1:DATA VS INFORMATION.
• DATA: facts,text,graphic&figure.
• INFORMATION:data have been processed& being made to be usefull for user.
• DATA TYPE:text,numeric,boolean,currency,date/time.
• FILE SYSTEM VS DATA BASE SYSTEM:

1. non-computerize system
2. traditional file Processing Approach.
3. DEFINITION ON DATABASE:collection of related data,designed to meet the information needed in an organisation&stores it in one specific location.

• ELEMENT DATABASE:user data,meta data,indexes,application metadata.
• ADVANTAGE: minimal data,sharing data,economy in distributing database,improved data consistency.

enjoy in this chapter :)






WEEKLY REFLECTION 2 (DADD)

• Study mengenai microsoft office access dalam cara membuat DATABASE DESIGN TOOLS.
• First,open microsoft office accessand click creat new file and click blank database.
• put name file and cliak create table in Design view.
• Type and list about:DOCTOR,PATIENT,ACCOUNT,REGISTRATION AND TREATMENT and save.
• Do the RELATIONSHIPS, and finish....
• :):):):)best and enjoy.