Fabrice Final Thesis
Fabrice Final Thesis
Fabrice Final Thesis
Tuyishime Fabrice
BBICT/2022/47735
January 2024
DECLARATION
I hereby declare that this project report is based on my original work except for citations and
quotations which have been duly acknowledged. I also declare that it has not been previously and
concurrently submitted for any other degree or award at Mount Kenya University.
SUPERVISOR
1.The undersigned do hereby certify that this is a true report for the project undertaken by the
above-named student under my supervision and that has been submitted to Mount Kenya
University with my approval.
Name: …………………………
i
DEDICATION
ii
AKNOWLEDGEMENTS
I would like to express my sincere gratitude and appreciation to all those who directly or indirectly
contributed to a successful completion of this research proposal. First of all, I thank the almighty
God for his love. He enabled me with this protection that permitted me to complete this work. My
special thanks to my classmates and Mount Kenya University staff, especially lecturers of the
faculty of Business Information Communication and Technology for the knowledge and skills they
provided us. More importantly, I would like to express my special thanks to my supervisor Dr.
Iradukunda Nadia for her sacrifice, continued support through our study, and the preparation of
this research report. Thanks for her kindness, humanity. I would like to thank my family in General
for their help and my friends who supported me in one way another by encouraging me, with their
moral support, financial support and prayers, just no mention a few.
iii
Table of Contents
DEDICATION ................................................................................................................................. ii
AKNOWLEDGEMENTS .................................................................................................................. iii
Table of Contents ......................................................................................................................... iv
CHAPTER ONE: INTRODUCTION .................................................................................................... 1
1.1 Introduction ...................................................................................................................................... 1
1.2 Background of the study ................................................................................................................... 1
1.3 Problem statement ........................................................................................................................... 1
1.3 Objective of the study ....................................................................................................................... 2
1.4 scope and limitation.......................................................................................................................... 2
1.5 Justification of the study ................................................................................................................... 2
1.7 budget and resources ....................................................................................................................... 3
1.8 project schedule................................................................................................................................ 4
CHAPTER TWO: LITERATURE REVIEW ............................................................................................. 5
2.1 introduction ...................................................................................................................................... 5
2.2 Definition of keys terms .................................................................................................................... 5
2.2.1 music studio management ............................................................................................................. 5
2.2.2 User interface (UI) .......................................................................................................................... 5
2.2.3 User-centered design ..................................................................................................................... 5
2.2.4Management .................................................................................................................................. 5
2.2.5 System............................................................................................................................................ 6
2.2.6 Service Management System (SMS) ............................................................................................... 6
2.2.7 Information system ........................................................................................................................ 6
2.2.8 Database ........................................................................................................................................ 6
2.2.9 PhpMyAdmin ................................................................................................................................. 6
2.3.0 management information system(mis) .......................................................................................... 7
CHAPTER THREE: METHODOLOGY ................................................................................................. 8
3.0 Introduction ...................................................................................................................................... 8
3.1 Data Collection and Procedures ........................................................................................................ 8
3.2 Primary Data ..................................................................................................................................... 8
3.2.1 Observation.................................................................................................................................... 8
3.2.2 Interview ........................................................................................................................................ 9
iv
3.3 Secondary Data ................................................................................................................................. 9
3.4 Software Development Life Cycle ..................................................................................................... 9
3.4.1 Waterfall Model ............................................................................................................................. 9
3.4.1.1 System Engineering ................................................................................................................... 10
3.4.1.2 Requirements and Analysis ....................................................................................................... 10
3.4.1.3 Design ....................................................................................................................................... 11
3.4.1.4 Implementation ........................................................................................................................ 11
3.4.1.5 Testing....................................................................................................................................... 11
3.4.1.6 Maintenance ............................................................................................................................. 11
3.5 Software/Hardware Technologies .................................................................................................. 11
3.5.1 Software ....................................................................................................................................... 11
3.5.2 hardware ...................................................................................................................................... 12
CHAPTER FOUR: SYSTEM ANALYSIS AND REQUIREMENT MODELING ............................................ 13
4.0 Introduction .................................................................................................................................... 13
4.1 Context Diagram ............................................................................................................................. 13
4.2 Data flow diagram ........................................................................................................................... 14
4.3 User Case Diagram .......................................................................................................................... 14
4.3.1 User Use Case .............................................................................................................................. 15
4.3.2 user use case ................................................................................................................................ 15
4.4 Activity Diagram of the System ....................................................................................................... 15
CHAPTER FIVE: SYSTEM DESIGN................................................................................................... 17
5.0 Introduction .................................................................................................................................... 17
5.1 Interface design .............................................................................................................................. 17
5.2 Project interfaces ............................................................................................................................ 17
5.3 data base design ............................................................................................................................. 23
CHAPTER SIX: SYSTEM IMPLEMENTATION AND TESTING .............................................................. 24
6.0 Introduction .................................................................................................................................... 24
6.1 PHP.................................................................................................................................................. 24
6.1.1 Software Technologies ................................................................................................................. 24
6.1.2 HTML ............................................................................................................................................ 25
6.1.3 CSS ............................................................................................................................................... 25
6.1.4 MySQL .......................................................................................................................................... 25
6.1.5 Bootstrap ..................................................................................................................................... 25
v
6.2 System Testing ................................................................................................................................ 25
6.2.1 Objective of the Testing ............................................................................................................... 26
6.2.2 Testing plan .................................................................................................................................. 26
6.2.3 Unit Testing .................................................................................................................................. 26
6.2.4 Validation Testing ........................................................................................................................ 27
6.2.5 Integration Testing ....................................................................................................................... 27
6.2.6 Function and System Testing ....................................................................................................... 27
6.2.7 Acceptance Testing ...................................................................................................................... 27
6.2.8 White box testing ......................................................................................................................... 28
CHAPTER SEVEN: LIMITATION, RECOMMENDATION AND CONCLUSION ........................................ 29
7.0 Introduction .................................................................................................................................... 29
7.1 Limitation ........................................................................................................................................ 29
7.2 Recommendation ............................................................................................................................ 29
7.3 Conclusion....................................................................................................................................... 29
REFERENCES ............................................................................................................................... 30
APPENDICES ............................................................................................................................... 31
vi
LIST OF TABLES
vii
LIST OF FIGURES
viii
CHAPTER ONE: INTRODUCTION
1.1 Introduction
Music studio management system (MSMS) a groundbreaking website revolutionizing the
organization, coordination, and optimization of music studio resources. Designed to streamline
operations and amplify creative output, the MSMS caters to a diverse user base including studio
managers, recording engineers, artists, administrative staff, and clients seeking studio sessions.
With a robust suite of features encompassing studio booking, equipment management, artist
collaboration tools, and project tracking capabilities, the MSMS provides a dynamic platform for
enhancing productivity and maximizing creative potential within the music studio environment.
1
1.3 Objective of the study
1.3.1 General objectives
The general objective of this research is to develop and evaluate a music studio management
system tailored specifically for Sharon Studio, with the aim of enhancing operational efficiency
and productivity within the studio environment.
2
1.6 project risk and mitigation
Project risks include the potential for scope creep, budget overruns from unforeseen charges, and
delays brought on by technical difficulties. Effective testing and prototyping to address technical
concerns early on, careful budget planning to control costs, and routine monitoring to avoid scope
creep are all examples of mitigation measures. To ensure the effective development and
implementation of the music studio management system at Sharon Studio, backup plans will also
be created to handle unanticipated failures.
3
1.8 project schedule
The table below shows a brief description of the project activities through different chapters
against the time schedules Gantt structure.
Table 2: project activities schedules (Gantt chart)
W1 W2 W3 W4 W1 W2 W3 W4 W1 W2 W3 W4
Project proposal
Chapter 1:
Introduction
Chapter2: Literature
Review
Chapter 3:
Methodology
Chapter4:Requirement
analysis and Modeling
Chapter5:System
Design
Chapter 6: System
Implementation.
Chapter7:
Recommendation and
conclusions
4
CHAPTER TWO: LITERATURE REVIEW
2.1 introduction
The main objectives of literature review are to establish to a gap which this project is intend to fill
and clarify the term that will be used in this project including the main definitions, Literature
review means collecting related data, analyzing business process, identifying patterns and create
the conclusion.
Music studio management encompasses the efficient oversight and coordination of activities
within a music studio environment, leveraging technology, established procedures, and policies to
optimize resource utilization, enhance user experience, and facilitate revenue generation while
mitigating operational challenges and congestion.
2.2.4Management
The management can be explained by the organization and coordination of the activities of a
business in order the archive defined objectives. Management is often included as a factor of
production along with machines, materials and money with human being desire. (lucey, terry,
2005)
5
2.2.5 System
System is an organized, purposeful structure that consists of interrelated and interdependent
elements (components, entities, factors, members, parts etc.). These elements continually influence
one another (either directly or indirectly) to maintain their activity and the existence of the system,
in order to achieve the goal of the system. All systems have inputs, outputs and feedback
mechanisms, maintain an internal steady-state (called homeostasis despite a changing external
environment and have boundaries that are usually defined by the system observer. (david, 2015)
2.2.8 Database
As said by Robbins database is a collection of related data. The database will help us to store all
information related to the design and implementation of task management information system. The
data are typically organized to model relevant aspects of reality in a way that supports processes
requiring this information (Robbins, 1994, 1995).
2.2.9 PhpMyAdmin
PhpMyAdmin is a free software tool written in PHP intended to handle the administration of
MySQL over the World Wide Web. PhpMyAdmin supports a wide range of operations with
MySQL. The most frequently used operations are supported by the user interface (managing
databases, tables, fields, relations, indexes, users, permissions, etc.), while you still have the ability
to directly execute any SQL statement. This graphical interface allows you to add, edit and create
data in a database with ease. PhpMyAdmin program is handy for performing maintenance
6
operations on tables, backing up information, and editing things directly in the event that your
scripts are not working. occasionally, in the support forums, someone will post a SQL, query of
some benefit or other that can be run using PhpMyAdmin
7
CHAPTER THREE: METHODOLOGY
3.0 Introduction
This chapter explains methods which are used to collect data during research and software tools
used to collect data and information for the purpose of making decision. The methodology may
include publication research interview, surveys and other research techniques. This chapter also
describes the system development method. A system development methodology in software
engineering is a framework that is used to structure, plan as well as control the process of
developing an information system
8
3.2.2 Interview
Interviewing involves asking questions and getting answers from participants in a study.
Interviewing has a variety of forms including: individual, face-to-face interviews and face-to-face
group interviewing. The asking and answering of questions can be mediated by the telephone or
other electronic devices (e.g., computers). Interviews can be Structured, Semis structure or
unstructured. (internet). this project used this method to collect data from users of the system .
9
Figure 1:waterfall model
system engineering involves conducting a comprehensive study to understand the needs and
requirements of users such as studio managers, recording engineers, artists, and administrative
staff, as well as the limitations of the current studio management processes. Through interviews,
surveys, and user testing, valuable insights are gathered to inform the development of the system.
The collected data is then analyzed to assess the technical feasibility, economic viability, and
operational effectiveness of the proposed music studio management system. This analysis
determines whether the system is technically feasible, financially sustainable, and operationally
suitable for addressing the challenges faced in managing the studio effectively and efficiently.
10
3.4.1.3 Design
At this stage, the developer will make an overall design other system architecture and physical
design include user interface and database design. It is at this stage the developer will identify any
faults before moving onto the next stage. The output of the design specification which is used in
the next stage of implementation
3.4.1.4 Implementation
At this stage, the developer will begin coding as per design specifications. The output of this step
is one or more product components built according to a pre-defined coding standard and debugged,
tested and integrated to satisfy the system architecture requirement.
3.4.1.5 Testing
At this stage, the developer will ensure both individual and integrated whole methodically verified
to ensure they are error free and satisfy customer requirement. The developer will involve in both
unit testing of individual code module, system testing of the integrated product and acceptance
testing conducted by or on behalf of customer. The developer ensures bugs found are corrected
before moving to the next stage. The developer will also prepare, review and publish product
documentation.
3.4.1.6 Maintenance
Lastly, this stage occurs after installation. It involves modifications on the system to improve
performance. Such changes are user initiated or as result of bug being discovered which were
initially not known. These modifications are recorded for documentation and system update,
HTML
11
Back-end MySQL
3.5.2 hardware
RAM 4GB
Hard disk 500 GB
System type 64 bit
Processor: intel core i5 (minimum), [email protected](minimum)
12
CHAPTER FOUR: SYSTEM ANALYSIS AND REQUIREMENT
MODELING
4.0 Introduction
This chapter highlights the steps to be followed in achieving the objectives of the research which
are the information gathering for describing different techniques used to get information about the
current used system, description of the proposed system. User cases case how the users interact
with the system and activity diagram show user interact with system’s interface.
13
4.2 Data flow diagram
A data flow Diagram is also a graphics representation of the “flow” of data through an information
system, modeling its process aspects. Often are a preliminary step used to create an overview of
the system which can later be collected. DFD shows the flow of data through a system. It views
system as a function that transforms the input into outputs. Any complex system will not perform
this transformation in a single step, and data will typically undergo a series of transformation
before the output. The DFD aims to capture the transformation that place within a system to the
input data so that eventually the output data is produced. The agent that performs of data from one
state to another is called a process (or bubble).
This DFD shows the movement of data through the different transformation or process in the
system.
Figure 3: DFD
14
types of users of a system and the case often be accomplishing by other types of diagrams as well.
The use case diagram basically consists of components: actor, use case, and association.
Association: Action or verb between actor and use case, or among use cases, usually, association
will be drawn without any description.
15
sequence diagram were meant exclusively for them. Basic Activity Diagram Notation and Symbols
initial state or Start Point.
16
CHAPTER FIVE: SYSTEM DESIGN
5.0 Introduction
System design is the process of specifying the architecture, data, and interfaces needed to build a
system that meets predetermined needs. In this chapter, we will attempt to describe the
technologies used in the construction of the new system, along with the new notion of how the
application was designed. This chapter includes the development tools for the system as well as
the testing methods required to ensure that its performance is accurate. The process of defining the
architecture, modules, interfaces, and data for a system to meet predetermined requirements is
known as system design.
17
Figure 8:about us page
Figure 9:services
18
Figure 10:contact us
19
Figure 12:admin dashboard
20
Figure 14: add services
21
Figure 16: booking results
22
Figure 18: user sign in
23
CHAPTER SIX: SYSTEM IMPLEMENTATION AND TESTING
6.0 Introduction
Implementation is the process that actually yields the lowest-level systems in the system hierarchy
(system breakdown structure). System elements are made, bought, or reused. Production involves
the hardware fabrication process of forming, removing, joining, and finishing, the software
realization process of coding and testing, or the operation procedures for operator’s roles. If
implementation involves a production process, a manufacturing system which uses the established
technical and create (or fabricate) a system element conforming to that element’s design properties
and or requirements. The element is constructed employing appropriate technologies and industry
practices
6.1 PHP
PHP: Hypertext Pre-Processor a server-side scripting language designed for web development but
also as a general-purpose programming language. PHP is very easy for beginners and also offers
many advanced features for professional programmers. PHP runs efficiently on Apache server, but
it can also run on IIS. PHP is an open-source and cross-platform language. It can be built as an
Apache module or a CGI script. As an Apache module, PHP is very and lightweight, allowing for
quick turnaround.
24
6.1.2 HTML
HTML (Hyper Text Mark-up Language) is the set of mark-up symbols or codes inserted in a file
intended for display on a World Wide Web browser page. The mark-up tells the web browser how
to display a web page’s words and images for the user. Each individual mark-up code is referred
to as an element (but many people also refer to it as a tag). Some elements come in pairs that
indicate when some display effect is to begin and when it is to end.
6.1.3 CSS
Cascading Style sheet is a kind of programming language that can be used to set the styles and
qualities of different website component and pieces of content, it can be used to set universe color,
text and background properties for certain columns, tables, layers and the entire website body.
6.1.4 MySQL
MySQL is freely available open-source relation database management system (RDBMS) that uses
structured query language (SQL).SQL is the most popular language for adding accessing and
managing content in the database. MYSQL is an essential part of almost every source PHP
application.
6.1.5 Bootstrap
Bootstrap is free and open-source front-end web framework for designing websites and web
applications. It contains HTML and CSS-based design templates for typography, forms, buttons,
and navigation and other interface components, as well as optional JavaScript extensions. Unlike
many web frameworks, it concerns itself with front-end development only.
25
System testing is actually a series of different tests whose sole purpose is to exercise the full
computer-based system. System testing falls under the black box testing category of software
testing. White box testing is the testing of the internal workings or code of a software application.
In contrast, black box or system testing is the opposite.
26
6.2.4 Validation Testing
System Validation is a set of action used to check the compliance of any element (a system
element, a document, a service, a task, a system requirement, etc.) With its purpose and functions.
These actions are planned and carried out throughout the life cycle of the system. Validation is a
genetic term that needs to be instantiated within the context it occurs. Validation determines if the
system compiles with the requirements and performs function for which it is intended and meet
the user need and the organization’s goals.
27
6.2.8 White box testing
White Box Testing (WBT) is also known as Code-Based Testing or Structural Testing, it is a
testing technique that examines the program structure and derives test data from the program logic
or code by analyzing the internal structure of the system. White box testing involves the testing by
looking at the internal structure of the code. When you complete aware of the internal structure of
the code. When you can run your test cases to check whether the system meet requirement
mentioned in the specification document. Based on derived test cases the user exercised the sets
cases by giving the input to the system and checking for expected outputs with actual output. In
this testing method user has to go beyond the user interface to find the correctness of the system.
28
CHAPTER SEVEN: LIMITATION, RECOMMENDATION AND
CONCLUSION
7.0 Introduction
This chapter reflects back on the objectives of the system development and putting into
consideration the possible the challenges, limitations, recommendation and conclusions.
7.1 Limitation
Because not all users speak or comprehend English, it would be challenging for them to utilize the
system, which is designed in plain English. This was the main challenge encountered throughout
the system's creation.
7.2 Recommendation
The developer’s recommendations are addressed to other developers to learn new programming
language and continue to expand their skills in programming for future developers, the journey in
this field is still ongoing, and changes and improvements can be easily made on the website to
adapt to evolving technologies and user needs.
7.3 Conclusion
This website streamlines procedures, offers online functionality with user login for booking
details, and makes report generation easier for hotel firms and their customers. It is a
computerized and automated version of an art gallery management system. The application
promises an easier-to-use graphical user interface than the current system, guarantees
permission-based user access, removes communication lag, streamlines information updates,
prioritizes system and data security, and permits simple future modifications.
29
REFERENCES
• Elmasri, Ramez and navathe, Shamkant B. (july 2003). Fundamentals of Database Systems, Fourth
Edition. Pearson.p. 315.ISBN 0321204484.
• https://www.w3schools.com/php/default.asp
• https://www.sitepoint.com/php/
• https://www.php.net/
• Jessup, Leonard M.: Joseph S. Valacish(2005). Information System Today (3 rd edition)
30
APPENDICES
<!DOCTYPE html>
<html>
<head>
<title>Online Studio Management System||Home Page</title>
<link href="css/bootstrap.css" rel='stylesheet' type='text/css' />
<!-- jQuery (Bootstrap's JavaScript plugins) -->
<script src="js/jquery.min.js"></script>
<script type="application/x-javascript"> addEventListener("load", function() { setTimeout(hideURLbar,
0); }, false); function hideURLbar(){ window.scrollTo(0,1); } </script>
<!-- Custom Theme files -->
<link href="css/style.css" rel="stylesheet" type="text/css" media="all" />
31
</script>
<div class="content">
<div class="container">
<div class="slider">
<!-- Slideshow 3 -->
<ul class="rslides" id="slider">
<li><img src="images/7.jpg" alt="">
<div class="caption">
<h1>Image1</h1>
<p>This is Studio Management System.</p>
</div>
</li>
<li><img src="images/2.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
</div>
</li>
<li><img src="images/10.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
</div>
</li>
<li><img src="images/5.jpg" alt="">
<div class="caption">
<h1>Image1</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
32
</div>
</li>
<li><img src="images/8.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
</div>
</li>
<li><img src="images/1.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
</div>
</li>
<li><img src="images/13.jpg" alt="">
<div class="caption">
<h1>Image2</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
</div>
</li>
<li><img src="images/3.jpg" alt="">
<div class="caption">
<h1>Image3</h1>
<p>This is Studio Management System Where Artist CAn book
Any Services About Our Studio.</p>
</div>
</li>
</ul>
33
<!-- Slideshow 3 Pager --></br></br>
<ul id="slider3-pager">
<li><a href="#"><img src="images/77.jpg" alt=""></a></li>
<li><a href="#"><img src="images/22.jpg" alt=""></a></li>
<li><a href="#"><img src="images/1010.jpg" alt=""></a></li>
<li><a href="#"><img src="images/55.jpg" alt=""></a></li>
<li><a href="#"><img src="images/88.jpg" alt=""></a></li>
<li><a href="#"><img src="images/11.jpg" alt=""></a></li>
<li><a href="#"><img src="images/1313.jpg" alt=""></a></li>
<li><a href="#"><img src="images/33.jpg" alt=""></a></li>
</ul>
<div class="clearfix"></div>
</div>
</div>
<?php include_once('includes/footer.php');?>
</div>
<!---->
<!---->
</body>
</html>
34