IMS506 Group PROJ MAC-OGOS2021 PDF

Preview

Summary

ODL IMS506: MAC-OGOSIMS506 GROUP PROJECTA. DBASE DESIGN (20%) (Refer to template ) .................................................................................................................................Marks DATABASE PROJECT TITLE 1 Students’ name, lecturer’s name, affiliation and email.AB...

Description

ODL IMS506: MAC-OGOS2021 IMS506 GROUP PROJECT A. DBASE DESIGN (20%) (Refer to template ) …………………......................................................................................……………….... Marks DATABASE PROJECT TITLE Students’ name, lecturer’s name, affiliation and email. ABSTRACT

1

2

CONTENT 1.

INTRODUCTION

2

2.

BUSINESS ACTIVITIES / PROCESS

2

3.

PROBLEM STATEMENT

2

4.

OBJECTIVES

2

5.

BUSINESS RULES

4

6.

ENTITY RELATIONSHIP DIAGRAM (ERD)

4

7.

CONCEPTUAL ERD

5

8.

NORMALIZATION

5

9.

RELATIONAL DIAGRAM

5

10.

DATA DICTIONARY

5

11.

CONCLUSION

2

12.

LIMITATION & FUTURE ENHANCEMENT

2

13.

REFERENCES

2

TEAM WORK

5 TOTAL MARKS

50

B. DBASE DEVELOPMENT (20%) …………………......................................................................................……………….... MySQL PhP Admin 1.

Marks

Tables and Attribute Definition

10

(at least 5 tables with sufficient sample data) 2.

Relationship Diagram

10

3.

MySQL

20

(at least 10 Queries with ouput ) 4.

Interface/Form for INSERT data and RETRIEVE data

TEAM WORK

5 5

TOTAL MARKS

50

TEMPLATE OF DBASE DESIGN

< DATABASE DESIGN OF ……………….. >...