Develop a physical plan for data organization storage


The research project will materialize everything we will study during the course. You will practice the application of the concepts we are studying.

I. Project

Purpose:The purpose of the individual system analysis and design project is to demonstrate student's ability to apply the knowledge learned in this course to a real-world project.

Topics Suggestion: You can find them in next discussion topic. The below list is meant to be suggestive and if you have an idea about a specific topic, please consult with me early to determine if it is suitable for the course.

Suggested Project Topics

• Internet shopping sites (clothing, shoes, books, music, or others)
• Local real estate agency system
• Rental system (car, video, or others)
• Warehouse management system
• Student record system
• Banking system
• Insurance purchase system (life, medical, homeowner, or others)
• Credit card management system
• Library circulation system

Project Deliverables

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 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.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Develop a physical plan for data organization storage
Reference No:- TGS01516429

Expected delivery within 24 Hours