User Account

All Pages

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

  Create a database to control its local libraries

A county wishes to create a database to control its local libraries. Each library has a number of employees, one of whom is designated as the manager of the library and is responsible for supervising employees and the general day-to-day management..

  Create documentation describing the principles

Create documentation describing the principles and importance of normalization in relation to this project and the process by which this project was normalized.

  Database using entity-relationship diagram

Design the logical structure of a database using Entity-Relationship diagram - Apply normalization techniques to reduce redundancy in a database

  How are the two computer styles different

How did the management of data shift from a mainframe system to a PC-based computing system?

  Present a detailed data model for your project scenario

Present a detailed data model for your project scenario. You can create your data model using Microsoft Visio 2010, which you will have access to through iLab.

  Exhibiting all the primary keys and foreign keys

Draw the corresponding GRD, exhibiting all the primary keys and foreign keys. For simplicity, no other attributes nor multiplicity constraints are required.

  Beginning of the futuristic upcoming driverless- cars

Do you think that there is enough accountability with these companies as it pertains to data security - what are your thoughts about computing clouds or cloud

  Show sums of line totals for each invoice

Write SQL statements to answer the following questions - Show sums of line totals for each invoice. Find the customers whose balance is greater than 200

  Define the differences between data mart and data warehouse

Define and describe the differences between OLTP and OLAP databases.

  Produce a set of relations

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

  Draw at a context diagram and a level-0 diagram

Draw at a context diagram and a level-0 diagram. In drawing these diagrams, if you discover that the narrative is incomplete, make up reasonable explanations to complete the story. Provide these extra explanations along with the diagrams.

  Describe the ongoing maintenance that will be required

Be typed, double-spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd