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

  How referential integrity constraint prevent data

In physical database design, referential integrity constraints can be defined. What actions does referential integrity constraint prevent from happening when data is inserted in table which contains this constraint?

  Explain what they will change in dbms technology

Explain how they work and what advantages and disadvantages they bring.

  Describes the basics of database planning

The link should be to an informative piece that describes the basics of one of the following: Database Planning, SQL, Access 2010, Queries and Form Design

  Possible combinations of problems and technique

Discuss connections, similarities, shared issues, discrepancies, possible combinations of problems and techniques from the three papers, etc - What- ever you consider relevant, but with reasons and referring to the papers if necessary.

  How database systems support enterprise and web-based

how database systems support enterprise and web-based applications.

  Would not this result in pure gibberish most of the time

In a "chosen ciphertext attack" the attacker has the option of choosing the ciphertext sample and having it decrypted by someone who knows the key. Wouldn't this result in pure gibberish most of the time?

  Use data mining technique

The software MUST use DATA MINING TECHNIQUES (at least one like classification or association rule mining etc). The work involves analysing loads of the Hospitals data to search for the desired patterns.

  Prepare fully attributed data model

Use the results of the transcripts of an interview with IT consultant. Prepare a Fully Attributed Data Model. Add the data attributes for each entity."

  How to select the primary key from the candidate keys

A motor vehicle maintenance center wants to improve its services by using database management systems and data mining what tables are needed in such a database and how can it help improve their services

  Develop two select commands for each table

Develop two SELECT commands for each table. One of the commands for each table should use a WHERE clause to filter the records being returned.

  Create a database design specification

Create a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 301 Normal Form.

  Explore the database to understand what it is about

explore the database to understand what it is about then close your Microsoft Access

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