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

Improve efficiency of database, Smart Alex Catering Sevice (SACS) is a comp...

Smart Alex Catering Sevice (SACS) is a company offering top class catering staff  for prestigious events.  The company employs approximately 200 hourly paid contact staff - chefs,

Create role named roletable to allows a user to create table, Create role n...

Create role named role_table that allows a user to create tables. Using role_table allow users kripa and reena to create tables. CREATE ROLE role_table; GRANT CREATE ANY TABLE

The users who use easy-to-use menu are called, The users who use easy-to-us...

The users who use easy-to-use menu are called ? The users who use easy to use menu are called as Naïve users.

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

Database models, why are older data models are being replaced by new data m...

why are older data models are being replaced by new data models

Critically evaluate the bulleted list of information, Critically evaluate t...

Critically evaluate the bulleted list of information-related items in this case study. How are each contradictory to the notion of being an information-literate knowledge worker?

Seeking hr searcher, Project Description: The work is about founding the...

Project Description: The work is about founding the best skilled person for the job. I will give you the job description. Skills required are Data Entry, Database Administrat

Describe deductive databases and relational databases, Problem : (b) A ...

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

Normalization, Process of normalization is the integral part of designing a...

Process of normalization is the integral part of designing a database. Justify this statement with suitable database design

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