Design relational database system for a substantial problem

Assignment Help Database Management System

Reference no: EM133569840

Unit 4 Database Design And Development

Assignment Title - Information Systems Design Exercise

Learning Outcome: Use an appropriate design tool to design a relational database system for a substantial problem

Assignment Brief:

Seek out an organisation in need of an information system, or an information system upgrade. Formulate a Problem Definition to define the current problem(s) and any desired additional functionality for the new prototype system.

Apply systems investigation (employing fact-finding techniques) to identify the data held within the system and the information needed to carry out the operational functions of the organisation. Ensure you include document analysis.

Upon identifying the data and informational requirements apply data analysis methods to best structure the data to meet the client's needs.
Use Data Flow Diagrams (DFDs) to track the flow of data through the system.

Use appropriate design methods to formulate a complete logical model(ERD& Normalisation to 3NF)for the new\improved system.

Your design MUST have at least 4 related tables.

Include Storyboards/Wireframes for the design of your input and output.

Include suitable input masks and validation in your Data Dictionary.

Assess the effectiveness of the design in relation to user and system requirements.

Fully document each stage of the analysis and design of the system.

Attachment:- Database Design And Development.rar

Reference no: EM133569840

Questions Cloud

Describe the role of mitochondria in the human body : Describe the role of mitochondria in the human body. Identify which type of cells/tissues typically has the most associated mitochondria, and explain why.

What skin condition causes patches one nipple : What skin condition causes patches one nipple?

How would this application of sunscreen affect the skin : How would this application of sunscreen affect the skin? Why was their physician concerned about their bone health?

How does the improved forecast affect the demand : How does the improved forecast affect the demand lost by Green Thumb because of understocking? Use cost and price information from Exercise 1

Design relational database system for a substantial problem : Unit 4 Database Design And Development - Formulate a Problem Definition to define the current problem(s) and any desired additional functionality

Discuss the reasons why you arrived at your hypothesis : PS380 Multicultural Psychology, Ashworth College - How will you measure or research what it is you're hoping to prove or learn more about

Describe slow-wave sleep and rem sleep : Describe how these processes contribute to the abuse of either alcohol or opiates - Describe slow-wave sleep and REM sleep

Explain how the methods are used to study genetic : PS350 Biological Psychology, Ashworth College - What are some of the difficulties you may experience when going to work on Monday

Calculate and predict the motion of the roller coaster : Describe and involve applying these principles to calculate and predict the motion of the roller coaster cars, such as speed, acceleration

User Account

All Pages