How data will be output from the system

Assignment Help Database Management System
Reference no: EM131323821

Warehouse management system project

Project Deliverables

The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project software for their project schedule.

The following layout format covering a title page and all three phases is recommended for the project.
Title page (project name, author, and date)

Phase 1: Requirement analysis

A. Problem definition
B. Issues
C. Objectives
D. Requirements
E. Constraints
F. Description of the proposed system
G. Logical model design

1. Data flow diagrams

• Context diagram
• Diagram 0
o Diagram 1(Diagram 1 is optional)
• Descriptions of processes in each diagram

2. Descriptions of outputs/inputs/performance/security or controls

H. Specific requirements, if any (interface, operational, resource, performance, etc.)

Phase 2: System and database design

A. User interface

Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.

1. How data will be input to the system?

• The physical layout for each input
• The input design and procedures

2. How data will be output from the system?

• The physical layout for each output
• The output design and procedures

B. Data design

Develop a plan for data organization, storage, updating, and retrieval.

1. Database design

• Database tables with their attributesshould be presented
• Primary key(s) should be identified in each table, if any
• Three steps of normalization should be included.

2. Entity-relationship diagrams

3. Data file storage and access

C. System architecture

Determine the architecture of the system as Web-based interface, client/server architecture, Internet/Intranet interface, network configuration, etc.

Phase 3: Project plan

A list of tasks or activities needed for implementing the proposed system

Estimating completion time and costs

A project schedule for performing those activities (Gantt charts or PERT charts)

Note: you are only required to use the MS Project software to handle the scheduling part of the project and for other parts, you can use any word editing software or any drawing tools software.

Reference no: EM131323821

Questions Cloud

Show the original and new budget constraint : Ralph usually buys one pizza and two colas from the local pizzeria. The pizzeria announces a special: All pizzas after the first one are half-price. Show the original and new budget constraint. What can you say about the bundle Ralph will choose w..
Describe the stringent ethical compliance : The field of research in psychology is paramount. In the section on competencies, it is expected that psychologists understand and know the research in their fields, with particular attention paid to evidenced-based interventions. It is through re..
How do her budget line and opportunity set change : Draw her budget line. If she receives $100 in food stamps and $200 in a housing subsidy (which she can spend only on housing), how do her budget line and opportunity set change?
Create a brief narrative explaining the sequence diagrams : Create a brief narrative explaining the sequence diagrams. The narrative should be written for someone who does not understand how to read a sequence diagram.
How data will be output from the system : How data will be output from the system? Develop a plan for data organization, storage, updating, and retrieval. A list of tasks or activities needed for implementing the proposed system.
Examine the major theoretical approaches : Assess the types of personality measurements and research designs used in in the peer-reviewed articles you researched. Briefly describe the main theoretical models represented within each of the perspectives of personality and explain the commona..
Explain why more women are entering the workforce : Give an example of disparate treatment.- Explain why more women are entering the workforce compared to previous years.
Show a possible income-consumption curve for don : Don spends his money on food and on operas. Food is an inferior good for Don. Does he view an opera performance as an inferior or a normal good? Why? In a diagram, show a possible income-consumption curve for Don.
Determine the appropriate wire diameter in inches : Design a steel helical spring for a minimum volume that will carry a static load of 200 lbs with a deflection of 2.0 inches. Determine: the appropriate wire diameter in inches and the total number of coils

Reviews

Write a Review

Database Management System Questions & Answers

  Implementation of virtual private databases

SQL implements VPD using the VIEW object while Oracle10g provides specific functions for row-level security and fine-grained access.

  Assignment related to agency database

Design a data model that will conform to the following criteria: a. Propose an efficient data structure that may hold the tour operator's data using a normalization process. Describe each step of the process that will enable you to have a 2nd Norm..

  Database upgrade

Database Upgrade Using research notes and Oracle documentation plan and execute an upgrade of an installation of Oracle 10g to Oracle 11g release 1. To do this you must show in screen shots and written notes

  Display the data using the customer table

Display the data using the customer table to verify that the change has been made. Construct a view on the customers tablecalled CA_CUSTOMERS that consists of all data about customers that live in California.

  Each technician is an expert on one or more plane model

Each technician is an expert on one or more plane model(s), and his or her exper-tise may overlap with that of other technicians. This information about technicians must also be recorded.

  Brazilian federal data processing service

Examine the proposed business ethical problem that the Brazilian Federal Data Processing Service is presently experiencing. Determine whether you agree or disagree that Brazil's problem is an ethical one that should be corrected. Provide a rationa..

  Create a new test02 class

Write a toString method that will return a String containing all the relevant data for each of your objects.

  Analyzing the use of databases in a business environment

Prepare a 2- to 3-page APA formatted paper analyzing the use of databases in a business environment. Include what database applications should be used: Microsoft Access, IBM DB2, Oracle, and so on

  An er diagram for the system

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

  Write name of employee on every project located in houston

Write the name(s) of employee(s) who works(work) on every project located in Houston. Write the name(s) of employee(s) who only works(work) on every project located in 'Houston.'

  Design and implement an appropriate relational database

ST10126 Database design and application - Implement the theory of databases as they are configured and managed within up to date business information systems and implement an appropriate database design for a given scenario.

  Object-oriented client database assignment

Imagine that a customer has come to your team and has requested a simple application that will allow the customer to store client names, addresses, and telephone numbers. The application will be written as a console app

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