Project Proposal ITS232 PDF

Preview

Summary

Appendix A – Front Cover PageITS232: INTRODUCTION TODATABASE MANAGEMENT SYSTEMSSemester March 2020 – July 2020Proposal/Final Report:[ Jersey and Sports Equipment Rental System ]Prepared by:Name of the Group Members Student ID1. AINI SAHIRA BINTI MOHAMAD RAZALI 20182919642. NUR SHAFINI BINTI MUHAMMAD...

Description

CS1434G

Appendix A – Front Cover Page

ITS232: INTRODUCTION TO DATABASE MANAGEMENT SYSTEMS Semester March 2020 – July 2020 Proposal/Final Report: [ Jersey and Sports Equipment Rental System ]

Prepared by: Name of the Group Members 1. 2. 3. 4. 5.

AINI SAHIRA BINTI MOHAMAD RAZALI NUR SHAFINI BINTI MUHAMMAD YUSOF AMEERA FARISHA BINTI ABDUL RAIF NUR SYAFIQAH BINTI ABU KASSIM NUR AMIRA NADIA BINTI MOHD ALI

Prepared for: [ NUR HASNI BINTI NASRUDIN ] (Leave this part blank. For lecturer’s comments only)

Remarks:

Student ID 2018291964 2018236442 2018245206 2018658506 2018246066

Appendix B: Proposal Evaluation Form

Evaluation Form for the Report of Proposed Database Project. (Weighted: 4%) 5 Excellent Student has excelled in performing the competency, works independently. Student has completed the work and exceeded activity requirements.

4 Exceeds Expectations

3 Meets Expectations Student performed the competency at an acceptable level. Assistance or guidance from preceptor was occasionally necessary.

Student performed the competency very well, was above average in effectiveness and/or consistency.

Writing Style (Technical Skills)

Proofreading (Technical Skills)

Completeness (Content) ● Front Page Cover

● Table of Contents

● Members’ Profile

1 Below Expectations

Student attempted but did not achieve competency in all areas. Needs improvement.

Unacceptable. Performance was below expectations. Needs significant improvement.

Score

Criteria

Format (Technical Skills)

2 Needs Improvement

1

2

Major errors in formatting

Minor errors in formatting

Sentences aren’t clear and continuous grammar and/or punctuation, capitalization errors. A lot of spelling errors. Could also be a sign of lack of proofreading. Many required data has not displayed. No page numbers listed. Many of the required details have not been reported, and do not have the

Sentences are generally clear but may have awkward structure; there may be patterns of punctuation errors. Shows a pattern of errors in grammar, and/or punctuation. A few errors in spelling and typographical, but not many. Some required data has not displayed but not many. Some of the page numbers are in wrong position. Some of the required details have not been reported, but have the elements of

3 All specified formatting style has been portrait. Sentences are clear but the reader may lose interest in some sections of the paper. A few errors in grammar, punctuation, and capitalization, but not many. Free from any spelling and typographical errors. Free from errors. All required data has been displayed. All page numbers being entered accordingly. All required details have been reported in creative ways but there is quite many errors made.

Weight 4

Sentences are clear and hold the reader’s interest with ease. Good use of grammar, punctuation, and capitalization.

All required details plus additional details has been reported in creative ways, but there is

5

Sentences are very clear and hold the reader’s interest with ease. Excellent use of grammar, punctuation, and capitalization.

All required details with picture from each group members, plus additional details

W

Total Total / Score Section W x Score

1

3

2

10

1

3

1

3

1

3

1

5

Page 1 of 3 Faculty of Computer and Mathematical Sciences © Copyrightedof Universiti Teknologi MARA Perak

Appendix B: Proposal Evaluation Form

elements of creativity.

creativity.

•

Organizational Chart

1

2

Poor description of facts. Much information is not provided.

Paragraph lack of clear ideas. Not enough information provided from the organization.

Not included employees’ title positions or only include the name of the staff; not the full name of the staff. The information is not specific and related.

Not included either employees’ title positions or the full name of the staff. The information is related but not specific.

● Current System Descriptions

Content is not sound.

● Current Problem Statements

has been reported in creative ways.

Score

Criteria ● Introduction to Organization • Organizational Background

still few errors made.

Provide less than three statements. No descriptions and examples given. Provide

Content is sound and solid; description are present but not particularly developed or supported; some evidence, but usually of a generalized nature. Only provide process flow chart. Provide less than three statements with brief description. No examples given.

3 Some paragraphs have clear ideas, but the paragraph transitions are weak. Provide basic information from the organization

