Database Bu5010
Class notes
013107

today's topic:

Module 1 : Review assignment  (due 2weeks from Jan24 Wed Feb07)

Due Date: Feb. 7th

Build a database with an interface, using a file system.

A database consists of many files

Files consists of many records

Records consists of many fields (a row is a record)

Fields consists of many characters (fields should have a maximum number of) characters

(refer to chapter 9)

Interface contains the following:

A) Name and purpose of the database

B) Insertion- add a record

Suggested Databases:

• Student database
• Inventory database
• Bank database   
• Supermarket database
• Insurance database
• Graphic/Games tutorial database
• Login account database
• Others

As per Sakinah's suggestion:

**Your database should deal with security and privacy on all levels**

Dr. Ebrahimi prefers team work

Each team member must be aware of all the work

Questions:

1. What is a database?
2. Give some examples of databases?
3. What is DBMS?
4. What is a record?
5. Should passwords be stored?
6. Should username or password be the same as first, last name or a combination of the two?
7. Why should passwords be alphanumeric?
8. What is ASCII?
9. What is unicode? Unicode is 8 - 16 bits
10. In ASCII; how is 32 shown in bits? 00000000 - (exam question t/f) _T_
    ASCII for "null" is 0.

15% of your grade comes from participation and class contribution
Participation in 15 classes  will result in automatic 15%

Binary manipulation:

0000010 = 2
0000100 = 4
0001000 = 8
0010000 = 16
00100000 = 32
01000000 = 64 = @ in ASCII (Akibu's contribution)
01000001 = 65 = A in ASCII  (Sharmin's contribution)

Binary arithmetic doesn't have number 2
 

Note: Invite Scott Bell to class or computer club event

5pts for initiating an invite

POST YOUR POINTS ON GEOCITIES