Euafgt
National University of Ireland, Galway
2012/2013
M.Sc. in Information Systems Management
Master of Business Studies (Electronic Commerce)
MS805: Database Systems
Assignment: Database Design and Development using MySQL
The submission deadline for Part 1 of this assignment is 4:00pm, Friday, October 26, 2012
The submission deadline for Part 2 of this assignment is 4:00pm, Friday, November 16, 2012
Part 1 – Database Design (25%):
Part 1 of this assignment is worth 25% of the overall marks for this course
Working in groups of not more than three, you are to take a database-driven e-commerce Web site of your own choice and attempt to “reverse engineer” the underlying relational database schema. You should do this by means of picking out various data attributes, organising those attributes into tables, and then normalising the tables.
Examples of database-driven Web sites that could possibly form the basis of this exercise are:
• Amazon Books www.amazon.com • eBay www.ebay.com • Trip Advisor www.tripadvisor.com • Visit Scotland www.visitscotland.com • Hostelworld.com www.hostelworld.com • Facebook www.facebook.com • Play.com www.play.com
Many database-driven e-commerce systems are powered by very large and complex databases. It is adequate for the purposes of this assignment to focus your attention on constructing part of the overall schema rather than trying to build a complete picture. Choose a few inter-linked data-intensive pages and base your work just on those pages alone. You should try to identify a database that has at least three tables when refined to third normal form (3NF), but four or more tables would be better for the purposes of Part 2 of this assignment.
You should aim to challenge yourself ! Don’t simply pick an easy site; pick one that is difficult and see can you figure out what the back-end database schema might look like. Marks will be awarded
2012/2013
M.Sc. in Information Systems Management
Master of Business Studies (Electronic Commerce)
MS805: Database Systems
Assignment: Database Design and Development using MySQL
The submission deadline for Part 1 of this assignment is 4:00pm, Friday, October 26, 2012
The submission deadline for Part 2 of this assignment is 4:00pm, Friday, November 16, 2012
Part 1 – Database Design (25%):
Part 1 of this assignment is worth 25% of the overall marks for this course
Working in groups of not more than three, you are to take a database-driven e-commerce Web site of your own choice and attempt to “reverse engineer” the underlying relational database schema. You should do this by means of picking out various data attributes, organising those attributes into tables, and then normalising the tables.
Examples of database-driven Web sites that could possibly form the basis of this exercise are:
• Amazon Books www.amazon.com • eBay www.ebay.com • Trip Advisor www.tripadvisor.com • Visit Scotland www.visitscotland.com • Hostelworld.com www.hostelworld.com • Facebook www.facebook.com • Play.com www.play.com
Many database-driven e-commerce systems are powered by very large and complex databases. It is adequate for the purposes of this assignment to focus your attention on constructing part of the overall schema rather than trying to build a complete picture. Choose a few inter-linked data-intensive pages and base your work just on those pages alone. You should try to identify a database that has at least three tables when refined to third normal form (3NF), but four or more tables would be better for the purposes of Part 2 of this assignment.
You should aim to challenge yourself ! Don’t simply pick an easy site; pick one that is difficult and see can you figure out what the back-end database schema might look like. Marks will be awarded