Weight 4 Most paragraphs have clear ideas, and provide additional information from the organization.

5 All paragraphs have clear ideas, and provide additional information and necessary pictures or images from the organization. Includes all employees’ title positions with the respective full name of the staff. The chart has been illustrated in a corporate style look.

W

Total Score W x Score

Total / Section

1

5

1

5

Includes all employees’ title positions with the respective full name of the staff. The chart has been illustrated in a normal style look.

Includes all employees’ title positions with the respective full name of the staff. The chart has been illustrated in an interesting style look.

Well-presented; descriptions are detailed, developed and supported with evidence and details, mostly specific.

Exceptionally wellpresented; descriptions are detailed, welldeveloped, supported with specific evidence & facts, as well as examples.

Exceptionally wellpresented; descriptions are detailed, welldeveloped, supported with specific evidence & facts, as well as examples and process flow chart.

2

10

Provide three statements. No descriptions and examples given.

Provide three statements with brief description for each statement. No examples given.

Provide three statements and large amounts of specific examples and detailed

1

5

Page 2 of 3 Faculty of Computer and Mathematical Sciences © Copyrightedof Universiti Teknologi MARA Perak

Appendix B: Proposal Evaluation Form

wrong facts.

Irrelevant explanations and examples given.

Score

Criteria 1 ● Proposed Database Objectives

● Initial Proposed ERD

● References

descriptions.

Provide less than three statements. No descriptions and examples given. Provide wrong facts. Many errors in connectivities, labels and notations. The sources are not cited correctly according to APA style, nor listed correctly. Only one reference is listed.

Penalty for late submission, no evaluation form or issue of plagiarism

2 Provide less than three statements with brief description. No examples given. Irrelevant explanations and examples given. Some errors in connectivities, labels and notations. There may be a few errors in APA style citation. Only two references are provided.

Weight

Total Score W x Score

Total / Section

3

4

5

W

Provide three statements. No descriptions and examples given.

Provide three statements with brief description for each statement. No examples given.

Provide three statements and large amounts of specific examples and detailed descriptions.

1

5

Provide all correct connectivities, labels and notations.

2

6

Listed references conform to APA style citation. Provide at least three references.

1

3

(-3.0)

NA

TOTAL SCORE

66

Examined by:

PUAN NIK RUSLAWATI NIK MUSTAPA Course Lecturer of ITS232 Page 3 of 3 Faculty of Computer and Mathematical Sciences © Copyrightedof Universiti Teknologi MARA Perak

CASE STUDY

TABLE OF CONTENTS

CONTENTS

PAGES

4.0 Members Profile

1-3

5.0 Company Background

4-5

6.0 Currents System Description

6-7

7.0 Problem Statement 8 8.0 Suggestion Solution

9.0 Objective of Proposed System

10.0 Initial Entity Relationship Diagram

11.0 References

9

10 - 11

12

4.0 Members Profile

Database Developer

Nur Shafini Binti Muhammad Yusof (201836442)  Create and maintain database-based applications.  Modifying databases and products according to client needs  Providing assistance to others in topics related to data management.  Able to do programming and SQL

Database Administrator

Nur Amira Nadia Binti Mohd Ali (2018246066)  Manage and maintain Database Management System (DBMS) and databases of the company performance.  Supervision of modifications to any existing database software to meet the needs of their employer.  Informing end users of changes in databases and train them to utilize systems.  It has the abilities database fundamentals, SQL, and vendor courses.

1|Pa ge

Database Architect

Aini Sahira Binti Mohamad Razali (2018291964)  Design and implementation of database environments (conceptual, logical and phyiscal).  Work together with database administratorto secure easy access to company data.  Monitor the system performance by performing regular tests, troubleshooting and integrating new features.  Experts in DMBS fundanmentals, data modelling, database design, and SQL.

Database Security Officer

Ameera Farisha Binti Abdul Raif (2018245206)  Implement securities policies for data administration.  Database security officer have skills in data security technologies, SQL and database administrator.  To ensure the databases are protected from internal and external threats

2|Pa ge

Database Consultant

Nur Syafiqah Binti Abu Kassim (2018658506)  Help companies leverage database technologies to improve business processes and achieve specific goals.  Provide database support services at all times to ensure continuous system availability.  Stay updated on latest developments in database services and technologies.  Capable in DBMS and SQL.

3|Pa ge

5.0 Company Background

