Develop a physical plan for data organization and retrieval

Assignment Help Database Management System
Reference no: EM131132055

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.

Reference no: EM131132055

Questions Cloud

How might lenders use safes tax information to verify portio : How might lenders use safes tax information to verify portions of the financial statements?
Create a table that depicts the runtime for arrays : Create a table that depicts the runtime for arrays of length 1 to 10. Would you expect the general runtime to be O(n), O(n2), O(n3), or some other function of n? Explain.
Calculate probability that both transistors are defective : Box 1 contains 1000 transistors, of which 100 are defective, and box 2 contains 2000 transistors, of which 100 are also defective. A box is taken at random and two transistors are drawn from it, at random and without replacement.
How should hr advise the ceo in this situation : Analyze a successful business partnership, indicating which of the four factors were present. Analyze a failed business partnership, indicating which of the four factors were absent. Is it possible for a business partnership to succeed when none of t..
Develop a physical plan for data organization and retrieval : Develop a physical plan for data organization, storage, updating, and retrieval. How data will be output from the system? How data will be input to the system?
Estimate the impact campus crime : Using the information in Table 1, would you prefer to use Model 1 or Model 3 to estimate the impact campus crime has on new student enrollment?  What evidence is there to support your answer
The market value of common stock is usually : Retained earnings is the total amount of cash and other assets paid in to the corporation by stockholders in exchange for capital stock.
What is the probability of obtaining a red ball on any draw : If we obtained a red ball on each of the first n draws, what is the probability that we are using urn A?
Analyze hr executives outsourcing decisions : What has been left unaddressed in the Human Resource Competency Study? Explain your concern or rationale in thinking something might be missing.

Reviews

Write a Review

Database Management System Questions & Answers

  Data dictionary serves as important data management tool

The data dictionary serves as an important data management tool by? assigning attributes to the data, maintaining data in updated form.

  Assignment related to er diagram

Question 1: How clear andwell-presented your submission is. Question 2: E-R diagram:adherence too your standard,assumptions made,in clusion of correct primary and foreign keys,appropriate entities,relationships,and attributes.

  Presentation for your database life cycle project

Develop a PowerPoint slide presentation for your Database Life Cycle Project

  Create a new table in which to store publisher information

In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table

  Explain the idea for database and partitioned view

Explain the idea for the database along with the thoughts for partitioned view. How would you utilize this partitioned view?

  Prepare a set of non-functional requirements

Need a system that networks its 3 campuses in the US and one campus in Singapore. Transaction data for all campuses should be available to all locations. In addition, students should be able to use the Internet to view classes, enroll, register, and ..

  Identify the primary key of mpd

Create a SQL Select Query to pull Product_ID, Product_Description and Units_Sold for Product 85773 from the CSS.Sales table. Hint: do not use the CSS prefix in your query

  Create a query using the simple query wizard

Start Access. Open the downloaded Access file named exploring_a02_grader_h1. Create a new table in Datasheet view using the name Donations. Switch to Design View and change ID to DonationID. Add the following field names to the table: DonorID, Plan..

  Create the primary and foreign key using a uml class diagram

Create the primary key and foreign keys using a UML Class diagram for each table and compare and contrast the key aspects that each system offers

  Optimize the query in the select script using alter table

optimize the query in the select script using Alter Table to add appropriate indexes. Also use Optimize and Explain to show how the performance of this query has improved.

  Is the data nominal ordinal ratio or interval

What type of data and level of measurement does the Ethnicity variable represent: Is the data discrete or continuous? Is the data qualitative or quantitative? Is the data nominal, ordinal, ratio, or interval?

  Elaborate further on the definition of information systems

Review some of the tools you use whether at home or school that helps turn the data we are exposed to into information for making decisions.

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