Modular HND Scheme Systems Analysis And Design WorkbookANSWER POINTERS

See ASCENT files or typed MS Word solutions on pg 5.

Example / NForders.asc / 1. / NFpurchase orders.asc / 2. / NFinvoice.asc
Word / Word / PO / Word / Invoices
3. / PECULIAR PRACTICE / 4. / NFtimesheet.asc / 5. / NFairlines.asc
Word / Percular Practice / Word / Time Sheet / Word
6. / NFmodule.asc / 7. / Choco / 8. / CV-Reg
Word / Word / Word / CV-Reg

a) Open the files in Ascent.

For data dictionary entry consult parts b, c and d

For normalisation entry consult parts e and f

b)To view data dictionary entry click on <DD> and <Choose Item>

c)Click on the Data Store for the following screen

d)By double clicking on ORDERS in the you will see the created data dictionary entry for the data store – ORDERS

e)To view normalised answers click on <Options> <Normalise>

f)Click on the Data Store for the following screen

CASE STUDY 1 :PURCHASE ORDERS

0NF

PO-0 (@po, podate, s#, sname, saddress, (p#, pdesc, cost, qty), pt#, pttype, staff#, staffname, staffext)

1NF

PO-1 (@po, podate, s#, sname, saddress, , pt#, pttype, staff#, staffname, staffext)

PO-PART-1 (@po, @p#, pdesc, cost, qty)

2NF

PO-2 (@po, podate, s#, sname, saddress, pt#, pttype, staff#, staffname, staffext)

PO-PART-2 (@po, @p#, cost, qty)

PART-2 (@p#, pdesc)

3NF

PO-3 (@po, podate, s#, pt#, staff#)

SUPPLIER-3 (@s#, sname, saddress)

PAYMENT (@pt#, pttype)

CONTACT (@staff#, staffname, staffext)

PO-PART-3 (@po, @p#, cost, qty)

PART-3 (@p#, pdesc)

CASE STUDY 2 :INVOICES

ONF

INVOICE-0 (@inv, invdate, c#, cname, caddress, deliverydate, deliveryarea, (p#, pdesc, qty, unit, sub-total), nett, vat, gross, pt#, pttype, staff#, staffname, staffext)

1NF

INVOICE-1 (@inv, invdate, c#, cname, caddress, deliverydate, deliveryarea, nett, vat, gross, pt#, pttype, staff#, staffname, staffext)

INV-PART-1 (@inv, @p#, pdesc, qty, unit, sub-total)

2NF

INVOICE-2 (@inv, invdate, c#, cname, caddress, deliverydate, deliveryarea, nett, vat, gross, pt#, pttype, staff#, staffname, staffext)

INV-PART-2 (@inv, @p#, qty, unit, sub-total)

PART-2 (@p#, pdesc)

3NF

INVOICE-3 (@inv, invdate, c#, deliverydate, staff#, staffname, , nett, vat, gross, pt#, staff#)

CUSTOMER-3 (@c#, cname, caddress,deliveryarea)

PAYMENT-3 (@pt#, pttype)

CONTACT-3 (@staff#, staffname, staffext)

INV-PART-3 (@inv, @p#, qty, unit, sub-total)

PART-3 (@p#, pdesc)

CASE STUDY 3 :PECULIAR PRACTICE

ONF

PP-0 (@Patient#,Patient Name, DOB, Doctor#, Doctor Name, (Date, Drug Code, Drug Name, Dose, Prescribing Dr, Prescribing Dr Name))

1NF

PP-1 (@Patient#,Patient Name, DOB, Doctor#, Doctor Name,)

PP-Prescription-1 (@Patient#, @Date, @Drug Code, Drug Name, Dose, Prescribing Dr, Prescribing Dr Name)

2NF

PP-1 (@Patient#,Patient Name, DOB, Doctor#, Doctor Name,)

PP-Prescription-1 (@Patient#, @Date, @Drug Code, Dose, Prescribing Dr, Prescribing Dr Name)

Drug-2 (@Drug Code, Drug Name)

3NF

PP-3 (@Patient#,Patient Name, DOB, Doctor#)

DOCTOR-3 (@Doctor#, Doctor Name)

PP-Prescription-3 (@Patient#, @Date, @Drug Code, Dose, Prescribing Dr)

Drug-3 (@Drug Code, Drug Name)

** Prescribing Dr is an alias of @Doctor#

CASE STUDY 4 :TIME SHEET

TT-0 (@Sales Person No., Name, @Week-No, Grade, Hourly Rate, (Project-Code, Project-Title, Hours-Worked) , NONE-PROJECT-HOURS, TOTAL-PROJECT-HOURS)

TT-1 (@Sales Person No., Name, @Week-No, Grade, Hourly Rate, NONE-PROJECT-HOURS, TOTAL-PROJECT-HOURS)

TT-Project-1 (@Sales Person No., Name, @Week-No @Project-Code, Project-Title, Hours-Worked)

TT-2 (@Sales Person No., Name, @Week-No, Grade, Hourly Rate, NONE-PROJECT-HOURS, TOTAL-PROJECT-HOURS)

TT-Project-2 (@Sales Person No., Name, @Week-No @Project-Code, Hours-Worked)

Project-2 (@Project-Code, Project-Title)

TT-3 (@Sales Person No., @Week-No, Grade, NONE-PROJECT-HOURS, TOTAL-PROJECT-HOURS)

SALE-PERSON-3 (@Sales Person No., Name)

GRADE-3 (@Grade, Hourly Rate)

TT-Project-3 (@Sales Person No., Name, @Week-No @Project-Code, Hours-Worked)

Project-3 (@Project-Code, Project-Title)

CASE STUDY 8 – CV-Reg

0NF

CV-0 (@cv#, cvname, cvaddress, a#, aname, b#, bname, age, dob, sex, licence, points, (lan-code, lan, lan-grade), (hw-code, hw, hw-grade), (sw-code, sw, sw-grade), (e#, ename, eaddress, jtitle, dur, paycode, payscale), (r#, rname, raddress))

1NF

CV-1 (@cv#, cvname, cvaddress, a#, aname, b#, bname, age, dob, sex, licence, points,

CV-LAN-1(@cv#, @lan-code, lan, lan-grade)

CV-HW-1 (@cv#, @hw-code, hw, hw-grade)

CV-SW-1 (@cv#, @sw-code, sw, sw-grade)

CV-EMP-1 (@cv#, @e#, ename, eaddress, jtitle, dur, paycode, payscale)

CV-REF-1 (@cv#, @r#,rname, raddress)

2NF

CV-2 (@cv#, cvname, cvaddress, a#, aname, b#, bname, age, dob, sex, licence, points,

CV-LAN-2(@cv#, @lan-code, lan-grade)

LAN-2(@lan-code, lan)

CV-HW-2 (@cv#, @hw-code, hw-grade)

HW-2 (@hw-code, hw)

CV-SW-2 (@cv#, @sw-code, sw, sw-grade)

SW-2 (@sw-code, sw)

CV-EMP-2 (@cv#, @e#, jtitle, dur, paycode, payscale)

EMP-2 (@e#, ename, eaddress)

CV-REF-2 (@cv#, @r#)

REF-2 (@r#, rname, raddress)

3NF

* AGENT-3 (@a#, aname)

* BRANCH-3 (@b#, bname)

CV-3 (@cv#, cvname, cvaddress, a#, b#, age, dob, sex, licence, points)

CV-LAN-3(@cv#, @lan-code, lan-grade)

LAN-3(@lan-code, lan)

CV-HW-3 (@cv#, @hw-code, hw-grade)

HW-3 (@hw-code, hw)

CV-SW-3 (@cv#, @sw-code, sw, sw-grade)

SW-3 (@sw-code, sw)

CV-EMP-3 (@cv#, @e#, jtitle, dur, paycode)

* PAY-3 (@paycode, payscale)

EMP-3 (@e#, ename, eaddress)

CV-REF-3 (@cv#, @r#)

REF-3 (@r#, rname, raddress)

1

SAD : ANSWER POINTERS & MODEL SOLUTIONS