Develop a physical plan for data organization and storage

Assignment Help Database Management System
Reference no: EM131047219

The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. The suggested sections categorized by their phases for this project.

Phase 1: Requirement analysis

Title page (project name, author, and date)

Problem definition

Description of the proposed system

Logical model design

System context diagram (data flow diagrams and data dictionary)

Descriptions of processes or functions and features

Descriptions of outputs/inputs/performance/security or controls

Specific requirements (interface, operational, resource, performance, etc.)

Summary of cost/benefit analysis

Phase 2: System and database design

Physical model design

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?

a. The physical layout for each input

b. The input design and procedures

2. How data will be output from the system?

a. The physical layout for each output

b. The output design and procedures

Data design

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

1. Database design

* Database tables with their attributes and the implementation is not required

2. Entity-relationship diagrams

3. Data file storage and access

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 that there is no other required software package except MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the planning part requires and for other parts, you can use any word editing software or any drawing tools software.

Reference no: EM131047219

Questions Cloud

Markets would be inefficient if irrational investors : Markets would be inefficient if irrational investors_____ and actions of arbitragers were_____? A) existed; limited B) did not exist; unlimited C)Existed; limited D)did not exist; limited E)the statement is false, markets are always efficient
Discuss the different methods a multinational firm : Discuss the different methods a multinational firm can take in managing its foreign currency exposure.
Find the cost of exactly matching the liabilities : A company must pay liabilities of 3,000 and 5,000 at the end of years 2 and 4. The available investments are a 2-year maturity, 1000 Par zero-coupon bond with an effective annual yield of 5.5%, and a 4-year 100 Par zero coupon bond yielding 6.8%. Fin..
Risk-free rate of return-what is the expected return : The beta of M Simon Inc., stock is 1.4, whereas the risk-free rate of return is 0.06. If the expected return on the market is 0.16, then what is the expected return on M Simon Inc?
Develop a physical plan for data organization and storage : Develop a physical plan for data organization, storage, updating, and retrieval. Estimating completion time and costs.
Develop and implement a portfolio management program : Spring 2016- 412: Information Systems Case - develop and implement a portfolio management program for a 5 physician clinic and you will develop/implement a business intelligence plan for a hospital
What is value of returnvalue after given code has executed : What is the value of returnValue after the following code has been executed?x = "150";y = "100";returnValue= x - y; Which of the following uses correct syntax to receive a value stored in totalCost?
Characteristics of blue cross and blue shield plans : a. Describe the major characteristics of Blue Cross and Blue Shield plans.b. Why do many employers self-insure (self-fund) their group medical expense plans?
Range has already been narrowed to an 11-point range : e range has already been narrowed to an 11-point range.

Reviews

Write a Review

Database Management System Questions & Answers

  What types of relationships are possible in a database

Define operational excellence. How can information systems help achieve it? What types of relationships are possible in a relational database? Describe and give an example of each.

  Explain what is the purpose of database

Explain what is the purpose of Database? The purpose of a database is to store information about certain types of objects. Give an example of two related TABLES.

  What factors will influence how you design the database

The small publishing company you work for wants to create a new database for storing information about all of its author contracts. What factors will influence how you design the database?

  What is system r and what are its two major subsystems

What is System R? What are its two major subsystems? How is the data structure of System R different from the relational structure? What is Data Independence?

  Prove that the decomposition of r into r1 and r2 is lossless

Let R be a relation schema with a set F of FDs. Prove that the decomposition of R into R1 and R2 is lossless-join if and only if F+ contains R1 ∩ R2 → R1 or R1 ∩ R2 → R2.

  Demonstrate academic and professional literacy

Demonstrate academic and professional literacy by collating theoretical and practical course material into a workable application through understanding concepts and their practical application using .NET.

  Problem related pseudocode for a game application

Create the pseudocode for a game application that contains an array of five (5) multiple-choice questions related to your favorite hobby. Each question contains four answer choices - A..., B..., C..., D...

  Objectivesto analyse and comprehend a provided er diagram

objectivesto analyse and comprehend a provided er diagram and database schemato implement a database based on the

  Develop a system sequence diagram for each use case

Write out the steps of the dialog between the user and the system for the use case Place new order for nursing home employees.

  Create an e-r diagram of entities, attributes & relationship

Using the script file below to create an E-R diagram of the entities, attributes and relationship.

  Database distribution strategy

Database Distribution Strategy. For this assignment, you will design and develop a distributed database infrastructure for an organization of your choice. You may use the database you created in another unit or you may choose to create a new datab..

  Discuss the relationship between colossal and core patterns

Discuss the relationship between colossal and core patterns. What is boosting? State why it may improve the accuracy of decision tree induction? Ensemble methods improve classification accuracy. How?

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