Reference no: EM13936000
Case Study ‘Stepping Into History' is a fast-growing business that offers the history enthusiast something a little bit different. Through its website and attendance at various events, the company promotes the following services and products:
• Guided tours of famous historical sites, buildings and battlefields - across the world
• Customized expert lectures from world-renowned historians for private functions
• Genealogical research and family tree services - either face-to-face or remotely
• Historical documents and books location service - from across the world
• Historical book sales - from its own on-line book store
• History magazine subscriptions - issued quarterly in hardcopy and e-copy format
• Hands-on training workshops and courses - in historical and archeological skills The company needs a database to run the company - your job is to deliver that database. For each aspect of the business you must identify and capture the relevant data - such as speaker details, customer details, lecture/visit dates and locations, book details, workshop details etc. etc. 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.
Your Tasks 1. Produce an Entity-Relationship Model for the scenario described above (30 marks) Develop a top-down design of the data in the form of an entity-relationship diagram. You should note all assumptions you make about the data and the reasoning behind your design choices. Also include any appropriate constraints and a list of entity types showing their attributes and identifiers. 2. Design a set of relations conforming to Boyce-Codd Normal Form (BCNF). (20 marks) Once you are satisfied that the ER diagram is a good representation of the data, produce a logical design by mapping the E-R diagram to a set of (normalized) relations. Clearly show all intermediate steps. 3. Implement your final database design.
Take each of the relations from your relational model and implement them as SQL tables. You must include all primary and foreign keys as well as any other table or column constraints you feel are appropriate. Then, using appropriate sample data and your own imagination, populate your finished tables. 4. Query your database.
Using SQL, write a set of realistic sample queries based on the above scenario (use your imagination for details of each query) but they should include the following SQL query techniques:
• Joins (using two, three or more tables)
• Set operations (UNION, INTERSECT and MINUS)
• Ordering
• Grouping
• Aggregate functions (MIN, MAX, AVG, COUNT, SUM)
• Table aliases
• Renaming columns
• Sub-queries (nested queries) 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.
• Make sure your full name and student ID are on the front page of the assessment
• Clearly label all tasks and take care to explain and discuss your technical work
• For the modelling and design work you must supply clearly annotated diagrams
• For the SQL work you must supply full code listings of the inputted code and screenshots of the outputted results - even if no rows were returned. Each screenshot must include some identifying feature - such as a username or user ID - that proves beyond doubt that it is your own work.
• If you need to research, then fully reference all such sources using the Harvard notation
|
Console application that displays the sizes of the two files
: Create a file that contains your favorite movie quote. Use a text editor such as Notepad and save the file as Quote.txt. Copy the file contents and paste them into a word-processing program such as Word. Save the file as Quote.doc.
|
|
Critical appraisal that demonstrates comprehension
: To write a critical appraisal that demonstrates comprehension of the research study conducted, and respond to each of the action items listed under the headings below. Successful completion of this assignment requires that you provide a rationale,..
|
|
C# application that creates an animal using basic graphics
: Write a C# application that creates an animal, plant or building of your design, using basic graphics methods such as DrawRectangle(), DrawLine(), DrawEllipse(), DrawArc() and DrawPie().
|
|
What is the mission of the health care organization
: Prepare your written assignment by addressing each of the following questions in order: What is the mission of the health care organization? What are their corporate level goals? Who are their customers
|
|
History enthusiast something a little bit different
: Case Study ‘Stepping Into History' is a fast-growing business that offers the history enthusiast something a little bit different. Through its website and attendance at various events, the company promotes the following services and products:
|
|
Why the euros value could be expected to change
: Explain how and why the euro's value could be expected to change against these currencies according to the PPP theory.
|
|
Decision-making process of managers
: The leader of your client organization has observed a lack of flexibility and a slow decision-making process in many of the departments.
|
|
What is jayanthas equity at 31 december 2010
: What is Jayantha's equity at 31 December 2010 - What is the profit (loss) for the year and what is the contribution per unit of the company's product?
|
|
Do you think rate of return on eds investment will be higher
: Do you think the rate of return on Ed's investment will be higher than, lower than, or the same as the rate of return on Maria's investment? Explain.
|