History enthusiast something a little bit different

Assignment Help Basic Computer Science
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

Reference no: EM13936000

Questions Cloud

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.

Reviews

Write a Review

 

Basic Computer Science Questions & Answers

  Customer facing decisions

Describe an example of a customer facing decision. Briefly describe the issue and explain the decision making process you would use to resolve the issue. Also, can you give a recommendation for a customer-facing software sold for the purpose of ..

  Threat vulnerability, and exploits assessment practices

There are multiple ways to bring threats and vulnerabilities to light. Common practices and lessons learned can help us explore for known or common threats, but how does an organization with a unique or highly unusual setup discover its vulnera..

  Determine the two smallest positive real roots

Determine the two smallest positive real roots for the following equation: x + cos(x) = 1 + sin(x)

  Find the sum of the squares of the integers

Find the sum of the squares of the integers from 1 to My Square, where My Square is input by the user.be sure to check that the user enters a positive integer.

  Project manager for an it department

Define a work breakdown structure and describe the methodology behind constructing one.

  Flowchart, psuedocode and desk check

Flowchart, psuedocode and desk check

  A boolean matrix has the parity property

A Boolean matrix has the parity property when each row and each column has an even sum, i.e. contains an even number of bits which are set. Here's a 4 x 4 matrix which has the parity property:

  Managing a merger

Imagine you work for Quality Corporation (Quality.ad) who has just recently bought Crescent Inc. (Crescent.ad) in a recent merger. Quality and Crescent have separate offices in St. Louis (Quality HQ), Little Rock, and Austin (Crescent HQ). Crescen..

  Alter computation of prefix function-correctly match string

if ‘_' is wild-card, then pattern ‘foo*bar*nad' can be found in ‘foofoowangbarnad'. Alter computation of prefix function to correctly match strings using KMP.

  Write a program that generates a random integer

Write a program that generates a random integer in the (inclusive) range [0-9] (i.e. the set {0,1,2,3,4,5,6,7,8,9}) and ask the user to guess what the number is.

  Location to be available in the new los angeles office

Network engineer for a small company with one local office in New York City. The company has been experiencing tremendous growth in the northeastern United States. As a result of this unprecedented growth, the company's management decides to es..

  Common types of policies for web services

What are the most common types of policies for Web services? 12.2 What are the main components of WS-Policy Framework?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd