Skip to content

Ict2621 Assignment 3 2015

Unformatted text preview: A schema is simply a list of each table name and its fields/attributes in a database as in the example below. Product (Product-Code, Product-name, …) Customer (Customer-ID, Customer-name,…) etc … Note that, in the given ERD: • Not all fields are provided for each entity. • Some fields may not be necessary for some tables. • Primary keys and FKs are not shown. ICT2621/101 31 Client Health-Care Organization Name Address Client Unit Name Address Floor Wing Drug ChemicalName Prescription StartDate StartTime EndDate EndTime Quantity Frequency SpecialInstructions Patient Number Name DateOfBirth Sex RoomNumber Order Date StartTime EndTime DrugItem UnitType UnitDosage QuantityOnHand ReorderPoint ReorderQuantity Price Pharmacist LicenceNumber Name Manufacturer Name Address DrugItemPackage UPC PackageType PackageQuantity BrandName Price OrderItem PatientName RoomNumber ChemicalName Manufacturer UnitType UnitDosage Quantity Frequency SpecialInstructions Price Question 4 [17] Scenario: For any country, in the mobile phone industry, a cell phone manufacturer brand has a number of cell phone models. The way to identify a specific cell phone is by use of a manufacturer’s brand name and the model. A customer can own a number of cell phone models, and each model is owned by many customers. Finally, there is a relationship between customers and mobile phone service provider companies (providers). 4.1 Assuming that each country has more than one mobile service provider (as is the case in most countries), clearly describe (in words) the relationship between a customer and a provider and vice versa. (2) 4.2 Draw an entity relationship diagram (ERD) for this mobile phone management system scenario for one country. Note that the scenario includes the relationship between customers and service providers. The ERD should not contain any many-to-many relationships. Do not include entities that are not in the scenario. No attributes/fields are required for this part of the question. (9) 32 4.3 Create a relational database schema from the ERD your designed in question 4.2, showing all tables in 3NF. Each table should include at least three fields. Appropriate primary keys should be used. Primary keys must be underlined and each foreign key should have the letters FK in brackets after it, for instance, xyz (FK). (6) Chapter 11 – Managing system implementation Question 5 [7] Draw Figure 11-12 found on page 457 of your prescribed book then explain how the main and sub-modules of this structured chart work together, i.e. what each module/sub-module does and how data is interchanged. (7) Question 6 [10] For sections 6.1 and 6.2, briefly describe each with respect to implementation of a system....
View Full Document

2 Assignment 2 Solutions Total for this Assignment: 50 marks Marking scheme Question 1 (10 Marks) Introduction (3), body (5) and conclusion (2) Question 2 (20 Marks) 2.1 (5), 2.2(5), and 2.3 (10) Question 3 (20 Marks) 3.1 (5), Any acceptable answer for 3.2.1 or 3.2.2 or 3.2.3 (5) Any attempt of 3.3 (5) Any good attempt of 3.3 (10): that is with coding and print preview even if it is not 100% correct Question 1 Write a well-planned essay to explain and discuss the design of applications. You may focus on: 1-Problem solving using procedure-oriented vs OOED approaches, 2-The planning and creation processes of an OOED application, 3-The building of a user interface in an OOED application The essay should be about one to two pages and include: an introduction , a body , and a sensible conclusion . Question 2 We want to write a program to calculate the water bill when the user clicks on a button called bill. Two readings in kiloliters are entered into textboxes called oldread and newread. A label called yourbill must be used to show the total bill for the month. The price of water per kiloliter varies. Consumption up to and including 4 kiloliters costs R5 per kiloliter. Consumption over 4 kiloliters to and including 9 kiloliters costs R3 per kiloliter. Consumption over 9 kiloliters costs R2 per kiloliter. A person who used 6 kiloliters will pay R5 per kiloliter for the first 4 kiloliters and an additional R3 per kiloliter for the other 2 kiloliters consumed. Calculate the water consumption from the two readings given and display it in the label called consumption. The two meter reading must be validated. Readings are valid when both are numeric and if the old reading is smaller or equal to the first reading. If any reading is invalid, the appropriate textbox must be selected so that new input may be typed. The procedure must not be allowed to execute any further. In each case, an appropriate error message must be displayed in a message box. Focus must be returned to the control from which the exception originated. 2.1 Plan this project properly and present the result in a TOE chart. Answer: Task Object Event