+91-9519066910
CAD:+1-604-396-3267 ,IN:+91-7503070001, IN:+91-9519066910
  • My Account
  • solution

    Programing

    Database Design & Development Assignment Help

    Rating:
    Database Design & Development Assignment Help


    Database Design & Development

    Submission Format:

    Part 1: The submission is in the form of an individual written report. This should be written in a concise, formal business style using single spacing and font size 12. You are required to make use of headings, paragraphs and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. Please also provide a bibliography using the Harvard referencing system. The recommended word limit is 2,000–2,500 words, although you will not be penalised for exceeding the total word limit.

    Part 2: The submission is in the form of a fully functional relational database system demonstrated to the Tutor; and an individual written report (please see details in Part 1 above).

    Scenario:
    Primark is an Irish clothing and accessories company which is a subsidiary of AB Foods, and is headquartered in Dublin. They are operating their business in all over the United Kingdom as well. They have an existing E-Commerce System but they are facing challenges in terms of proper data storage, information retrieval on demand and facing difficulty to generate sales and revenue report for the management. The director panel desire to expand their business e.g. they will allow other shops to display their product in their E-Commerce System for trading on commission basis. In these circumstances, top-level management has made a decision to reconstruct their E-Commerce System from scratch. They are ready to invest handsome amount of money for this purpose but they will not compromise the quality of the product. 

    They are planning to sell major categories of products e.g. Ladies Fashion, Gents Fashion, Household, Ornaments and watches, Bags, Shoes, Wallet and Belt. Each product category may contain sub category of products. Both product and sub product should have a name, description and the unit price where necessary. External Shop Owner will be able to register them with the system. Customers will be able to view the products posted by the different company or retailer. As soon as a customer places an order, both the customer and order information will be stored in the database. Order may have order detail e.g. multiple number of product at the time of order placement. Customers would be able to pay either by card or Paypal. As soon as payment verification process is completed the payment information should be stored into the Primark database. Multiple methods of payments are also allowed for a single transaction. Customers can place order as well as they can complain against any shop owner stored in M&S database. Shop owner will confirm the despatch of their product through their credentials. The despatch information should be recorded at Primark Database. 
     
    Individual retailer or external company can only post their product to the E-commerce application for sale if only they are approved by an admin user from Primark. Admin user will use the complaint record in order to approve the Retailer for trading. Primark wants to display featured ads at their front page. Feature ads are a matter of approval by the M&S user. Feature ads must have a start date and end Date for displaying purpose. Primark is more concerned about the following facilities from the system. 

    a)  Individual retailer will be able to register themselves with proposed system.
    b) Individual retailer can post their products to the portal for trading to customers. 
    c) Customers can place order of products from the system and order detail must be stored for further report and dispatching the cash to the respective retailer. 
    d) Customers can pay either by pay-pal or card and payment information should be stored for further reference.
    e) Individual retailer must be approved by the M&S admin user.
    f) Any company or retailer will be able to post featured ads at the portal front page. 
    g) An Inventory/stock will be maintained by product ID and Individual retailer ID.
    h) The product despatch information should be stored as well to the database. 

    Questions:  (Covering LO1, LO2)
    You have also been asked to design and develop of the database systems based on the user requirements from Primark Management.
     
    Part 1:
    a) Before you start the development process, your manager has asked you to produce a report for the CEO of Primark, containing:
     
    1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables.
    2. Clear statements of user and system requirements.  (Assessment Criteria: P1)

    b) You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include 
    Interface and output designs
     
    Data validations 
    Data normalisation  ( Assessment Criteria: M1)

    c) Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements. (Assessment Criteria: D1)

    Part 2
    a) Once the designs have been accepted by your manager you have been asked to develop the database system using evidence of user interface, output and data validations and querying across multiple tables. (Assessment Criteria: P2)

    b) You want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features. (Assessment Criteria: M2)

    c) You have decided to implement a query language into the relational database system. You need to perform the following queries to meet the criteria (Assessment Criteria: P3).
    i) List all the customers
    ii) Produce Sales Details Reports for a specific retailer.
    iii) Sales Details Report Group by Retailer.
    iv) Inventory Report for the retailer.
    v) Best sold product list pick top 5. (Assessment Criteria: P3)

    The developed system will be demonstrated to your manager. 
    Your manager has asked you to produce a report:

    d) Assessing whether meaningful data has been extracted through the use of query tools to produce appropriate management information. (Assessment Criteria: M3)

    e) Evaluating the effectiveness of the database solution in relation to user and system requirements, and suggest improvements. (Assessment Criteria: D2)