CS13ato Sample Assessment Questions Q 1 Create an EDD and a CDO basad an the information beiow. (S marks) The Persola Man operates in the northern suburbs of Rerth, building pergolas and gatebos for private cuntomeis. When a customer approaches him, he visits their housf, tabis me asurenents and then discusses possible pergolas or gatebos which might interest the cyrtomer. As a result of. This discussion, the Pereola forn sends the customnt a detailnd cuotation fsee below). The customer may or mary not accept the quotation. If the customer accepts the quotation, the Prepcla Man does the work and in doe course the customer is sent an lnvice for the work done. The Perkola Nan allows part.payments over. six months in order to encourage more businesi: The Pergola Man is considering creating a website as a means of attracting new customers. Me anticipates the website will allow customers to browse examples of his a ork, browie company details inclucing likely prices and timescales, emall him with a request for a visht and permit (partOpayment of imvoices. Quotation and Invoices are sent out vis the web site. Both the Pergola Man and his customers need to login to use some functions of the site. When iogred in, the Pergola Man can create and delete users of the web site as well as mocify user detalls such as their passwrards or email addresses. The Pergola Man can also send quotations and lhvolices, as wel as use an email form when logged in. Customers can log in to see their invoices. Customers will use PayPal to pay invoices via a liek on the site. They don't need a Pay Pal account to pay by credit card. Q2. Draw a use case diagram that covers the future system as described in the previous question. (7 marks). Both the Pergola Man and his customers need to login to use some functions of the site. When logged in, the Pergola Man can create and delete users of the web site as well as modify user details such as their passwords or email addresses. The Pergola Man can also send quotations and invoices as well as use an email form when logged in. Customers must log in to see their invoices, but they don't need to log in to accept a quotation. They are sent an email with a link. If they accept a quotation, Pergola Man is sent a message to create a user account for the customer, which will thei automatically email the customer his/her user account details. If the customer chooses not to accept a quotation, Pergola Man is sent a message indicating that the customer is not interested. (a) Draw a BRD for the accept quotation use case. (5 marks) (b) Construct an EST for the BRD in (a). (5 marks) Q4. Draw a logical relational data model for the proposed system. Be sure to include primary and foreign keys in your model. (15 marks) The Pergola Man has many customers. Each customer has a unique customer number (the name, address, phone and email of each customer is also stored). Customer credit card details are not stored in the system. The Pergola man can construct two types of building, pergolas and gazebos. Each quotation has a unique identifier, quotation number. Each quotation contains the customer details, the construction type and description as well as a list of the materials used to construct the pergola or gazebo. The quotation also lists the number of hours spent on the job and the cost per hour. The cost per hour can change over time
