As the final step to your proposed database, submit your Project Plan. This document should communicate how you intend to complete the project. Include timelines and resources required.
Be sure to include:
a. Analysis – how will you determine the needs of the database? Who do you get input from and how?
b. Design – what process will you use to design the database (tables, forms, queries, reports)
c. Prototype/End user feedback – Will you show users a prototype before building the system? What feedback are you looking for?
d. Coding – what process will you use to build the database? Staff or consultant, how will you manage the process?
e. Testing – How will you test it?
f. User Acceptance – describe the final step of determining if you met the user’s needs? What is success?
g. Training – what is the plan for training end users?
h. Project close out – what steps will you take to finalize the project? Are there any more activities to consider after you are done?
>
Database Project Charter/Business Case
Khalia Hart
University of Maryland Global Campus
February 2
1
, 2020
Introduction
A database is an electronic collection of data that is built by a user so that they can access, update particular information in the database coherently or rapidly. Today firms employ integrated technology to increase their capacity to serve more clients, keep information well or effectively, organize activities according to the urgency or priorities, accounting records (Tüttelmann F, 2015). Most of the integrated technology depends on multiple databases that supply information relevant in making the decision. Since the business started using databases, their performance increase because the business decisions they make are sound and practical.
>Business Problem
The supply chain management is one of the most complicated processes in the business and often at times due to need of detail it gets hard for the supply chain manager to keep the record of the work covered effectively, have enough data to make the decision and also have enough data to monitor the chain of operation (William, 2019). The supply chain has been so crucial for the business because it determines the performance of the company in the industry by assessing the quality of the product produced in the organization, cost of production, the time and effectiveness of distribution network, and overall production operation of the organization.
Operation management has been named as the leading cause of business failure caused by a lack of a system, which the manager or the supervisor can use to monitor the whole system. This is the problem to solve using the database (William, 2019). Using a database, the manager can observe or watch the entire chain from their office, make better decisions by fore- planning approach of the database also make changes within the system when there is the need to cut costs or making the process effective.
Project Scope
Most business organizations are spread in operation, and this is the challenge that makes the supply chain management complex (Tüttelmann F, 2015). This is because the chain is in different localities, and therefore, coordination of operation among the user or the workers becomes a challenge. Through the database system, the business will enjoy proper coordination using the wide Area Network (LAN). Through the LAN network, the company can link computers and cost-effectively share data and communication. Through this system, the company will have a connection and coordination of the processes within the organization. The number of connected devices will range from
10
to 1000, depending on the type of tools and system that is set to facilitate this connection.
Goals and objectives of the system
The purpose of the system that I want to install in the supply chain management is to;
· Monitoring of the supply chain- the system will enable the manager to monitor the system and every process in the order (Gattorna., 2015). This monitoring will allow the company to make active correction and block loopholes that will lead to cutting costs that will improve the revenue for the organization.
· Make proper supply chain decisions- with the use of a database, and the manager should make a correct decision because the database will keep a record of the information made (Gattorna., 2015). They can refer to it in the future while making the decision.
· Coordinate the supply chain process- with the use of the database, and the manager can coordinate the operations. This will, in turn, cause a rise in quality produces cost-cutting, efficient distribution, and more revenue to the organization.
Constraints
However, the use of the database user will be relevant to the performance of the organization; it will come with a financial and human resource burden. The purpose of the database requires funding when implementing the process (Becker, 2014). There will be a need to purchase material, devices, and training of staff on the use of the computer system.
Description of Solution
My friends would need to know about the benefit of the installation of the whole system. Therefore, I would tell them that the system reduced the paperwork of the organization by keeping information digitally in the organization database (Becker, 2014). The system would allow the manager to make a supply chain simulation plan that will tell them how the strategy will perform and therefore make any changes to improve the system. Through the database, the manager can refer to the past decision while making strategic decisions and understand what the outcome and factors would be involved.
Project Description
The project involves the use of database systems to overcome the challenges encountered in supply chain management (Becker, 2014). This technology is meant to solve the three most common supply chain problems that are the problem of coordination of strategic plan implementation, the question of monitoring the system, and the problem of deciding for the supply chain.
Through the system, the manager can observe the whole supply chain and make changes where they are necessary to reduce costs or make the process effective (Tüttelmann F, 2015). Monitor the performance of every participant in the supply chain and use the previous information stored in the database and use simulation of the process to see the effect of the decision to make the overall chain. This means that the effectiveness of the supply chain will be established.
Business Process Impact
The impact of the use of the database system in the organization will be an increase in the profit for the organization (Tüttelmann F, 2015). This will be caused by the reduction in the cost of the supply chain, production, and management. Besides, an increase in quality, therefore, a rise in demand for the product.
Technical Feasibility
The implementation of the technology will require the purchase of both the hardware and the software devices (William, 2019). The software includes programs like the oracle cloud that will be used to host the database and accessibility. In contrast, the hardware consists of internet cables, computer machines of all those workers who will need to have access to this database, network provider.
Resource Estimate
The size of the organization will determine the implementation cost and human resource, the number of the user to be connected with the database. However, for this analysis, we will utilize a middle-sized office with five workers who are to access the database. The cost will be as follows.
facilities |
Working workers for installation |
Cost of installation |
Time of installation |
|
Purchase of computers and devices |
2 |
5x $300= $1500 0 Internet cables=$1000 |
Ten days of purchase |
|
Installation of the devices |
3 | $1500 |
Five working days |
|
Connection with a service provider |
1 |
$2000 |
5days |
|
Training of the workers on how to use the system and computer |
$3000 |
10 |
References
Becker, S. A. (2014). developing Quality Complex Database Systems: Practices./. Techniques and Technologies, (p. 81). London: Macmillan.
Gattorna., J. L. (2015). Strategic Supply Chain Alignment. In Best Practice in Supply Chain Management (p. 54). New York: Springer.
Tüttelmann, F, L. C. (2015). Optimizing workflow in andrology: a new electronic patient record and database”. Asian Journal of Andrology, 8(2), 235–41.
William, Z. (2019, July 21). What is SCM (Supply Chain Management System)? Retrieved from Oracle cloud sup[ly chain management system: https://www.oracle.com/applications/supply-chain-management/what-is-supply-chain-management-system.html
Entity Relationship Diagram 1
ERD:
Normalization:
1NF:
For the 1st NF we will have to check the tables’ attributes, like there must not be any multivalued attribute, if there is any multivalued attribute then we have to split the table and create a new table for that particular multivalued attribute.
So here in above ERD we can see there are multivalued attributes in three entities and those entities are as follows:
1. Worker
2. Customer
3. Permission
Worker Entity:
In worker entity we can see that worker can have multiple contact numbers and multiple emails so here we have to split the tables and this entity will split up in following way:
Worker Contact Entity:
Worker Email Entity:
Customer Entity:
In customer entity we can see that customer can have multiple contact numbers and multiple emails so here we have to split the tables and this entity will split up in following way:
Customer Email Entity:
Customer contact Entity:
Permission Entity:
Here in above ERD we can see that in Permission entity there can be multiple Permission Modules against a single Permission ID. So we will split up the table accordingly:
Permission Modules Entity:
Rest of the entities don’t have multivalued attributes so they are already in 1st NF
2NF:
For 2nd normalization form we will have to check partial key dependency. Firstly what is partial key, partial key means there is an attribute other than primary key and that attribute is part of the primary key.
Here in above ERD we can see there is no partial key dependency, it means all the entities are already in 2nd NF.
3NF:
In the 3rd normal form, we will have to check the transitive dependency in a way that dependency of non-key attributes on the other non-keys attributes.
Here in above ERD there is no transitive dependency exist in the entities so all the entities are already in 3rd NF.
Here is the ERD after Normalization:
ISAS 600 – Database Project Phase III Rubric
As the final step to your proposed database, you submitted your Project Plan. This document should communicate how you intend to complete the project. Include timelines and resources required.
Area
Does not meet expectations
Meets expectations
Exceeds expectations
A. Analysis – how will you determine the needs of the database
Did not identify appropriate plan for analysis phase
Identified appropriate plan for analysis phase
Identified appropriate plan for analysis phase and included additional content
Design – what process will you use to design the database (tables, forms, queries, reports)
Did not sufficiently identify detail on the appropriate process for design phase
Identified appropriate process for design phase
Identified appropriate process for design phase and included additional detail
Prototype/End user feedback – Will you show users a prototype before building the system?
Did not sufficiently identify method for feedback and prototypes during building of the system
Identified method for feedback and prototypes during building of the system
Identified method for feedback and prototypes during building of the system and provided additional detail
Coding – what process will you use to build the database?
Did not sufficiently identify appropriate process for coding the database
Identified appropriate process for coding the database
Identified appropriate process for coding the database and provided additional detail.
Testing – How will you test it?
to build the database?
Did not sufficiently identify appropriate process for testing the database
Identified appropriate process for testing the database
Identified appropriate process for testing the database and provided additional detail.
User Acceptance – describe the final step of determining if you met the user’s needs?
Did not sufficiently identify an appropriate process for User Acceptance phase – How to determine if the database meets user’s needs.
Identified appropriate process for User Acceptance phase – How to determine if the database meets user’s needs.
Identified appropriate process for User Acceptance phase – How to determine if the database meets user’s needs. Answer provided additional detail
Training – what is the plan for training end users?
Did not identify appropriate detail for training plan
Identified appropriate detail for training plan
Identified appropriate detail for a training plan and provided additional detail.
Project close out – what steps will you take to finalize the project?
Did not sufficiently identify appropriate steps for closing out the project
Identified appropriate steps for closing out the project
Identified appropriate steps for closing out the project and provided additional detail.