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: 

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:  

Video: How do I normalize a database: 

cle

Article:  

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

Sample of a Diagram with many tables:

ISAS 600 – Database Project Phase II Rubric

Assignment:

Create and submit an ER Diagram with at least two tables (one for each table of your proposed database).

Your diagrams should exhibit;

· Some amount of normalization (first, second and third normal forms)

· Primary and Foreign keys are identified

· Type of field (text, currency, numeric) and field length is included

2

>
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.

3

>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.

3

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