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
E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database

State the meaning of Object Representation  The term object representation means "to represent object with the help of objects model symbols". Implementing objects is too simp

How the time stamps are implemented Use the value of the system clock as the time stamp. That is a transaction's time stamp is equivalent to the value of the clock when the tra

Explain the Role of a database administrator a. Defining the Schema   The DBA describes the schema which consists of the structure of the data in the application. The DBA

Text Processing: Use readLines to read SOU.txt into R. Create a vector called Pres containing the names of the presidents giving each speech. To do this, rst identify the lin


sir, could anybody help me in getting complete information about the mentioned topic

Describe the objective of Structural Diagrams The main objective of structural diagram is to visualize, construct, specify and document static aspects of a system. Their eleme

Equi Join: A join in which the joining condition is based on equality among values in the common columns. Common columns show (redundantly) in the result table. Let us Consider th

What is a value? A data value is used for identity. This form of identity is used in relational systems.eg: The primary key value of a tuple recognize the tuple.