As part of the formal assessment for the programme you are required to submit a Database Design assignment. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments.
After completing the module, you should be able to:
1) Demonstrate a knowledge and understanding of databases and data management systems.
2) Understand key principles of relational database design techniques.
3) Transform a logical database design into a physical database design for a target database management system.
4) Apply knowledge and understanding of database design and development to design, implement, test, document and evaluate a
relational database solution for a given scenario.
5) Use appropriate problem-solving techniques.
Your assignment should include: a title page containing your student number, the module name, the word count; the appendices if relevant; and a reference list in Arden University (AU) Harvard format. You should address all the elements of the assignment task listed below. Please note that tutors will use the assessment criteria set out below in assessing your work.
Please note that exceeding the word count will result in a reduction in grade proportionate to the number of words used more than the permitted limit.
You must not include your name in your submission because Arden University operates anonymous marking, which means that markers should not be aware of the identity of the student. However, please do not forget to include your STU number.
Speciality Antique Search’ is a UK-based company that focuses on locating, restoring, leasing and selling a wide range of antiques. They do not specialise and are interested in any quality item over 20 years old. Some items may be from the 1980s, others from the 1680s and all periods in between. They group their items into the following categories:
• Militaria (guns, holsters, bayonets, knives, uniforms, medals etc.)
• Furniture (chairs, cupboards, cabinets, tables etc.)
• Clothing (anything over 20 years old is classed as ‘period’ and very collectable)
• Clocks & Watches (of every possible description)
• Optical (binoculars, microscopes, telescopes, tripods etc.)
• Electrical (early radios, irons, washing machines, cookers and even televisions)
• Sporting Goods (fishing tackle, airguns, footballs, tennis rackets etc.)
• Motors & Mechanical (cars, car parts, car accessories etc.)
• Assorted (Anything not falling into one of the above categories)
They source their antiques from many places, including private sellers, auction houses, estate sales, house-clearance companies and other dealers. Sometimes the sellers contact the company via their website/office, other times the company discovers a seller during one of their many ‘freestyle picking’ trips where they explore specific parts of the country in their van, often being away for 2-4 weeks at a time. They have a large van and stay in local hotels when away from home. They can pay by cash, card, bank transfer or PayPal. Once acquired, the specific item will either:
• Be sold immediately (if in good condition) in their own local retail store (London)
• Be sold immediately (if in good condition) on their website (they sell globally)
• Be appraised for an accurate value by an external expert, then sold as above
• Be repaired (if broken, but otherwise in good condition) then sold as above
• Be restored (if in poor condition) by an external expert and then sold as above
• Be retained and leased out to the film and TV industry as a prop (very lucrative)
• Be retained and added to the personal collection of one of the staff/directors*
*In this case, the individual concerned can pay the company the original ‘cost price’.
As well as the London retail shop and an attached office, the company also have a large storage warehouse in Cirencester in the
Cotswolds – a major antiques hub in the UK where much expert advice is available, and rents are much cheaper. The external
restorers, repairers and valuers are based across the UK. They need to store and process data
concerning: cost price, selling price, item description, seller and buyer details, associated dates and all company
expenses, including external experts, travel, accommodation, etc.
The organisation needs a database to run all the above operations. Your job is to design and build this database. The above is simply an outline of the company and you will need to make your own assumptions and interpret or even extend the scenario as you go. Use your imagination as you see fit, but you must clearly document all assumptions and extensions.
Develop a semantically rich data model that captures the above scenario in the form of an entity-relationship diagram (ERD). You should note (and number) all assumptions you make about the data and the reasoning behind your design choices. Also, include (and number) any appropriate constraints and a list of entity types showing their attributes and identifiers. (20 marks)
Once you are satisfied that the ER diagram is a good representation of the organisation’s data requirements, produce a logical design by mapping the ER diagram to a set of normalised relations – to third normal form (3NF). You should annotate and explain this process.
Take each of the normalised relations and implement them as SQL tables using an appropriate DBMS – such as Oracle, MySQL or another one you have access to – and a series of CREATE TABLE statements. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate such as NOT NULL, CHECK, UNIQUE and DEFAULT. Provide screenshots of the working code. Ensure your user name or some other distinguishing aspect is included in the screenshot to verify it is your code.
Using appropriate sample data and your own imagination based on this case study, populate your finished tables with at least 10 rows of data in each table. Provide screenshots of the working code. When done, display the full contents of each populated table to screen and take screenshots. Ensure your user name or some other distinguishing aspect is included in the screenshot to verify it is your code.
To demonstrate that your final database is useful, write a set of realistic sample SQL queries based on the above scenario (use your imagination for details of each query) but they should include the following techniques:
• Joins (using two, three or more tables)
• Ordering output (ORDER BY)
• Grouping output (GROUP BY)
• Aggregate functions (MIN, MAX, AVG, COUNT, SUM)
You should aim to write at least ten sample queries – ranging from basic
SELECT…FROM…WHERE queries to more advanced ones using the above techniques. Be sure to fully evidence all SQL work by taking screenshots of the inputted code and the outputted results. Ensure your user name or some other distinguishing aspect included in the screenshot to verify it is your code. (35 marks)
You have the opportunity to submit a single draft of your report to receive formative feedback. The feedback is designed to help you develop areas of your work and it helps you develop your skills as an independent learner.
Your work must be submitted to your tutor on or before two weeks prior to the assessment submission date. This is to allow time for you to reflect on the feedback and draft your final submission.
Formative feedback will not be given to work submitted after the above date.
You MUST underpin your analysis and evaluation of the key issues with appropriate and wide ranging academic research and ensure this is referenced using the AU Harvard system.
The My Study Skills Area on iLearn contains useful resources relating to referencing.
You must use the AU Harvard Referencing method in your assignment.
Students are required to indicate the exact word count on the title page of the assessment.
The word count excludes the title page, tables, figures, diagrams, footnotes, reference list and appendices. Where assessment questions have been reprinted from the assessment brief these will also be excluded from the word count. ALL other printed words ARE included in the word count See ‘Word Count Policy’ on the homepage of this module for more information.
Assignments submitted late will not be accepted and will be marked as a 0% fail.
Your assessment should be submitted as a single Word (MS Word) or PDF file. For more information please see the “Guide to Submitting an Assignment” document available on the module page on iLearn.
You must ensure that the submitted assignment is all your own work and that all sources used are correctly attributed. Penalties apply to assignments which show evidence of academic unfair practice. (See the Student Handbook which is on the homepage of your module and also in the Induction Area).
COM4003 Database Design Assignment Help, Data Warehouse Assignment Help, data warehouse projects for students, Database Design Homework Help, Robotic Engineering.Assignment Help, Java Assignment Help, Computer Network Assignment Help, Cloud Computing Assignment Help, Computer Security Assignment Help
Holding a PhD degree in Finance, Dr. John Adams is experienced in assisting students who are in dire need...
55 - Completed Orders
Canada, Toronto I have acquired my degree from Campion College at the University of Regina Occuption/Desi...
52 - Completed Orders
Even since I was a student in Italy I had a passion for languages, in fact I love teaching Italian, and I...
102 - Completed Orders
To work with an organization where I can optimally utilize my knowledge and skills for meeting challenges...
109 - Completed Orders
JOB OBJECTIVE Seeking entry level assignments in Marketing & Business Development with an organization...
202 - Completed Orders
Current work profile Project manager- The Researchers Hub (2nd Jan 2016 to presently working) Researc...
20 - Completed Orders
Sales Assistant, Mito Marina Assigned to the Stationery dept – assisted in merchandising, stock taking...
100 - Completed Orders