project นี้เป้นวิชาdatabaseครับช่วยหน่อยน่ะครับพี่ๆ (project อาจารย์กำหนดว่าต้องเขี้ยนในmicrosoft access ครับ)

ข้างล่างนี้คือ รายละเอียดของงานproject ครับ:

SDII CONSULTING (M) BHD: PROJECT CLIENTS & STAFF MANAGEMENT
DESCRIPTION :-
SDII Consulting provides consulting services to clients. Each service is treated as a project. Each project is handled by assigned staffs and a project will be documented accordingly. A project may has many time sheets that been recorded by a staff. This database should be able to produce report such as who is working on a specific project, member of a specific project , and etc…
A. PURPOSE OF THESE FACTS :-
These FACTS define the functional requirements which the Database must meet.
The Draft FACTS have been defined and are detailed here ...
B. The Things of Interest, ('Entities/Objects'), include :-
B.1 Addresses
B.2 Billable Hours
B.3 Clients
B.4 KPIs (Key Performance Indicators)
B.5 Projects
B.6 Project Documents
B.7 Staff

C. These THINGS_OF_INTEREST are Related as follows :-
C.1 A CLIENT can have one or many ADDRESSES. For example, operating from many locations.
C.2 A CLIENT can have zero, one or many KPIs. For example, a KPI of 3 PROJECTS a year.
C.3 A CLIENT can have zero, one or many PROJECTS
c.4 A PROJECT can have many STAFF.
c.5 A PROJECT can have many DOCUMENTS.
c.6 A PROJECT DOCUMENT is always owned by a member of STAFF.
C.7 STAFF can have zero, one or many BILLABLE HOURS.
C.8 STAFF can have zero, one or many KPIs.
C.9 STAFF can work on many PROJECTS.
C.10 STAFF have zero, one or many SKILLS.

D. Sample Data includes :-
Determine by the group (not < 25 records)


E. Typical Enquiries include :-
E.1 Which PROJECTS is a specific member of STAFF working on ?
E.2 Who is working on a specific PROJECT ?
E.3 Document owner (staff)
E.4 Staff performance according to their respective KPIs.


F. Attribute/Domain
Use your own assumptions and do state any assumption you have make in your report.

Suggested Content of Your Report:
1. Introduction
1.1 objective
1.2 Scope
1.3 Assumption and Constraints
1.4 Abbreviation
2.0 Literature
3.0 Database Methodology
4.0 Database Analysis
5.0 Database Design
5.1 Conceptual Design
5.2 Normalization
5.3 Logical Design
5.4 Physical Design
6.0 Sample of queries
7.0 References
8.0 Appendix (including your ppt slide, & prototype)

ขอบคุณครับ