Determine the architecture of the system

Assignment Help Database Management System
Reference no: EM132163504

Topic: Student record system.

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.

Project

The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project software for their project schedule.

The deadline for the Individual Project can be found in the schedule section of the class syllabus.

The following layout format covering a title page and all three phases is recommended for the project.

Title page (project name, author, and date)

Phase 1: Requirement analysis
A. Problem definition
B. Issues
C. Objectives
D. Requirements
E. Constraints
F. Description of the proposed system
G. Logical model design
Data flow diagrams
Context diagram
Diagram 0
Diagram 1 (Diagram 1 is optional)
Descriptions of processes in each diagram
Descriptions of outputs/inputs/performance/security or controls
H. Specific requirements, if any (interface, operational, resource, performance, etc.)

Phase 2: System and database design
A. User interface
- Design an overall user interface consisting of screens, commands, controls, and features to enable users to use the system.
- How data will be input to the system?
- The physical layout for each input
- The input design and procedures
- How data will be output from the system?
- The physical layout for each output
- The output design and procedures

B. Data design
- Develop a plan for data organization, storage, updating, and retrieval.
- Database design
- Database tables with their attributes should be presented
- Primary key(s) should be identified in each table, if any
- Three steps of normalization should be included.
- Entity-relationship diagrams
- Data file storage and access

C. 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 the MS Project software in this ITEC-630 course. As a result, you are only required to use the MS Project software to handle the scheduling part of the project and for other parts, you can use any word editing software or any drawing tools software.

Verified Expert

"This is a database management system development assignment. The assignment demonstrates three phases including requirements analysis, system and database design, and a project plan. It is a detailed report on the system analysis and design. It also contains the project plan file and various diagrams on system design."

Reference no: EM132163504

Questions Cloud

Great recession affected employees stress levels : How have the responses of businesses to the Great Recession affected employees’ stress levels?
Discuss best practices for hiring top talent : Prepare a PowerPoint presentation consisting of 8 slides per student not including the cover slide and the reference slide.
Developed bullets that explains key points for your paper : Each of these outline sections will need to have well developed bullets that explains key points for your paper.
How is one of the leadership skills applicable to disasters : How do emergency managers use different leadership skills in order to cope with stressful situations? Choose one of the following: team-based, authoritative.
Determine the architecture of the system : Design project is to demonstrate student's ability to apply the knowledge learned in this course to a real-world project
Describe in detail what position will be each block : Describe in detail what position will be each block, which also represents a position within your business. You only need to create the top three tiers.
What are some of the strategies that firms engage : Evaluating the benefit an opportunity can provide is complex. When measuring an economic benefit, you must look at the real return, the nominal return.
Decision using the steps in the decision making process : Think about a decision you've recently made. Write a description of this decision using the steps in the decision making process as your guide.
How was definition of ethics different from your classmates : What is legal and what is ethical are not always aligned. In fact, ethics are not considered primary when the law is already established.

Reviews

len2163504

11/11/2018 7:58:02 PM

I need this solution by noon 11th August with good structured language. Please adhere to instructions on the questions and Free of plagiarism and report. I also want an Expert in the field information System Analysis and design to handle this write up

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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