ssadm简易分析案例.docx

Robin.LuoSSADMBackground of OrganizationThe Infinite Antique LTD (IA LTD) is a 45 years old Hong Kong antique company which sells kinds of antiques to corporate or new customers. It has a system but it is not a computerized and automatic. Thus it requires a new system for its order system which can be computerized and automatic.Most antiques are in the store (sale department) to sell. Customers can make orders to buy these antiques. Orders are usually carried out by the clerks of the sale department, they can work on one or more orders at a same time. Also one order can be covered one or more items. Each department of the IA LTD has a manager. When a customer places the order(s), the clerk will require some customer detail to check the customer is a corporate or a new customer. If it is a new customer, the clerk will require more customer detail to record into the database, and a customer ID will be given after finishing the recording the details. All the customers details are store in the sale department database. Due to the antiques are the special items, so all the customers have to check the items which they want to purchase by themselves before the customers and the sale department manager placed and signed for the orders.Although one clerk can carry out more than one order for customers, sometimes one customer could make more than one orders for his/her items.If a customer is not able to make a decision about if buy or not, the customer can make an order to hold the antiques. But the customer has to pay 10% charge of the total item(s) price as the deposit after both he/she and the sale department manager signed for the order. Then the IA LTD will hold his/her antique(s) until the customer made the decision or next 30 working days later. And the customer will receive the invoice to prove he/she has paid the deposit. If the customer made the decision to pay for the left money in the next 30 working days, both the customer and the manager need to sign for the order again after checking the item(s). Also the customer will receive a new and invoice. If the customer has not made the decision before the expiry day, the LTD will never hold these items for him/her. And the money the customer paid as the deposit will never return to the customer. But the customer can use the deposit invoice as the cash coupon to buy any items in the IA LTD. If any customers paid the deposit or full payment for the orders, sale department manager will send the order detail to the account department. The account department manager will record the order detail and create an invoice for the order.There are a number of other invoices and orders will be generated for each deal. 1. Reports:All the reports (order and invoice) are shown like follow:1.1 Order for IA LTDOrder ID: Order start date:Order Clerk ID: Order Clerk Name:Customer ID:Customer number:Customer address:Customer E-mail:Product NameProduct conditionPriceSignature:1.2 Invoice for IA LTDInvoice ID:Issue date:Payment type:(Note: payment types are “credit card” “cash” “pay with cash coupon”.)Product NamePriceTotal price:Record order detailBusiness Process ModellingCheck Item availabilitiesCustomer places orderCheck Customers basic informationExisted customerOut of expiry dayMark order to “expiry”Create a new invoiceMark invoice typeRecord invoice detailAccount manager creates an invoice Mark items to “Hold”Sign for the orderNew customerCreate new customer IDRecord customers detailSend invoice to customerMake invoice copies10% paymentMake paymentFull paymentMark order type to “Hold”Mark order to “done”Clean the left paymentSign for the orderDecide to buyReject orderCreate an invoiceSigned order detailsItem availability detailsSigned ordersPayment detailsPayment InvoicesNew customer detailsNew customer detailsNew OrdersCustomerInvoicesNew OrdersAccount managerInfinite Antique LTD Order SystemSale mangerContext Diagram Level 1Data Flow DiagramItem availability detailsItems listCustomer basic informationInvoice CustomersInvoice detailsInvoice detailsD4 Invoices8 Account DepartmentSend invoice to customerSale managerNew customer detailsItem availability detailsItems listInvoice detailsAccount manager7 Account DepartmentCreate new invoiceCustomer basic informationD1 Customers Signed order detailsD2 OrdersD3 ItemsNew customer details6 Account departmentMake payment5 Sale DepartmentCheck Item availabilitiesPayment detailsPaymentSigned orders4 Sale DepartmentSign for orderNew orders details2 Sale DepartmentCheck Customer basic informationNew orders3 Sale DepartmentRecord customer detailsNew ordersNew customer details1 Sale DepartmentRecord order detailsCustomersRelational Data Analysis1. Relational data analysis for order.UNFLevel1NF2NF3NFAfter testOrder ID1Order IDOrder IDOrder IDOrder IDClerk ID1Clerk IDClerk IDOrder start dateOrder start dateOrder start date 1Order start date Order start date Order markOrder markOrder end date1Order end dateClerk nameOrder end dateOrder end dateClerk name1Clerk nameOrder markSignatureSignatureCustomer ID1Customer IDOrder end date*Clerk ID*Clerk IDCustomer name1Customer nameSignatureCustomer IDCustomer IDCustomer address1Customer addressCustomer IDCustomer Email1Customer Email*Clerk ID*Clerk IDProduct ID2SignatureCustomer IDClerk nameClerk nameProduct name2Order markCustomer nameProduct condition2Customer addressCustomer IDCustomer IDPrice2Order IDCustomer EmailCustomer nameCustomer nameSignature1Product IDCustomer addressCustomer addressOrder mark1Product nameOrder IDCustomer EmailCustomer EmailProduct conditionProduct IDPriceProduct nameOrder IDOrder IDProduct conditionProduct IDProduct IDPriceProduct nameProduct nameProduct conditionProduct conditionPricePrice2. Relational data analysis for invoice.UNFLevel1NF2NF3NFAfter testInvoice ID1Invoice IDInvoice IDInvoice IDInvoice IDIssue date1Issue dateIssue dateIssue dateIssue datePayment type1Payment typePayment typePayment typePayment typeOrder ID1Order IDTotal priceTotal priceTotal priceProduct ID2Total pricePaid amountPaid amountPaid amountProduct name2Paid amountinvoice typeinvoice typeinvoice typePrice2invoice typeOrder IDOrder IDOrder IDTotal price1Paid amount1Invoice IDOrder IDOrder IDOrder IDinvoice types1Product IDProduct nameInvoice IDInvoice IDInvoice IDPriceProduct IDProduct IDProduct IDProduct nameProduct nameProduct namePricePricePriceNote: No need doing anything for 3NF at relational analysis for orderAfter Relational data analysis, the all entities need to be created are1. Order: Order ID, Order start date, Order mark, Order end date, Signature, *Clerk ID, Customer ID2. Clerk: Clerk ID, Clerk Name3. Customer: Customer ID, Customer name, Customer address, Customer email4. Product: Product ID, Product name, Product condition, Price , Order ID, 5. Invoice: Invoice ID, Issue date, Payment type, Total price, Paid amount, Invoice type, Order IDLogical Data ModellingInvoiceInvoice IDIssue date Payment typeTotal pricePaid amountInvoice typeOrder IDProductProduct IDProduct name Product condition Price Order IDCarries outMade byHasHasPlacesPlaced byBelong toOrderOrder IDOrder start DateOrder mark Order