Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

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.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91888580

Have any Question?


Related Questions in DBMS

Query 1 the bookstore has decided to keep track of the

Query 1: The bookstore has decided to keep track of the vendors' information. In order to do this, one new table will be added to the database. The schema for this table, as related to the existing tables, is the followi ...

Question create an erd for the following scenarioa small

Question: Create an ERD for the following scenario. A small company ABC wants a database to keep track of internal company information. Â Given the following information create an ERD. The ABC Company has several departm ...

Real time analytics - data analytics assignment -this is a

Real Time Analytics - Data Analytics Assignment - This is a business analytics project aimed at generating innovative analytics solutions for a Global Food Consulting firm working in the area of Animal agriculture and fa ...

A schools office of the registrar maintains data about the

A School's office of the registrar maintains data about the following entities: a) courses (including course number, title, credits, syllabus and prerequisites), b) course offerings (including course number, year, semest ...

Q1 given the following file for assignment workercom

Q1. Given the following file for assignment worker.com, identify data anomalies that must be removed before data can be loaded in data warehouse. Worker_assignment ← -----------------on course web site File is available ...

You can work on this assignment individually or in a group

You can work on this assignment individually or in a group of 2. If you are working in a group please establish a group in Assignment 2 Group on Canvas In this assignment you are asked to explore the use of neural networ ...

Question lab 1 creating a database designthis assignment

Question: Lab 1: Creating a Database Design This assignment contains two (2) Sections: Database Design Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Not ...

Question 1 describe 1nf 2nf 3nf2 explain why 4nf is a

Question: 1: Describe 1NF, 2NF, 3NF. 2: Explain why 4NF is a normal form more desirable than BCNF. The response must be typed, single spaced, must be in times new roman font (size 12) and must follow the APA format.

Systems analysis project scenic routes operates a bus

Systems analysis project Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways. Their slogan is: "It Takes a Little Longer, But It's Scenic." The firm nee ...

In sql developercreate a table userpermissions provide

IN SQL DEVELOPER Create a table UserPermissions (provide create and insert statements code) Document UserName Policy SYSTEM Menu JDOW W2 USAM Permissions SYSTEM W2 JDOW Form 1040 USAM Policy JDOW W2 SYSTEM Write a PL/SQL ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As