Part B – Conceptual Data Modelling

Part B – Conceptual Data Modelling

B.1 Overview of Case Study

Steam is a video game business developed by Valve’s online platform for the purchase and distribution of games and other products. To identify users and assign the games and software they purchase/download to their unique account profile/steam library, the Steam DBMS should employ an account-based approach. The Steam system also allows a community of users to exchange in-game goods saved on their user accounts for other items, in-game cash, or real-world currency with one another.

B.2 Revised Business Rules

1. An email address can only create one steam account; therefore, accounts can be uniquely identified by their email address (or Steam id).

2. An account can only have one steam library, wish list and cart.

3. Applications must have at least one content tag and must have an age rating.

4. A developer can push an application to the store without a publisher, but if a publisher pushes an application to the store, they must include the developer.

5. When a user downloads or purchases an application, said application must be added to the user’s steam library, no matter if the application is paid or free.

6. A user can manage their wish list and cart freely, adding or removing applications from them. However, they cannot manage their steam library.

7. While 2 factor authentication is recommended, it is by no means necessary, meaning the phone number attribute is only optional.

8. Users can have multiple items stored inside their steam library, and duplicate items are also allowed.

9. A user’s steam library, wish list and cart can contain multiple or no applications

10. A developer can have multiple published applications within the store

11. A publisher can have multiple games released under their name

12. A publisher may have multiple works of different developers

13. When launching an application, the steam library of the user should be referenced to ensure they own the application.

14. An application can be owned by multiple different accounts, meaning an application can be a part of many different steam libraries, wish lists and carts.

15. Publishers are uniquely identified by a Publisher ID, and publisher accounts cannot be created through a form, but should rather directly contact steam to set up a publisher account.

16. Developers can be identified by a Steam ID or Developer ID.

B.3 ERD Diagram

B.4 Justifications of ERD

Business Rules Related to Entity User:

● BR1: For the user, the email address provided is unique during account creation, which will also supply a distinctive ID from steam, so it can identify and distinguish other users.

● BR7: The user can have the option to either input their phone number for 2 factor authentications or not. Value of the phone number can be NULL or NOT NULL, depending on the user

NOTE: This entity acts as a Supertype of the subtype entity for Developer.

Business Rules Related to Entity Cart:

● BR2: Cart must only be assigned to ONLY one user(cardinality 1 to 1)

● BR5: When a purchase is complete, application will be removed from cart towards the steam library of the user.

● BR6: The user must be able to freely manage the cart, adding and removing applications, as well as purchasing them

Note: This acts as an associative entity between the user and the application.

Business Rules Related to Entity Wish List:

● BR2: Wish list must only be assigned to ONLY one user (cardinality 1 to 1)

● BR6: The user must be able to freely manage the wishlist, adding and removing applications as they want

Note: This acts as an associative entity between the user and the application.

Business Rules Related to Entity Steam Library:

● BR2: Steam library must only be assigned to ONLY one user (cardinality 1 to 1)

● BR5: A user’s purchased/downloaded programme is automatically added to the user’s steam library and is identifiable by its application ID within the system.

● BR6: Users cannot manage their Steam library.

● BR8: A steam library can contain many items, which are identified by the application they are related to. (cardinality 0 to many)

● BR9: The steam library can contain many applications or no applications (cardinality 0 to many)

NOTE: This acts as an associative entity between the user and the application.

Business Rules Related to Entity Application:

● BR3: At least one content tag and an age rating are required in an application. (cardinality 1 to many)

● BR4: The application can have no publisher or a publisher who is also the developer, but it cannot have a publisher who is also the developer. (i.e. developer cannot be NULL, but publisher can be NULL)

● BR14: An application can be owned by many different users (steam libraries). (cardinality 0 to many)

Business Rules Related to Entity Developer:

● BR12: A developer can push multiple applications to the store. (cardinality 1 to many)

● BR16: A developer can be identified by a developer ID, but is primarily identified by their user ID internally.

NOTE: This entity acts as a subtype for the user entity supertype

Business Rules Related to Entity Publisher:

● BR11: Under their name, a publisher can have zero or more applications published. (cardinality 0 to many)

● BR12: A publisher is not tied to a particular developer, which means that he or she can publish many apps from various developers.–

● BR15: You must contact Steam directly to create a publisher account, as there should be no need for the general public to require one.

