CSC800813 - Information Systems

Choose Your Topic

All Subject Accounting Finance Engineering Science Computer Science

Economics Management Writing Mathematics Statistics Law Auditing Nursing Childcare Others

CSC800813 - Information Systems

Question Preview:

View Complete Question >>

Question Preview:

[CSC8008] [Turn Over] NEWCASTLE UNIVERSITY INFORMATION SYSTEMS Time allowed - 3 Hours Instructions to candidates: Answer ALL questions The total marks available for this exam are 100 Marks shown for sub-sections are indicative only SEMESTER 2 2012/2013 [CSC8008] Page 2 of 4 Read the following scenario and answer all the questions following it: A theatre wants to install a purpose-built, computer system that will allow customers to browse through the shows that are running or that will run in the future, and book seats for these performances. These systems will be located in a special area in the foyer of the theatre. When browsing, customers should be able to see detailed information about the shows, times when shows are on, and the availability, pricing and location of seats. The system should be designed for use by all the theatre’s potential customers and take into account any special requirements they may have. The staff of the theatre must also have an interface to the system, not only for maintenance (such as adding/removing shows, setting prices and changing availability information), but also so that they can work with customers who ask for help. The theatre also wishes to provide similar services to Internet users. They would expect their website and in-house systems to be well integrated, but both should suit the expectations and skill levels of their target users. [CSC8008] Page 3 of 4 Question 1 – Interaction Design a) Including a description of any relevant hardware, outline a possible design for the interface to each system below. Use pictures and diagrams where appropriate. Describe the human factors and accessibility issues that you considered when creating your design. i) the customer interface units. [15 marks] ii) the staff systems. [10 marks] b) Several sets of principles have been proposed for describing various aspects of usability. Use illustrations drawn from the interface you propose for the shopping system to show how some of these principles can be applied in a design. [15 marks] c) What methods might you employ to evaluate the usability of the system after you have implemented it? Describe the strengths and weaknesses of these methods, and recommend the most suitable for this case. [5 marks] d) Discuss the advantages and disadvantages of using a single, web-based interface everywhere rather than having three different interfaces. [5 marks] [CSC8008] Page 4 of 4 Question 2 – Databases a) Explain why you would advise the theatre to use a database management system rather than using a special purpose file based system. [4 marks] b) Define the following terms: i) Entity [2 marks] ii) Attribute [2 marks] iii) Primary Key [2 marks] c) Draw an entity/relationship diagram describing the database needed to support the theatre booking system described by the scenario above. Read the questions below and make sure that you can use the database you describe to answer the queries they ask for. [20 Marks] d) Based on your E/R diagram, construct SQL statements for the following: i) Create the database tables including any relevant primary and foreign keys [6 marks] ii) Display the names and performance dates and times of shows that are sold out [4 marks] iii) Display all the bookings made by a customer called “Harold Pinter” [4 marks[ iv) Display the number of seats still available for the performance of the show “Top Hat” on the 22nd March 2014 at 7:30PM [4 marks] v) Delete all the bookings for the show “Mama Mia” on 1st July 2014 [2 marks]

View Less >>

Solution Preview

After clicking the relationship link , in below window at miscellaneous tab the 0, 1 or many is shown. Please, follow this by opening the er diagram file in visio. Or, I can write the 0, 1 or many in the above relationship link

question Get solution

$45

Orginal Price : $58.50

Pay Now

Upload Assignments

Get Your Assignment

Don’t delay more, place your order now. Quick assignment help will be offered to you.

Order Now

CUSTOMER REVIEWS

Excellent

Based on 702 reviews See all reviews here

One of the Best Service

I trust LiveWebTutors for my assignments because of their ability to deliver the perfect assignments time and again. Only a few of my assignments required minor revisions. The rest assured it is the best assignment writing service in the market.

Elizabeth
Sydney

Great Service and on time

I felt so exhausted and burdened with the large number of assignments I had to write and desperately needed someone to help me with all the writing and there was LiveWebTutors company on the internet. They finished my assignments before the due date and also offered me a first-timer discount.

Christina
Perth

One of the Best Assignment Provider

I ordered my Mathematics and Marketing assignments from them last month. I received the content on the set date. Most importantly, the assignments were well-written and plagiarism free. I scored a top grade for the assignment written by them. They are a reliable company.

Oli
Brisbane

Very Helpful Customer Service

I was quite unsure about getting my assignment written online but after coming across LiveWebTutors.com, all my worries have vanished. The quality of the assignments written by their writers is just invincible. Their customer support is very polite and helpful. You should try their service at least once

Kabir
Adelaide

Let Us Help You

shopping cart 0

Amount Payable : $0

World's Leading Assignment Library

Choose Your Topic