LESSON 61
IMPLEMENTATION PHASE
The Implementation Phase is the third phase of system development.
The Implementation Phase is the phase where a system is created.
CREATING DATABASE
In this phase, a system developer uses database software such as Microsoft Access as the development tool to create a Scholl Resource System.
CREATING TABLES
You can use Design View to create tables to store data. You are to create four tables: Author, Book, Publisher and Category for the School Resource System.
ASSIGNING TABLE RELATIONSHIP
Referential Integrity is a set of rules that ensures relationships between Tables within a database are all valid.
CREATING QUERIES
CREATING FORMS
You can use Forms to perform data entry and retrieve related data.
CREATING REPORTS
You can use Reports to summaries information from the database.You can create new Report using wizard.
You can use Reports to retrieve information from the database using Table or Query.
EXTENSION : TYPES OF RELATIONSHIP
One-To-One
For example, each member has only one address record.
One-To-Many
For example, each book has only one category. Each Category has many books.
One-to-one relationships happen when there is only one record in Library Member to another one record in Member Contact.
One-to-many relationships happen when each record in Book Category has many related records in Book.
In the Implementation Phase, the system developers will convert the technical plan and design plan into a computer program.
