Create and submit an ER Diagram with at least two tables and their attributes.  Your diagram should include:

• Table Names (for each entity)
• Attributes (first name, last name, city, etc.)
• Primary Keys
• Foreign keys
• Relationships
• Field types  (text, currency, numeric, date)

Your tables should be should be normalized (first, second and third normal forms)

You can use the attached form or upload your tables in Excel or create and link them in an Access database file.

For information on how to use Word to create and ERD, go to: https://vimeo.com/18244802

You can upload your tables in Excel, Word or create and link them in an Access database file.  If you use another tool please create a PDF file of the results.

Resources for Building ER Diagrams and Normalization:

What is an ER Diagram: http://databases.about.com/od/specificproducts/l/blentity-relationship-diagrams.htm

Video Tutorial Entity Relationship Diagram (ERD) Training Video:  https://www.youtube.com/watch?v=-fQ-bRllhXc

Video: How do I normalize a database: https://www.youtube.com/watch?v=xoTyrdT9SZIcle

Article:  https://support.microsoft.com/en-us/help/283878/description-of-the-database-normalization-basics

Sample of a Diagram with many tables:

Database Project Charter/Business Case

Khalia Hart

University of Maryland Global Campus

February 21, 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= $15000 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	3	$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