Describes how the proposed system is to be built

Assignment Help Database Management System
Reference no: EM13876898 , Length:

Assignment

15 written pages in length (workflow, screenshots, and graphics can be included for clarity - counted separately from the 15 pages)

Create a company and choose a product. Use the SDLC to define an ES system that integrates TWO of the following process for this product:

1) Procurement process (Chapter 3 - Essentials of Business Processes and Info system)

2) Fulfillment process (Chapter 4 - Essentials of Business Processes and Info system)

3) Production process (Chapter 5 - Essentials of Business Processes and Info system)

The paper should discuss all aspects of the SDLC (from a functional point of view)

• The investigation/analysis/design describe the steps in a fully integrated end-to-end process.

• The design uses chapter 1-5 from the Technology Guide to discuss options for Hardware, Software, Clouds, Intelligent systems, etc.

• The final steps within the SDLC should include supports for an end-to-end process.

Team Paper outline

System Investigation

During this phase, the user identifies the information system and nature of the work that must be done for the information system. The work to be done usually is expressed as a problem statement that is a definition of the deficiencies in the information system or of the improvements desired.

System Analysis

Required to understand and document the user's needs for the system. Documents in detail the scope, business objectives and requirements of the system. Emphasizes what the system is to do.

Includes analysis of what data need to be created/replicated

In this step, the team identified above works with the current and future system users to define and model the current business processes in detail.

Flow-charting and workflows are common tools used in this step of the SDLC

This information is then analyzed and a model is devised for the new system that meets the needs of the business.

System Design

Describes how the proposed system is to be built to satisfy the requirements from the analysis section. Designs for all required information system outputs, files, inputs, application software programs, and manual procedures are identified.
In this step, specific technical designs are created to the smallest detail.The design is specific to the technical requirements the system.

Describes movement of data between operational databases

System Implementation
Limited in scope

Verified Expert

Reference no: EM13876898

Design the database by developing fully attribute data model

Design the database by developing a fully attributed data model. The model should show all tables. Each table should have a primary key and may have foreign keys. Every fiel

List the names of any pair of boats that have the same type

List the names of any pair of boats that have the same type. For example, one pair would be Anderson II and Escape, because the boat type for both boats is Sprite 4000.

Diagram and determine the possible iterative steps

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in

What kind of information will be included in the database

To design a database, a database planner should spend a considerable amount of time thinking about what kind of information will be included in the database and how it will

Write sql statements to calculate average salary

Write SQL statements that do the following: Calculate the average salary for all employees. Calculate the maximum salaries for exempt and non-exempt employees.

Create an internal dtd for the xml document

Create an internal DTD for the XML document above, write the whole XML document - Create an external DTD for the XML document above, write the whole XML document by linking t

Create a second normal form logical database model

You are then to create a second normal form logical database model and explain why you made the changes from the first normal form database using the second normal form rule

Description of the current database software

Describe the Oracle Software file structure you wish to use. You may use OFA, or not. But identify where all the files (dbf, ctl, ora, etc.) will go on the servers. If you d

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd