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.

(a) Draw a BRD for the accept quotation use case. (5 marks)

(b) Construct an EST for the BRD

in (a). (5 marks)

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 then

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.

Q1 Create an EDD and a CDD based on the information below. (8 marks)

The Pergola Man operates in the northern suburbs of Perth,

building pergolas and gazebos for private customers. When a customer approaches

him, he visits their house, takes measurements and then discusses possible

pergolas or gazebos which might interest the customer. As a result of this

discussion, the Pergola Man sends the customer a detailed quotation (see

below). The customer may or may not accept the quotation. If the customer

accepts the quotation, the Pergola Man does the work and in due course the customer

is sent an invoice for the work done. The Pergola Man allows part-payments over

six months in order to encourage more business.

The Pergola Man is considering creating a website as a means

of attracting new customers. He anticipates the website will allow customers to

browse examples of his work, browse company details including likely prices and

timescales, email him with a request for a visit and permit (part-)payment of

invoices.  Quotation and Invoices are

sent out via the web site.  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 can log in to

see their invoices.  Customers will use

PayPal to pay invoices via a link on the site. 

They don’t need a PayPal account to pay by credit card.

A use case diagram does not show