Construct a conceptual data model, Database Management System

Assignment Help:

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.


Related Discussions:- Construct a conceptual data model

Explain the paths in the association network, Explain the paths in the asso...

Explain the paths in the association network We can analyze use of paths in the association network as given below: Calculate each operation Find associations whic

A step-wise distributed database design methodology, A step-wise distribute...

A step-wise distributed database design methodology Following is a step-wise methodology for distributed database design. (1) Examine the nature of distribution. Find out wh

Microeconomic, anyone have a textbook solutions case fair, 8 edition of vo...

anyone have a textbook solutions case fair, 8 edition of vol 1 ?, please give me

Examine about the behavioural diagrams, Examine about the Behavioural Diagr...

Examine about the Behavioural Diagrams  The main objective of behavioural diagrams is to visualize, specify, construct and document dynamic aspects of a system. The interactio

Write query to insert data in student table, Consider student (std_id, std_...

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

What is candidate key, What is candidate key? Candidate Key - A candi...

What is candidate key? Candidate Key - A candidate key of an entity set is a minimal superkey, which uniquely identifies each row in the relation.

In oracle what is system global area and how is it organized, In Oracle wha...

In Oracle what is system global area and how is it organized? The SGA is a collection of shared memory fields which along with the Oracle processes constitute an Oracle instan

Importance of file organisation in database, Importance Of File Organisatio...

Importance Of File Organisation In Database To execute a database efficiently, there are various design tradeoffs needed. One of the most vital ones is the file Organisation. F

Explain the concept of qbe, Explain the concept of QBE? Query-by-exampl...

Explain the concept of QBE? Query-by-example represents a visual/graphical approach for accessing information in a database by the use of query templates called as skeleton tab

What are the parts of sql language, What are the parts of SQL language? ...

What are the parts of SQL language? The SQL language has various parts: data - definitition language  Data manipulation language  View definition  Transaction contr

Write Your Message!

Captcha
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