Order Now
Universal Assignment (February 21, 2024) Part B – Conceptual Data Modelling. Retrieved from https://universalassignment.com/part-b-conceptual-data-modelling/.
"Part B – Conceptual Data Modelling." Universal Assignment - February 21, 2024, https://universalassignment.com/part-b-conceptual-data-modelling/
Universal Assignment July 31, 2022 Part B – Conceptual Data Modelling., viewed February 21, 2024,<https://universalassignment.com/part-b-conceptual-data-modelling/>
Universal Assignment - Part B – Conceptual Data Modelling. [Internet]. [Accessed February 21, 2024]. Available from: https://universalassignment.com/part-b-conceptual-data-modelling/
"Part B – Conceptual Data Modelling." Universal Assignment - Accessed February 21, 2024. https://universalassignment.com/part-b-conceptual-data-modelling/
"Part B – Conceptual Data Modelling." Universal Assignment [Online]. Available: https://universalassignment.com/part-b-conceptual-data-modelling/. [Accessed: February 21, 2024]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Categories

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

Solution: Scenario 1, Mirror therapy in patients post stroke

Title: Scenario 1, Mirror therapy in patients post stroke Part 1 : Summary Ramachandran and colleagues developed mirror therapy to treat amputees’ agony from phantom limbs. Patients were able to feel their amputated limb without experiencing any pain by presenting them a mirror image of their healthy arm. Since then,

Read More »

Solution: Exploring the Dominance of Silence

Slide 1: Title – Exploring the Dominance of Silence The title, “Exploring the Dominance of Silence,” sets the stage for a deep dive into the portrayal of silence in Philip K. Dick’s “Do Androids Dream of Electric Sheep?” Our presentation will dissect the literary techniques used by the author to

Read More »

Solution: Assessment: Critical Reflection S2 2023

The policies that hampered the cultural survival of Indigenous groups have a major effect on their health (Coffin, 2007). Cultural isolation can cause an identity crisis and a sense of loss, which can exacerbate mental health problems. Indigenous people have greater rates of chronic illness and impairment due to historical

Read More »

Solution: The Market – Product and Competition Analysis

Section 1: The Market – Product and Competition Analysis Industry and Competition Analysis: The baking mix market is very competitive, but My Better Batch is entering it anyhow. The prepackaged baking mixes sold in this market allow busy people to have bakery-quality products on the table quickly without sacrificing quality

Read More »

Solution: PDCA model for Riot

Student Name: Student ID: University Name: Date: Learning Outcome 1: Engage actively in recognizing a new product/service for Riot and detect the vital tasks required for its effective growth. In this comprehensive learning outcome, Riot’s progress towards innovation superiority is characterized by a deliberate scheme that draws on components from

Read More »

Solution: EDEN 100 – ASSIGNMENT 1

Part 1: Reflections on the Register Variables Use the questions in Column 1 and analyse the sample oral interactions provided under the assessment tile. The transcript for Viv’s conversation is provided on pages 4-5. Probe Questions  Link to readings and theory Interaction 1 Interaction 2 PART 1 – ANALYSING THE

Read More »

Solution: TCP/IP Questions

Table of Contents Question 1. 1 1. IPSec datagram protocol 1 2. Source and destination IP addresses in original IP datagram.. 1 3. Source and destination IP addresses in new IP header 2 4. Protocol number in the protocol field of the new IP header 2 5. Information and Bob.

Read More »

Solution: Fundamentals of Employment Assistance Program and Counselling

ASSESSMENT 3 Subject: Fundamentals of Employment Assistance Program and Counselling Case study Question 1 a)     Major Issues for Theo that could be addressed in counselling: b)    Issues to Address First in Short-Term Counselling:             The cognitive processes of memory, focus, and decision-making are all impacted by insufficient sleep. Such cognitive

Read More »

Solution: EQUITY AND INCLUSION IN EARLY CHILDHOOD IN AUSTRALIA

Written Policy Recommendation Name: Student Number: Email: Date: Introduction: The early years of a child’s life are important for their holistic development, making early childhood education a foundation for their future accomplishments. Nevertheless, guaranteeing equality and inclusion in early childhood education stays a major problem in our society. This policy

Read More »

Solution: Report Health Issue

Table of Contents Executive Summary                                                                                                   3 Introduction                                                                                                                5 Examination of the Chosen Health Issue in the Context of Lambeth                        5 Application of Health Inequality Framework and Analysis of Determinants: Psychotropic Drug Use in Lambeth                                                                           6 Exploration and Discussion of Strategies to Manage Psychotropic Drug Use in Lambeth                                                                                                                        7 Conclusion                                                                                                                  8

Read More »

Solution: Section III: Marketing

Section III: Marketing Channels for Advertising: Understanding Who Makes Baking Product Purchase Decisions is Crucial for My Better Batch’s Business Success (Sampson et al, 2017). Home bakers may make up a disproportionate share of the decision-makers in the UK. As a result, My Better Batch has to target people, especially

