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

  Write a select statement that returns three columns

Write a SELECT statement that returns three columns: EmailAddress, OrderID, and the order total for each customer. To do this, you can group the result set by the EmailAddress and OrderID columns.

  Creates a user-defined database role named orderentry

Write a script that creates a user-defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table. Give SELECT permission for all user tables.

  What are the limitations of conventional approach

1. What are the limitations of conventional approach of managing data? Explain.2. For what record size will clustering be of no benefit to improve performance? Can a table have clustering on multiple fields simultaneously?

  Create a database for a human resources group.

State assumptions in creating the DB and underlying database objects. Use Access to create DB and tables.

  Objectives of file management principle

What are the requirements to ensure the objectives of file management principle is realized?

  Briefly summarize the results of the process

Import your data into IBM SPSS software using your assigned data set. Save the data file for future use, and use IBM SPSS software to compute frequencies on all appropriate variables. Briefly summarize the results of the process in 50 to 70 words

  Create a tree that models of the scenario

Create a tree that models the following scenario. A player decides to play a maximum of 4 times, betting on red each time. The player will quit after losing twice. In the tree, any possible last plays will be an ending point of the tree.

  Create oracle database tables

Create Oracle database tables using SQL Data Definition Language (DDL) for each table listed in Project 1. Make sure that entity and referential integrity are enforced by declaring a primary key for each table (these may be composite keys) and dec..

  Explain the dangers of the sequence of statements

Explain the dangers of the sequence of statements in part (a) above, in terms of what would happen in case the database server or SQL interface were to crash in between two of these three statements.

  How will your team c

What steps will your team take if you need to seize any digital evidence and What documentation processes will you follow to help support any potential legal proceedings?

  Convert data model to a set of virtual windows

You are to design a prototype for a hospital management system. Design a data model for this system, Convert the data model to a set of virtual windows.

  Identify the title of the research database

Describe (in your own words) the research database or collection of research including the purpose and the subject matter it covers:

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