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
a publishing company produce scientific books on various subjects. the books are written by authors who specialize in one particular subject. the company employs editors who, not n

Prepare Heart Failure Registry database How are you today? Please I would like you to design a Heart Failure registry where doctors will log in to enter information about their

Views in relational algebra:   1. Basic expression contains either  a) A relation in the database. b) A constant relation. 2.  General expressions are madde out of sma

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

Explain the Fundamental concepts of object-orientation Software developers, data base administrators (DBAs) need to be familiar with fundamental concepts of object-orientation.

How to create values of structured type? Constructor functions are used to make values of structured types. A function with the similar name as a structured type is a construct

1. Create the tables for the play-scheme database as specified in the TMA. 2. Enter the data as given in the spreadsheet. 3. Create queries to retrieve specified information

Distributed And Client Server Databases Introduction This unit tells the distributed database systems which are primarily relational and one important execution model: the

What are the disadvantages of file processing system? The drawbacks of file processing systems are a) Data redundancy and inconsistency b) Complexity in accessing data

Project Description: I need a point of sale for motels. It needs to run on windows and requires being network able so that we can have more than one computer using it at once.