1. Define the terms flat file database and relational database. [ 4 ]
2. With reference to your the case study, describe how data management issues could affect the booking systems; refer to the case study. [4]
3.With reference to lines 115-119, examine two of the methods of payment that could be provided on PTC's new website. [6]
4. Discuss the importance of the language sustainability on the website and it's user interface which will be needed to make the website user friendly. Make sure to use information from the case study and any other examples if possible. [12]
1. Define the following terms:
(a) CMS
(b) Tablet device
2. (a) With reference to the case study and to Customer Management Systems (CMS) you have studied through your research, explain the the implications of using such systems for an online booking system.
(b) With reference to the case study (lines 127-131), examine how important it is for the website to be fully functional on a tablet device as it would on an internet browser using a desktop or laptop.
3. Discuss the importance of the website to allow for concurrency of access and its implications.
Use information from the case study and give examples of services offered by the companies that you have investigated.
4. Describe the term ACID.) 4 marks)
(a) Explain what is meant by customer relationship management (CRM) system and how is it beneficial in PTC's case by referencing to lines 105-107. (6 marks)
5 (b) With reference to lines 115-119, examine two of the methods of payment that could be provided on PTC's new website. (8 marks)
6Distinguish between a distributed database system and a centralized datab lines 153-155 (12 marks).ase system
1. Define the term flat file database and relational database. [ 4 marks ]
2. 2. (a) The Malzerei Theatergruppe has developed the M-ticket web site running on an ISP. Explain why the company can not depend on the M-ticket web site. [ 6 marks ]
3. (b) With reference to lines 76 - 78, examine the use of making use to the managements new technology such as, Twitter and social web sites. [ 8 marks ]
4. Discuss the importance of the language provision and web site interface which will be included in the website. Use information from the case study and give other examples from which you have studied in class. [ 12 marks ]
Describe two methods of booking on the new website.
2 ways for the customer to pay online would be via credit card or paypal.
(b) Describe 2 ways Couer Theatral can attract people to its new website.
3. Discuss the social and ethical implications of this new site for the people and the
1) Define the following terms:
a. Plug-ins (2 marks)
b. Record Locking (2 marks)
2 (a) With reference to the case study and to what you have studied, distinguish between content management system (CMS) and customer relationship management (CRM) system lines 104-107. (6 marks)
2 (b) With reference to the case study and to specific examples that you have studied, examine how each of the two databases – distributed database system and/or centralized database system lines 154-155 may help PTC in providing better anagement and processing of data. (8 marks)
3 . Once PTC develop a new system, it will have to take into account several issues – Project management issues, data management issues and website development and management issues. Taking into consideration the special circumstances of the case study as well as using your knowledge from what you have studied. To what extent could these issues make the proposed solution (line 80) regarding PTC be too expensive or impractical – Lines 135-175? (12 marks)
1. Define the following terms: a. Mail merge
b. Smartphone [2]
2. a. With reference case study, explain he issue s faced with the current booking system [6]
b. Examine the impacts method of payment of online booking. [8]
3. With references to lines 97 – 134, discuss i s that considered when developing system [12]
1. Identify and describe the 2 database type system. [4marks]
2. (a) Since there is no electronic connection to the office network, all sales and customer data is transferred to the office network using a USB stick. Give and explain 2 positive and 2 negative impacts to the group by using a standalone central computer. [8 marks]
(b) With reference to lines 75-78, discuss the use of new technologies such as smartphones, Twitter and social websites as a promotional tools in the future by MTG. [8 marks]
3. Discuss and evaluate the use of multimedia content and friendly interface on the website.
Use information from the case study and give examples of other companies that you have investigated. [12 marks]
1. (a) Define record-locking [2marks]
(b) Define client-side software [2marks]
2. (a) Distinguish between centralized database system and distributed database system [6 marks]
(b) With reference to lines 75-78, discuss the use of new technologies such as smartphones, Twitter and social websites as a promotional tools in the future by MTG. [8 marks]
3. The PTC is planning on adding non-Latin language such as Russian and Arabic in their website (line 120-125) . Discuss and evaluate the advantages and disadvantages of using other language than their main 4 language.
Use information from the case study and give examples of other companies that you have investigated. [12 marks]
2.a) The PTC needs to meet requirements for modern database systems (line 156), explain how the ACID rules will help to meet these requirements.
b) With reference to lines 62 - 78, examine how to over come two problems related to MTG's IT system
3. Discuss the use of the ideas suggested in lines 114 - 134 as ways of attracting a diverse range of customers
Please analyze the news items from the links below ;
http://abclocal.go.com/kgo/story?section=news/7_on_your_side&id=8374859
http://www.miamiherald.com/2007/11/04/290769/online-booking-common-complaints.html
http://www.bbc.co.uk/news/business-11372689
