Stage 1: Scenario and Conceptual Database DesignTask 1.1: Selection of the case upon which the database design and implementation is to be based First, you need to identify a suitable case study (your choice or a choice from the list provided in the appendix) from which to derive your database requirements. This may be a situation based on a company with which you are familiar or in which you are (or have been) employed, or may be one (or b...
Stage 1: Scenario and Conceptual Database DesignTask 1.1: Selection of the case upon which the database design and implementation is to be based irst, you need to identify a suitable case study (your choice or a choice from the list provided in the appendix) from which to derive your database requirements. This may be a situation based on a company with which you are familiar or in which you are (or have been) employed, or may be one (or base...
Task 1.1: Selection of the case upon which the database design and implementation is to be basedFirst, you need to identify a suitable case study (your choice or a choice from the list provided in the appendix) from which to derive your database requirements. This may be a situation based on a company with which you are familiar or in which you are (or have been) employed, or may be one (or based on one) that you have read about within the t...
Project RequirementsRead the following case study and then carry out the required tasks. Midlands Technological University (MTU) is a 3rd level provider of Level 6,7,8 and 9 QQI recognised programs serving principally the counties of the midlands area of Ireland. MTU Students Union (MTU SU) is the representative body for all students (full time and part time ) in MTU. All registered students are automatically registered as members of the Stud...
Business Description (Scenario) for the AssignmentYou have been asked by the manager of the Star Trek Games rental shop to replace their existing system for recording rentals. Information about the shop is provided below Note: the following information was collected during an investigation of the Star Trek Games Rental Shop Star Trek Games Rental shop holds numerous games from a number of different developer companies. Previously the shop ke...
Client BriefThe aim of this assessment is to assess the student’s ability to solve business problems using database design tool and software. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An ...
Franchising model and IT systems at Stimpy3.1 Case study: Developing a Data Management Strategy for Stimpy Stimpy is a multi-national chain of fast-food restaurants. Like many fast-food chains, they operate a franchising model where, as the franchiser they license their know-how, procedures, intellectual property, use of their business model, brand and rights to sell their branded products and services to individual franchisees. In return, the f...
Learning OutcomeLearning Outcome LO 1 Explain database concepts, and principles of data modelling, process modelling and systems development project management, and apply them in designing a simple workgroup-based business application to meet user requirements in a multi-user environment. LO 2 Demonstrate an understanding of a systems development project life cycle by developing and implementing the workgroup-based business application in line...
Task 1.1: Selection of the case upon which the database design and implementation is to be basedTask 1.1: Selection of the case upon which the database design and implementation is to be based First, you need to identify a suitable case study (your choice or a choice from the list provided in the appendix) from which to derive your database requirements. This may be a situation based on a company with which you are familiar or in which you a...
Learning OutcomesThis project (Assignment 1 and 2) is designed to assess students’ knowledge and skills related to the following learning outcomes: 1.Discover or elicit requirements using a variety of techniques 2.Organize and prioritize requirements 3.Apply analysis techniques such as needs analysis, goal analysis, and use case analysis 4.Validate requirements according to criteria such as feasibility, clarity, freedom from ambiguit...
ContextBased on your responses to Assessment 1 – Written assessment, perform process and data modelling and develop and document a number of design diagrams using UML (including Context Diagram, Level 0 and Level 1 Data Flow Diagram, Entity Relationship Diagram). In Assessment 1, you performed a comprehensive requirement analysis for the online student enrolment system at the ABC University. With an in-depth understanding of the funct...
Question 1: Select All Data in a TableAgain, to complete the following 10 questions. When the questions for this assignment do not specify which rows to show in the results, assume that all rows should be shown. Similarly, when the questions do not specify which columns to show in the results, assume that all columns should be shown. When the questions specify that only certain columns should be included in the results, this does n...
Task to Complete1. Perform normalisation to 3NF for the data depicted in the sample documents. Note that only one normalisation is required for the function room evaluation, you have been provided with two samples so you can appreciate some of the variety which occurs. The approach you are required to use is the same approach as shown in the normalisation lab solution (see QB and QC). The normalisation must begin by you representing each of th...
Task 1: Creating a Context Diagram for the SystemThe Subject Learning Outcomes demonstrated by successful completion of the task below include: a) Identify, critically evaluate and recommend information systems solutions for inefficiencies in business processes, procedures and work practices using data and process modelling techniques. b) Formulate, validate and document business requirements for a medium-scale information system development...
Initial Entity-Relationship ModelThis coursework is about the design and implementation of a product monitoring service for a retail outlet.Study the ‘PC Land’ case study carefully and then submit the following:1. Draw an initial Entity-Relationship model, stating any assumptions you make.. &n...