Develop a fragment of a hypothetical system, Database Management System

The objectives of this assignment are:

 - to develop skills in the design of database driven applications

 - to develop skills in applying SQL to implement the relational and object-relational design

 - to make you aware of the differences between set-processing and block-structured programming paradigms

 - to present an opportunity to practice problem solving and communication skills.

TASK

Develop a fragment of a hypothetical System for Timely Recording IN Global Yo-yoing (STRINGY), whose underlying logical data model includes the following entities:

  • COMPETITOR - an entrant to one or more of the federation's events
  • EVENT - each event is specified in terms of the number and type of yo-yos, the length of the string, and any other, more specific rules (e.g. The player must use two long spinning yo-yos and perform tricks with both simultaneously)
  • COMPETITION - a selected set of events, in which competitors collect points towards an overall competition winner. Each competition will be specified for a particular class of event (e.g. Single, unattached yo-yo). Occasionally, a single event will form a part of more than one competition.
  • VENUE - The location of each event. Several events will take place during an afternoon or evening, at the same venue.
  • CLUB - competitors may belong to a club. Competition results also contribute to annual club trophies for each event class, awarded to the club whose members receive the most competition points that year, in that class.

STRINGY is to be used by the UK Yo-yo Society to monitor and manage the results of each event, and the individual and club competitions. It also needs to manage the allocation of events to venues. Use the first deliverable to clearly state any other assumptions that you make, and any additions or changes to the outline data model above.

DELIVERABLES  

Deliverables are divided into two stages.

Stage 1 submission is due on Friday, week 5, 4th March 2011, and should contain

(1) Specification of the scope and functionality of your system.

(2) Logical data model: 

EAR scheme and its relational representation. RI diagram with its concise but informative description.

Stage 2 is due on Friday, week 10, 15th April 2011, and should contain:

(3) Identification of functional dependencies and normalisation of tables. Table definition & population with the relevant data:         

SQL code + final data set (presented in an Appendix). The use of sqlloader is encouraged but not required.

(4) A transaction (delete_X) that causes the biggest propagation effect (i.e. affects most of the database tables),

      appropriately designed and coded in SQL:

                • specification of pre- and post-conditions

                • definition of input & output

                • processing logic and the SQL code

                • illustrative test run.                                                                                                                      

(5) A non-trivial query (e.g. involving multiple joins, group functions, qualifiers, correlation variables) appropriately designed and coded in SQL.

Posted Date: 3/9/2013 2:30:08 AM | Location : United States







Related Discussions:- Develop a fragment of a hypothetical system, Assignment Help, Ask Question on Develop a fragment of a hypothetical system, Get Answer, Expert's Help, Develop a fragment of a hypothetical system Discussions

Write discussion on Develop a fragment of a hypothetical system
Your posts are moderated
Related Questions
Implementation of association as an object Implement as a separate association object, independent of either class, as in Figure. An association object is a group of pairs

It defines that the tuple in one relation that refers to another relation must refer to an existing tuple in that relation. This constraint is states on two relations (not essentia

Data Handling and Research Methods: The dataset encompassing 130 participants contains several variables measuring detrimental health related behaviours referring to the use o

Defining Internal Classes and Operations When we enlarge algorithms, new classes can be added to the store intermediate results. A complex operation could be looked at, as a c

Consider employee (e_no, e_name, e_salary, d_code), dept (d_code, d_name) and dependent (depndt_name, e_no, relation). Show the names of employees in purchase and accounts departm

Normalize the following table upto and including the 3NF. Submit a 1 page printout of only the final set of normalized tables in Data Architect. Just use Data Architect to do the t

What are the various states through which a transaction passes through in its lifetime?  Briefly discuss all the events that causes transition from one state to another.   Ans:

What is meant by object identifiers? Object-oriented systems use an object identifier to recognize objects. Object identifiers are unique: that is every object has a single ide

Suppose that in an organisation, an employee may do different roles in dissimilar projects. Say, RAM is doing coding in one project and doing designing in another. Suppose that the

For each 1: n relationship type R involving two entities E1 and E2, we recognize the entity type (say E1) at the n-side of the relationship type R and contain primary key of the en