BACKGROUND Perfect Sports was founded in 2005. Perfect Sports is a company that provides the services of borrowing sports equipment and jerseys to the public. Previously, Perfect Sports was named as Love Life Sports but was renamed because it failed to stand out among sports enthusiasts. The company operated as Love Life Sports only from 2005 until 2009 and since then the company has been operating as Perfect Sports. Till this day, Perfect Sports has approved approximately 1000 borrowers.

VISION Become a sports equipment centre that dominates the entire Malaysian market by providing high quality sports equipment that will attract the attention of sports fans nationwide.

MISSION

1. Committed to marketing jerseys and sports equipment that meet consumer expectations.

2. Open several new branches nationwide in the future. 3. Provides quality, fast, and flexible service

OBJECTIVES

1. Deal more efficiently and professionally with customers. 2. Handling all matters according to company rules through work ethic and instil good values between suppliers and customers.

3. Be aware and be prepared of any changes that may occur so that the quality of service can be improved over time.

4|Page

ORGANIZATIONAL CHART

NUR HASNI BINTI NASRUDIN SUPERVISOR

NUR AMIRA NADIA BINTI MOHD ALI

NUR SHAFINI BINTI MUHAMMAD YUSOF

AINI SAHIRA BINTI MOHAMAD RAZALI

DATABASE DEVELOPER

DATABASE ARCHITECT

DATABASE ADMINISTRATOR

AMEERA FARISHA BINTI ABDUL RAIF DATABASE SECURITY OFFICER

NUR SYAFIQAH BINTI ABU KASSIM DATABASE CONSULTANT

5|Page

6.0 Current System Description

The Perfect Sport Company currently using web-system. This system required customer to register their name through the website. Once they have registered, the employee will email the code to the customer and they can book the sports equipment or jersey using the code. If the items are available, they can just go to the Perfect Sports shop to get them. But if the items are fully booked, then they must wait until the Perfect Sports send a new email about the availability of the item.

6|P a g e

START

User

Admin

If Registered?

No

Registration

Yes Login

No Is Valid?

Yes Is Admin?

No User

Admin E-mail received and get code

Send the code to customer

Sports equipment or jersey search

Update all information

Item reserved

Log out 7|P a g e

END

7.0 Problem Statement

1. The server is not efficient and lack in performances. It happens when too many people use the server especially during special events. For example, customer decided to borrow the sports equipment in the last minute and keep sign in frequently.

2. The goods returned to the company is late. The company have to make a postponement of the goods to another date for the next customer who has already reserved the same equipment. The image of the company will be effect because of the customer's perception of the company's inefficient service.

3. The current problems that face by the company is the security information of the customer. When the security of the company’s data is compromised by others, the record of the company will be effect and the customer will feel insecure to us.

8.0 Suggestion Solution

1. To overcome the problem, the company need to hire the Data Scientist to analyse the problem at our website. So that the customers are not having trouble signing in even though it's too crowded.

2. To solve the problem, the company will upgrade the system. This is because the system before that is not efficient which is the staff need to email the customer about the date for returning the equipment as a warning .It will take too much time to process it. Now, when the system is upgraded, it will simplify and save staff time to upload the notice with automatic system. It also can avoid the mistake from the staff of the company to send the warning.

3. The company have to provide the strengthen of security systems to protect the personal data of their customers who using the company's services. For example, the company will give a code to the customer who want to sign in to the website .The customer will get one code that no one else will know and the code will not redundancy to the other customers.

8|Page

9.0 Objectives of Proposed System

1. To make the company up to date by using the current system. 2. To improve more efficient company service to the customer. 3. To improve the security data personal of the customer who use the company website. 4. To improve the customer satisfaction.

9|Page

10.0 Initial Entity Relationship Diagram

10 | P a g e

BUSSINES RULES 1. Each customer can borrows one or many jersey. 2. Each jersey can be borrowed by one or many customers. 3. Each customer can borrows one or many equipment. 4. Each equipment can be borrowed by one or many customers. 5. A customer may generate one or more invoices. 6. An invoice is generated by one and only one customer. 7. A staff can writes one or more invoices. 8. An invoice is written by one staff.

11 | P a g e

11.0 References 1) Borang

Pinjaman

Peralatan

&

Jersi.

(n.d.).

Retrieved

from

https://pusatsukan.unimap.edu.my/index.php/component/k2/item/12-borang-pinjamanperalatan-jersi 2) Coronel, C., & Morris, S. (2019). Database System Design, Implementation, and Management (13th ed.). 151 Lorong Chuan, Singapore: Cengage Learning, Inc.

12 | P a g e...