Construct a conceptual data model, Database Management System

Competition entrants can be either Individuals, or Teams. A Team is usually sponsored by a business, and, in that case, the team members would all wear T-shirts with the sponsoring business logo on them. Some business also donate prizes. Entrants can register to join the competition from now up until the week before the competition begins.

The competition is to be held over 1 full week, and every entrant will trade for 8 hours in total, which will consist of 4 x 2-hour trading sessions. Some sessions will be held at Bond University, others will be scheduled in locations around the Gold Coast, using one of the many offices the club has access to. The Club will send each entrant their scheduled session details (where and when) in advance. During each 2-hour session, details of any trades made will be recorded by a session judge.

At the end of the weekend, prizes are awarded for specific categories, such as: Biggest winning trade, most number of successful trades, best trading office, most valuable final portfolio, etc..

1. Use the business rules below to construct a conceptual data model (in PowerDesigner 7.5) for the Bond University Share Trading Club

2. Assign suitable data types and primary keys.

3. Copy and paste the PowerDesigner conceptual data model into this Word file and list any assumptions and any additional business rules that you feel are necessary in the table below. Note that any additional business rules must be consistent with the information given. Only list assumptions and business rules that are necessary to make your model work. I will take off marks for spurious/irrelevant rules and assumptions.

Posted Date: 3/14/2013 2:42:52 AM | Location : United States







Related Discussions:- Construct a conceptual data model, Assignment Help, Ask Question on Construct a conceptual data model, Get Answer, Expert's Help, Construct a conceptual data model Discussions

Write discussion on Construct a conceptual data model
Your posts are moderated
Related Questions
Problem : (b) A deductive database system is essentially the outcome of applying mathematics logic to database management, where logic is used for both data representation and

Client Server Databases- The concept behind the Client/Server systems is simultaneous, cooperative processing. It is an approach that presents a one systems view from a user's vie

Illustrate the class diagram for class room scheduling system If in any college, the number of classrooms are limited which have to be allocated to various classes and instruct

Example:  //REVOKE ALL ON EMP FROM MCA12;                              (All permissions will be cancelled) You can also cancel only some of the permissions. Drop: A user-

Explain the term High level DML? High level DML A high-level or non-procedural DML permit the user to specify what data is needed without specifying how it is to be acquired.

What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p

Why, generally does an object-oriented system use the relational DBMS? The reasons for using relational DBMS for OO systems could be any combination of following: a. Many or

Logical Operators Rules of Precedence: Order evaluated Operator 1 All comparison operators 2

In tuple relational calculus P1 → P2 is equivalent to ? A In tuple relational calculus P1→  P2 is equivalent to ¬P1 V P2. (The logical implication expression A  B, meaning

Saving Derived Attributes to Avoid Re-computation Data that is derived from other data should be stored in the computed form to avoid re-computation. For this, we could define