Read More »

Solution: Analytics Project Project Management Plan

Analytics Project Project Management Plan Date: 22-10-2023 Author: Name Here Version: 2.0 Project Management Plan (PMP) This project management plan will outline the strategies and plans used to manage ‘analytics project’ for the Style-Hub organization. It will include the tasks such as project governance, management, planning, budget and controlling. It

Read More »

Solution: Report Health Issue

Table of Contents Executive Summary                                                                                                   3 Introduction                                                                                                                5 Examination of the Chosen Health Issue in the Context of Lambeth                        5 Application of Health Inequality Framework and Analysis of Determinants: Psychotropic Drug Use in Lambeth                                                                           6 Exploration and Discussion of Strategies to Manage Psychotropic Drug Use in Lambeth                                                                                                                        7 Conclusion                                                                                                                  8

Read More »

Solution: Mirror therapy in patients post stroke

Title: Scenario 1, Mirror therapy in patients post stroke Part 1 : Summary Ramachandran and colleagues developed mirror therapy to treat amputees’ agony from phantom limbs. Patients were able to feel their amputated limb without experiencing any pain by presenting them a mirror image of their healthy arm. Since then,

Read More »

Solution: Case Study – HR Activities

Cover Page Case Study – HR Activities title of assessment unit code unit name semester and year assignment title student name student number tutor name and word count Executive Summary The research suggests two main HR initiatives to help Actualise Health deal with its workforce issues: acquiring and developing talent,

Read More »

Solution: Building a Foundation for Equity and Inclusion

Script – Slide 1: Title and Introduction Greetings, everyone. My name is…, and I would like to discuss a vital concern in early childhood education – equality and inclusion. At present, I’m going to explain why this matter is so important and what research and guidelines indicate about it. Slide

Read More »

Solution: EQUITY AND INCLUSION IN EARLY CHILDHOOD IN AUSTRALIA

Written Policy Recommendation Name: Student Number: Email: Date: Introduction: The early years of a child’s life are important for their holistic development, making early childhood education a foundation for their future accomplishments. Nevertheless, guaranteeing equality and inclusion in early childhood education stays a major problem in our society. This policy

Read More »

Expression of Interest (EOI)

The focus of this Expression of Interest is to demonstrate why you are a good fit for the selected project based on your learning in IKC101.Context:You are submitting an Expression of Interest (EOI) to lead a project connected to the organisation you have chosen. You are required to explain your

Read More »

COM10007 Professional Communication Practice

Assignment 3: PresentationWord/time limit: Five minutes (+/- 10%)Weighting: 15% (Presentation + reference list)Assignment detailsFor this assignment, you are required to consider those who work in the following sectors and describe the key responsibilities of a professional communicator in a particular context—including types of audiences, key messages and delivery modes. You

Read More »

ELT2014 Special Educational Needs and Disabilities

ELT 2014 Assessment 1 – Case Study Module code ELT2014 Module title Special Educational Needs and Disabilities Submission date, time 27/2/24 @ 5pm: Group Presentation slides for part (a) uploaded to TurnItIn 28/2/24 : Group Presentations in class for part (a) – ALL MUST ATTEND 22/3/24 @ 9pm: Suggested deadline

Read More »

Applied Pathobiology Assessment 2 – case study

This assessment covers 30% of the marks for this module. Instructions   Case 1 Vivienne A. (mother) and Isabel A. (daughter) go to the GP for prolonged fatigue in the last four months. Vivienne is a retired 74-year-old teacher, who reports fatigue, tingling and numbness in her hands and feet,

Read More »

Assignment Legislative Framework for Governance

It’s now time to complete your assessment. At Level 5, you must demonstrate that you can follow academic writing standards, including checking your writing for spelling and grammar, referencing using Harvard referencing (or similar) guidelines and utilising critical analysis skills. If you are unsure about these, speak to your Advanced

Read More »

BIK0028/BIH2014 Tips for Individual report assessment

Guidance document: Tips for Individual report assessment BIK0028/BIH2014 Individual report Assessment Assessment brand of your choice. rarity, extraordinariness and a high degree of non-functional associations” (Heine, 2012, p.62). Your work should include the following •       A brief introduction to the selected brand characteristics etc.) •       Your analysis of consumers’ behaviour

Read More »

1008GBS Business Decision Making Assessment 3

1008GBS Business Decision Making Assessment 3 50 Marks (worth 50% of total assessment) Business Decision-Making Take Home Assignment. The deadline is 6 pm 5th February 2024. Notes – read these carefully! The report should be prepared based on the five questions below. For each question, include a separate subheading. The

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?