Describe the main theories of relational database approach

Assignment Help Management Information Sys

Reference no: EM132348283

INFORMATION SYSTEMS

SECTION A

Answer TWO questions out of FOUR in Answer Book A.

A1. You have been appointed to investigate and to design an on-line system for a large garage dealing with vehicle repairs and annual maintenance. A customer will contact the garage to book in a vehicle for repairs or annual maintenance. The system will check whether the customer is an existing customer or a new one.

If he/she is an existing customer then the details will be displayed and confirmed. If he/she is a new customer then details will be required such as name, address, vehicle type, make, and car registration number. The system will then be used to find an appropriate time slot for the repair or maintenance. Once confirmed by the customer, the system will need to allocate a suitably qualified engineer to carry out the job. A time slot will be allocated to the engineer’s records.

At the appropriate time, the customer will bring the car in for the work to be done. The engineer will inspect the car and carry out the repair/maintenance. Sometimes a spare part may be required which is not in stock. The engineer will raise a purchase order with the car parts supplier, inform the customer of the delay and will stop the job until the spare part arrives. Once the job has completed the customer will be informed and the job will be paid for and the car collected

a) Draw a Context Diagram and a set of Data Flow Diagrams to depict the above system.

b) Draw a Data Model identifying the main Entities and Relationships indicating the degree of relationship and optionality.

c) Draw an entity life history of the entity job.

A2. a) You are the head of a systems development team who has a number of impatient users. Draft a report explaining the advantages and
disadvantages of a structured approach to system development compared with a prototyping approach suitable for these users. Identify the stages within each approach.

b) Briefly describe the purpose and typical contents of a Feasibility Report

A3. a) Discuss how information flows in a typical organisation hierarchy giving examples of the type of information at each level.

b) Briefly describe the use of the following types of commercial software systems:

i) Executive Information Systems

ii) Management Information Systems

iii) Transaction Processing Systems

c) Describe the main theories of a relational database approach to storing and accessing data.

A4. a) As manager of a large systems development project, describe the steps you would take to ensure that a project is produced on time.
(NOTE – the system development life cycle is not expected).

b) After development and testing, a system can be installed in several different ways according to the type of system. Describe THREE
possible ways this can be done, identifying advantages and disadvantages of each.

c) “There are several threats to an on-line system”. Discuss this statement and identify ways of preventing unauthorised access to the
system’s data.

SECTION B

Answer FIVE questions out of EIGHT in Answer Book B.

B5. You have been asked to produce a job description for a Business Analyst. What characteristics should they have and why?

B6. What do you consider to be the most important aspects of Human Computer Interaction (HCI) and why?

B7. What should be a computing code of conduct for an employee?

B8. “Video wastes bandwidth, text can represent information more clearly and uses less resources.”

Discuss this statement, stating whether you agree or disagree with this statement and why.

B9. What screen design elements could be used for developing an on-line questionnaire to determine the functions a person uses on their mobile phone?

B10. A small company has asked that you suggest a backup plan for their database. The database only operates for 12 hours a day and you have been asked to provide a solution that does NOT use tapes or CDs/DVDs.

Discuss how and when the database can be backed up and comment on any dangers to your approach.

B11. What is meant strategic by, tactical and operational information? Give two examples of each.

B12. a) What is meant by the following statistical terms?

i) Mean

ii) Mode

iii) Lower quartile

iv) Standard Deviation

b) What is a histogram and what is its primary function?

Reference no: EM132348283

Questions Cloud

Transfer to relevant stakeholders for a project : What are ways that project financials can be finalised, including their transfer to relevant stakeholders for a project?

Estimating is a critical part of project planning : Estimating is a critical part of project planning, involving a quantitative estimate of project costs, resources or duration, (Leybourn, E. (2016).

Statistical thinking for business improvement : Ben Davis had just completed intensive course in Statistical Thinking for Business Improvement, which was offered to all employees of large health maintenance.

Project estimates as there are just too many variables : It is impossible to obtain accurate project estimates as there are just too many variables.

Describe the main theories of relational database approach : BCS HIGHER EDUCATION QUALIFICATIONS BCS Level 4 Certificate in IT INFORMATION SYSTEMS -Draw an entity life history of the entity job.

How land would be used on washington street : Know what the debate was regarding how land would be used on Washington Street when deciding how to replace the elevated Orange.

What elements of a project lend themselves : What elements of a project lend themselves to using a RFP rather than a RFQ?

Network design for small campus networks : 4CC523 - Networking Fundamentals - University of Derby - Local Area Network Design - Demonstrate the ability to select appropriate hardware and media types

Why do you think the pepsi had faced so much backlash : Why do you think the Pepsi had faced so much backlash? If Pepsi had used another celebrity do you believe the same backlash would have happened?

User Account

All Pages