Skip to main content

INST2005 Database Systems | Assessed Design Exercise 2017

Image
By

Database Systems

Some friends of yours are hoping to set up a data driven website to support their home business selling second-hand children clothes, and have asked for your advice on the database design side. They need a database to list all the available items for customers to purchase, and also want to have a user comments system so that visitors can give feedback on purchased items as well as buy them. They are not database experts, and they have asked you to devise a database model they could use. Their ISP has said they can mount and operate a database on their account if given a set of relational tables, which describe it, so this is ultimately what they want you to produce.

As a minimum, they would like to store the following information about each item of clothing: the kind of garment, colour, size, material, gender (where appropriate), condition, age, and how much it costs, plus feedback once sold, if available. For customers they would want to record name, postal address, email address and date of birth.

They would like to be able query, which customers bought, which item, what items have been sold & their feedback, and what are still available
Customers should be able to perform three actions: search for clothing by various parameters, order items, and give feedback on items bought.

The site will not handle financial transactions per se but will pass data on to a separate transaction site for payment, so you do not have to worry about handling the cash aspects transaction, but the database must be capable of providing a set of data (like a “purchase order”) containing the details of the customer (but not his/her payment information!), the item(s) being purchased, and the cost - a customer may order one or more products at once. It will also need to include the date the order is made. Over time customers should be able to make any number of purchases and comments.

The Requirements

Design and develop an E-R-A model suitable for the project assigned above. Identify all entities, attributes and relationships in the model, and the primary keys for all entities. All data in the model should be normalised to 3NF, with the normalisation process demonstrated in full. You should document any and all assumptions you may make, and provide reflective design notes.

What you'll get:

1. An accurate and properly notated E-R-A diagram of your model. A hand-drawn diagram is entirely adequate, but should be drawn neatly and scanned for electronic submission. You may break your model down onto several sheets for clarity if you so wish.
2. A set of design notes of no more than 1000 words detailing any assumptions you have made and commenting on your design decisions and the design development process (e.g. what issues did you have to resolve, how did you resolve them and why, what happened in.


Buy now

CONTACT DETAILS

For any other questions or other tasks please feel free to contact me
via email: mhassnainjamil@gmail.com
via WhatsApp: +92-324-7042178
via skype: hassnainjamil1
Labels:

Comments

Post a Comment

Popular posts from this blog

The Zoo Management System - entity relationship diagram & MS Access Database

By
Zoo Management System - Project Details: You are the employee of a big, worldwide working Zoo Management Company. Your company is responsible for the Zoo management. Your boss thinks it would be a great idea to store all data for each Zoo in a brand new self-developed ZOO Management System. Up to now, the ZOO management company has maps of each ZOO available. Your boss knows that you took a course in introduction on an ERP system, so he asks you if you could help designing such a system. Each ZOO must have the same organizational structure, which should look like this: Each Zoo has a Zoo-Address. Each Zoo has many visitors (Visitor Ticket Process (VTP). Many Zoo-Attractions belong to a Zoo. Module 1: Entity Relationship Diagram Design a ER (entity-relationship) diagram for your ZOO Management System. Use the information provided below with the entities and its attributes. Put the entities in the correct relationship to each other (organizational structure). Module 2: DB Implem...
1 comment
Read more

Human Physiology by Stuart Ira Fox [PDF] (12th edition) free download

By
21 comments
Read more

Sudoku Game Project in Java with full source code including GUI task

By
Introduction The purpose of the project is to try in practice the use of recursion and object-oriented program design. Please make sure to read this entire note before starting your work. Pay close attention to the sections on deadlines, deliverables, and exam rules. The problem Your task in this part of the project is to write a solver for Sudoku puzzles. Sudoku puzzles are a kind of crossword puzzles with numbers where the following two conditions have to be met: In each row or column, the nine numbers have to be from the set [1,2,3,4,5,6,7,8,9] and they must all be different.  For each of the nine non-overlapping 3x3 blocks, the nine numbers have to be from the set [1,2,3,4,5,6,7,8,9] and they ust all be different. The following two figures show a Sudoku puzzle and its solution. The input The input of your program, the Sudoku puzzles, is given in text files. More specifically, they are represented as nine lines of nine characters separated by spaces. The characters can be of two...
Post a Comment
Read more