Uploaded by User95548

project kel 7

advertisement
FUTSAL ARENA
1CC5
THORIQ
MUHAMMAD NAUFAL AULIA
MUHAMMAD FAHRUL ROZI
Faculty of Engineering
University of Indonesia
PROJECT ON
Futsal Arena
Developed By
Name
: Thoriq
Muhammad Naufal Aulia
Muhammad Fahrul Rozii
Reg. No :
NIIT
FUTSAL ARENA
Batch Code
:
Start Date
: December
End Date
: December
Name Of The Coordinator
: Kevin Harada
Name Of Developer
: Thoriq
Muhammad Naufal Aulia
Muhammad Fahrul Rozi
: December
Date Of Submission
NIIT
CERTIFICATE
This is to certify that this report, titled Futsal Arena, embodies the original work done
by Thoriq Muhammad Naufal Aulia, Muhammad Fahrul Rozi in partial fulfillment of his
course Requitment at NIIT.
Coordinator: MR. Kevin Harada
ACKNOWLEDGEMENT
We have benefited a lot from the feedback and suggestions given to us by Kevin Harada
and other faculty members. The Project presentation opportunity we have with CCIT-FTUI
is a greatchance for learning and professional development. Therefore, we consider
ourselves very lucky as we are provided with an opportunity to be a part of it. We are also
grateful for having a change to meet so many wonderful people and professionals who led
us through this project period.
Bearing in mind, we would like to express our deepest gratitude and special thanks to
Mr.Kevin Harada of CCIT-FTUI faculty who is spite of being extraordinarily busy with his
duties, took time out to hear, guide and keep us on the correct path and allowing us to carry
out our project until completion.
Our Project assignment won’t be as good as it is now without any help, feedback and
suggestion that were given to us by our friends within the campus. So, we would also like to
say thank you to all of them. We will strive to use gained skills and knowledge in the best
possible way, and we will continue to work on the improvements, in order to attain desired
carrer objective.
SYSTEM ANALYSIS
Rental Futsal Arena is a large event management company of Depok City. The company
organizes various types of rented.
The management of Futsal Arena have realized that it is dificult to maintain so much data
manually. Therefore, they invented some data systems to facilitate the work. Features
provided is a function and many functions as a provider of output data that has been
processed by the system. So that all activity in the company can be conveyed easily and
reduce the risk of data error.
ENTITIES
Number Of Entities: 5
Names Of Entities:
1.
Customer
2.
Employee
3.
Transaction
4.
Field
5.
Schedule
ATTRIBUTES
Attributes:
The Various Entitles and their attributes are listed in the following table:
Entities
Customer
Employee
Tansaction
Field
Schedule
Attributes
ID_Customer
Customer_Name
Team_Name
No_Phone
ID_Employee
Employee_Name
Address
Gender
No_Phone_Employee
ID_Transaction
Date_Transaction
ID_Field
Price
Quantity_(Hours)
Total
ID_Field
Field_Type
Price
ID_Schedule
ID_Field
Date_Play
Hour
E/R DIAGRAM
TABLES
Number Of Tables: 5
Structure of Tables: The Table Structures are shown here.
COSTUMER (Entity)
CUSTOMER
ID_Customer
Name_Customer
Name_ Team
NO_Phone
TRANSACTION (Entity)
TRANSACTION
ID_Transaction
Date_Transaction
ID_Customer
ID_Employee
ID_Field
Price
Quantity
Total
EMPLOYEE (Entity)
EMPLOYEE
ID_Employee
Employee_Name
Gender
Address
Employee_Phone
SCHEDULE (Entity)
SCHEDULE
ID_Schedule
ID_Field
Date_Play
Hour
FIELD (Entity)
FIELD
ID_Field
Type_Field
Price
The Transaction Details table is formed because of a many-to-many relationship
between Event Table and Payment Table.
TABLES 1 NF
Number Of Tables: 5
Structure of Tables: The Table Structures are shown here.
COSTUMER
CUSTOMER
ID_Customer
Name_Customer
Name_ Team
NO_Phone
TRANSACTION
TRANSACTION
ID_Transaction
Date_Transaction
ID_Customer
ID_Employee
ID_Field
Price
Quantity
Total
FIELD
FIELD
ID_Field
Type_Field
Price
EMPLOYEE
EMPLOYEE
ID_Employee
Employee_Name
Gender
Address
Employee_Phone
SCHEDULE
SCHEDULE
ID_Schedule
ID_Field
Date_Play
Hour
TABLES 1 NF
Example: Table 1 NF
Before
ID_Transaction
Date_Transaction
ID_Customer
Name_Customer
TR001
10/12/2015 C001
Bokir
TR002
10/12/2015 C002
Ridwan
TR003
11/12/2015 C003
Hudaya
Name_ Team
NO_Phone
ID_Employee
Employee_Name
PalaKubang
08968779990
E001
Akbar
Aw Squad
081277778989
E002
Akromul
Nestrie fc
081231324546
E003
Noorman
ID_Field
Lap001
Synthetic
Rp200.000
2 Rp400.000
12/12/2015
Hour
19.00-20.00
20.00-21.00
Lap003
Rubber
Rp150.000
3 Rp450.000
13/10/2015
14.00-15.00
Lap002
Type_Field
Board
Price
Rp175.000
Quantity
Total
2 Rp350.000
Date_Play
14/10/2015
15.00-16.00
16.00-17.00
09.00-10.00
10.00-11.00
TABLE 1 NF
After
ID_Transaction
Date_Transaction
ID_Customer
Name_Customer
TR001
TR001
TR002
TR002
TR002
TR003
10/12/2015
10/12/2015
10/12/2015
10/12/2015
10/12/2015
11/12/2015
C001
C001
C002
C002
C002
C003
Bokir
Bokir
Ridwan
Ridwan
Ridwan
Hudaya
TR003
11/12/2015 C003
Hudaya
Name_ Team
NO_Phone
ID_Employee
Employee_Name
ID_Field
PalaKubang
PalaKubang
Aw Squad
Aw Squad
Aw Squad
Nestrie fc
08968779990
08968779990
081277778989
081277778989
081277778989
081231324546
E001
E001
E002
E002
E002
E003
Akbar
Akbar
Akromul
Akromul
Akromul
Noorman
Lap001
Lap001
Lap003
Lap003
Lap003
Lap002
Nestrie fc
081231324546
E003
Noorman
Lap002
Type_Field
Price
Quantity
Total
Date_Play
Hour
Synthetic
Synthetic
Rubber
Rubber
Rubber
Board
Rp200.000
Rp200.000
Rp150.000
Rp150.000
Rp150.000
Rp175.000
2
2
3
3
3
2
Rp400.000
Rp400.000
Rp450.000
Rp450.000
Rp450.000
Rp350.000
12/12/2015
12/12/2015
13/12/2015
13/12/2015
13/12/2015
14/12/2015
19.00-20.00
Board
Rp175.000
2
Rp350.000 14/12/2015
10.00-11.00
20.00-21.00
14.00-15.00
15.00-16.00
16.00-17.00
09.00-10.00
TABLES 2 NF
The table are already in 2NF as the attributes in each table depend on primary key. The table
structure as shown here.
COSTUMER
CUSTOMER
ID_Customer
Name_Customer
Name_ Team
NO_Phone
TRANSACTION
TRANSATION
ID_Transaction
Date_Transaction
ID_Customer
ID_Employee
ID_Field
Price
Quantity
Total
ID_Employee
Employee_Name
Gender
Address
Employee_Phone
ID_Field
Type_Field
Price
ID_Schedule
ID_Field
Date_Play
Hour
TABLES 3 NF
The table are already in 3NF as the attributes in each table depend on primary key. The table
stucture as shown here.
COSTUMER
CUSTOMER
ID_Customer
Name_Customer
Name_ Team
NO_Phone
EMPLOYEE
EMPLOYEE
ID_Employee
Employee_Name
Gender
Address
Employee_Phone
SCHEDULE
SCHEDULE
ID_Schedule
ID_Field
Date_Play
Hour
FIELD
FIELD
ID_Field
Type_Field
Price
TRANSACTION
TRANSACTION
ID_Transaction
Date_Transaction
ID_Customer
ID_Employee
ID_Field
Price
Quantity
Total
TABELS AFTER DENORMALIZATION
When are we going to find out about when the payment transactions and by whom, there is
attribute involved is taken from the table before the process of denormalization such as
transactions done. We also look at how to find out about how the transactions by customer and
how much. In this case, we separate the several attributes that are taken off the table before the
denormalization process such transactions.
TRANSACTION
ID_Transaction
Date_Transaction
ID_Customer
ID_Employee
ID_Field
Price
Quantity
Total
PRIMARY AND FOREIGN KEYS
The Primary and Foreign Keys (Wherever Applicable) for each table are listed with their
respective table name:

Customer
Primary Key: ID_Customer

Employees
Primary Key: ID_Employee

Transaction
Primary Key: ID_Transaction
Foreign Keys: ID_Field ID_Employee, ID_Customer

Field
Primary Key: ID_Field
Foreign Keys: ID_Schedule

Schedule
Primary Key: ID_Schedule
Foreign keys: ID_Field
PROBLEMS ENCOUNTERED
Some of the problems experienced in the writing of the inventor of this project are as follows:



We have just learned of Data Table Relation and E/R Diagrams
We have not had experience in doing the project as given at this time
Difficulties when looking for Relation at each data
CONFIGURATION
Hardware: IntelR DualCoreTM @ 2,20GHz 2,20 GHz, 2.00GB RAM, 500 GB
HDD,
Operating System: Windows 10 Home Singel Language
Software: Microsoft Visio 2016, Microsoft Word 2016
PROJECT FILE DETAILS
S.No
File Name
Remarks
1
FutsalArena.word
Word Document contain
Relation
Download