dream home case study pdf

• Engineering & Technology
• Computer Science

DB-Ch11-Dreamhome Case Study

Related documents

Add this document to collection(s)

You can add this document to your study collection(s)

Add this document to saved

You can add this document to your saved list

Suggest us how to improve StudyLib

(For complaints, use another form )

Input it if you want to receive answer

Navigation Menu

Search code, repositories, users, issues, pull requests..., provide feedback.

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly.

To see all available qualifiers, see our documentation .

• Notifications

The dreamhome database from Database Systems: A Practical Approach to Design, Implementation, and Management (6th Edition).

dkfreitag/dreamhome

Folders and files, repository files navigation.

Database Systems: A Practical Approach to Design, Implementation, and Management ( https://www.amazon.com/Database-Systems-Practical-Implementation-Management/dp/0132943263 ) was my textbook for Baruch College's CIS 9340 course, Database Management Systems. Throughout the text, the dreamhome database is used for nearly all examples.

To practice SQL queries, I manually created this database from the tables in the textbook. Now, instead of typing everything out, you can conveniently download and load this database into your favorite DBMS by cloning this repository.

The database_files directory contains a file of SQL statements that will create the tables, as well as .csv files for all tables. I have only tested these SQL statements in Postgres.

Alternatively (and more efficiently), with Postgres, you can just restore the entire database all at once from the dreamhome.sql file.

For more information on using Postgres, see: https://www.postgresqltutorial.com/

• My presentations

Auth with social network:

Download presentation

We think you have liked this presentation. If you wish to download it, please recommend it to your friends in any social system. Share buttons are a little bit lower. Thank you!

Presentation is loading. Please wait.

To view this video please enable JavaScript, and consider upgrading to a web browser that supports HTML5 video

Database Analysis and the DreamHome Case Study

Published by Angelina Mason Modified over 8 years ago

Similar presentations

Presentation on theme: "Database Analysis and the DreamHome Case Study"— Presentation transcript:

DBS Development Lifecycle & DB Analysis

Fact-finding Techniques Transparencies

Fact Finding Techniques

Recall The Team Skills 1. Analyzing the Problem (with 5 steps) 1.Gain agreement on the problem definition. 2.Understand the root causes 3.Identify the.

2.06 Understand data-collection methods to evaluate their appropriateness for the research problem/issue.

Indira Gandhi National Open University presents. A Video Lecture Course; System Analysis.

 Interviewing individuals  Interviewing groups  Observing workers  Studying business documents 1.

Primary and Secondary Data

4.11 PowerPoint Emily Smith.

Chapter 6 Review Questions

ACTIVELY ENGAGING THE STAKEHOLDER IN DEFINING REQUIREMENTS FOR THE BUSINESS, THE STAKEHOLDER, SOLUTION OR TRANSITION Requirements Elicitation.

CAP 252 Lecture Topic: Requirement Analysis Class Exercise: Use Cases.

Copyright 2004 Prentice-Hall, Inc. Essentials of Systems Analysis and Design Second Edition Joseph S. Valacich Joey F. George Jeffrey A. Hoffer Chapter.

Lesson 17 Requirements Discovery

1 Pertemuan 18 Penemuan Fakta Matakuliah: >/ > Tahun: > Versi: >

Jump to first page Chapter 2 System Analysis - Determining System Requirements.

© Pearson Education Limited, Chapter 6 Fact-finding Transparencies.

Chapter 5 Determining System Requirements

Chapter 4: Beginning the Analysis: Investigating System Requirements

Fact-finding Techniques

About project

© 2024 SlidePlayer.com Inc. All rights reserved.

Snapsolve any problem by taking a picture. Try it in the Numerade app?

Database Systems: A Practical Approach to Design, Implementation and Management

Thomas m. connolly, carolyn e. begg, database analysis and the dreamhome case study - all with video answers.

Chapter Questions

Briefly describe what the process of fact-finding attempts to achieve for a database developer:

Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of database systems. A client has recently approached your company with a view to implementing a database system, but they are not familiar with the development process. Task: You are required to present an overview of the fact-finding techniques that your company intends to use to support the development of the client's database system. With this task in mind, create a slide presentation and/or report that describes each fact-finding technique and how the fact-finding techniques will be used throughout the development of the database system. The client for this exercise and those that follow can be any one of the fictitious case studies given in Appendix B or some real company identified by you or your professor.

Describe how fact-finding is used throughout the stages of the database system development lifecycle.

For each stage of the database system development lifecycle identify examples of the facts captured and the documentation produced.

A database developer normally uses several fact-finding techniques during a single database project. The five most commonly used techniques are examining documentation, interviewing, observing the business in operation, conducting research, and using questionnaires. Describe each fact-finding technique and identify the advantages and disadvantages of each.

Describe the purpose of defining a mission statement and mission objectives for a database system.

What is the purpose of identifying the systems boundary for a database system?

How do the contents of a users' requirements specification differ from a systems specification?

Describe one method of deciding whether to use either the centralized or view integration approach, or a combination of both when developing a database system with multiple user views.

Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of database systems. A client has recently approached your company with a view to implementing a database system. Task You are required to establish the database project through the early stages of the project. With this task in mind, create a mission statement and mission objectives and high-level systems diagram for the client's database system.

Assume that you are an employee of a consultancy company that specializes in the analysis, design, and implementation of database systems. A client has recently approached your company with a view to implementing a database system. It has already been established that the client's database system will support many different groups of users (user views). Task: You are required to identify how to best manage the requirements for these user views. With this task in mind, create a report that identifies high-level requirements for each user view and shows the relationship between the user views. Conclude the report by identifying and justifying the best approach to managing the multi-user view requirements.

• Hispanoamérica
• Work at ArchDaily
• Terms of Use
• Privacy Policy
• Cookie Policy

Modern, Low-Budget and Easy to Build Living Spaces: the Case Study House Program

• Written by Fabian Dejtiar | Translated by Maggie Johnson
• Published on March 29, 2021

Between 1945 and 1966, the Case Study Houses program , following the Weißenhof-siedlung exposition, commissioned a study of economic, easy-to-build houses. The study included the creation of 36 prototypes that were to be built leading up to post-war residential development. The initiative by John Entenza, editor of Arts & Architecture magazine, brought a team to Los Angeles that featured some of the biggest names in architecture at the time, including Richard Neutra , Charles & Ray Eames, Pierre Koenig, and Eero Saarinen , among others.

The program's experiment not only defined the modern home and set it apart from its predecessors, but it also pioneered new construction materials and methods in residential development that continue to influence international architecture to this day. Take a detailed look at some of the program's most emblematic work together with recommendations for facing contemporary challenges. 

Modern Living Space: Adapting to new needs, activities, and lifestyles

"What is a house?" asked Eames. He soon answered his own question with a drawing that captured the new ways that people used and lived in the contemporary home: listening to music, watching movies, entertaining, and relaxing. These functions led to the introduction of open floor plans and multi-purpose rooms divided between public and private spaces, which quickly became the norm for modern house design. 

In this sense, living spaces also began to stand out for the creative details that began to link the inside of the residence with the outside, mainly by maximizing the use of open air spaces. Sliding doors, furniture, and other elements were another facet to the personalization of spaces in an attempt to satisfy the the tastes and wants of the future residents while keeping in mind their security and privacy.  

Another interesting factor was the attention given to storage spaces such as cabinets, shelves, and closets, especially in kitchens, bedrooms, and bathrooms. In this sense, as shown in the film “House: After Five Years of Living,” made by Eames in 1955, the resident's personal possessions and where they are exhibited play an important role in humanizing a living space.

• 6 Tips for Designing and Building a Tiny House
• Smart Configurations for Small Kitchens
• Storage Spaces for Small Houses: Solutions and Useful Examples

Low-Budget Housing: Understanding New Materials and Reducing Energy Costs 

As can be seen in numerous examples, the decision to use materials such as cement blocks, plywood, and industrial glass dramatically reduced the project's costs. In turn, by using the resistance of the metal, the designers were able to use smaller dimensions for the columns and beams, resulting in smaller frameworks to enclose the spaces. Maintenance costs were even lower. The materials could be left exposed in their raw form or covered with a light coat of paint and could easily be replaced in the event of breakage. 

The low-cost trend gained even more momentum with the development of various methods to reduce heating and lighting expenses. The use of large floor-to-ceiling windows maximized natural light and their sliding fixtures allowed for optimal air-flow. Furthermore, the wide incorporation of plants and green space also worked to keep the home cool and comfortable. 

• How to Make a Facade with Recycled Materials: 16 Notable Examples
• The Golden Age of 3D Printing: Innovations Changing the Industry
• Unfamiliar Living Spaces with Recycled Materials (Spanish Text)

Easy-to-build Living Spaces: Using the Most Efficient Construction Methods

An interesting aspect that could be seen in numerous houses was modular construction - giving homes a simple geometry that not only facilitated the standardization of the building process but also allowed homes to be pre-manufactured as a way to reduce building time. 

Pre-fabricated systems reduced the number of construction jobs that needed time to dry or set and offered a feasible and more importantly, replicable, solution with the intelligent mixing of materials, such as aluminum and wooden frameworks. If a method could not be replicated across different experiments, it still served as an example in the research and development of construction technology in housing. 

Another important element of pre-fabrication is the idea of "core services" that house the plumbing and heating installations that center around kitchens and bathrooms as a way to consolidate one of the living space's biggest expenses. 

• 5 Projects That Illustrate the Huge Potential of Prefab
• This Brazilian Startup Creates Smart, Pre-Fabricated Homes in Half the Time
• This Concept Uses a Pre-Fabricated Timber System to Enable Modern, Self-Built Homes
• This Off-Site Construction System Duplicates Floors in Barcelona Buildings in 3 Days

For more information and examples, we recommend visiting the following links where you can get a first-hand look at the living spaces and their layouts:

• Case Study House #1 / Julius Ralph Davidson
• Case Study House #2 / Sumner Spaulding & John Rex
• Case Study House #3 / William W Wurster & Theodore Bernardi
• Case Study House #4 / Ralph Rapson’s "Greenbelt House"
• Case Study House #6 / Richard Neutra: The Omega House
• Case Study House #7 / Thornton M Abell
• Case Study House #8 / Charles y Ray Eames: The Eames' House
• Case Study House #9 / Charles & Ray Eames, Eero Saarinen: The Entenza House
• Case Study House #10 / Kemper Nomland & Kemper Nomland Jr
• Case Study House #11 / J R Davidson
• Case Study House #12 / Whitney R Smith
• Case Study House #13 / Richard Neutra: The Alpha House
• Case Study House #20 / Richard Neutra: The Bailey House
• Case Study House #21 / Pierre Koenig
• Case Study House #22 / Pierre Koenig: The Stahl House
• Case Study House #23 / Killingsworth, Brady & Smith
• Case Study House #24 / A. Quincy Jones & Frederick Emmons
• Case Study House #26 / Beverley David Thorne

See more articles about topics of contemporary living spaces in the following links:

• Will Open-Source, Technological Solutions Ever Lead to the Dream of Universal Affordable Housing?
• 6 Thoughts On Materials and Construction: Decisions That Improve People's Quality Of Life
• OPEN Architecture and Xiaomi Unveil MARS Case Housing Prototype at China House Vision 2018

Editor's note: This article was originally published on March 25, 2019.

Image gallery

• Sustainability

世界上最受欢迎的建筑网站现已推出你的母语版本!

想浏览archdaily中国吗, you've started following your first account, did you know.

You'll now receive updates based on what you follow! Personalize your stream and start following your favorite authors, offices and users.

Dream 11 Case Study and Marketing Strategies

Dream11 Case Study and Marketing Strategy – When Dream11 started its operations, little did anyone know what the future had in store for this fantasy gaming platform? Dream11 has more than 100 million users registered on its platform, up from a mere 2 million in 2016. There have been many driving factors behind this overwhelming success including, regular funding, partnership with cricketers for endorsements, top-notch marketing campaigns and the prize money involved.

In this post, we will take a detailed look at the success story of Dream11. Through a thorough Dream11 case study and marketing strategy, we will establish the factors that have led to its success in a relatively short span of time. Let us first take a look at its founders and their vision behind launching a fantasy gaming app in India.

Table of Contents

The founders of Dream11

Dream11 is the brainchild of sports enthusiasts Harsh Jain and Bhavit Seth. While Harsh is an alumnus of the Columbia Business School and the University of Pennsylvania, Bhavit has completed his education from Bentley University and Harvard. The two are reportedly childhood friends and ardent sports fans.

The idea and vision behind Dream11

Co-founder Harsh is a huge fan of fantasy sports. According to an article in YourStory, Harsh has been playing English Premier League (EPL) Fantasy Football since 2001. When the IPL was launched in 2008, Harsh started to look for a fantasy platform for cricket. However, he was astonished to see that there was not even a single Cricket fantasy gaming platform at the time. As a fantasy lover, he was shocked to see this, considering the fact that Cricket is such a popular game in India.

This situation presented him with the idea of launching his own cricket fantasy app. He asked his friends to join him up in this effort and so came along his childhood friend, Bhavit. The duo co-founded Dream11 in 2009. But it wasn’t until 2012 that the app gained some recognition when it began offering freemium single-match contests to its users.

Dream11 Problems and Challenges Faced

Here are a few challenges faced by Dream11 over the last 12 years:

1) Bypassing the potential legal hurdle

Anything that comes even remotely near to gambling is usually made illegal in India. Dream11 too had to surpass this infamous tag of a “gambling app”. First, the Punjab and Haryana High Court dismissed a petition against it calling it a “game of skill”, which was followed by the Supreme Court’s approval.

The removal of any legal hurdles meant that more fantasy platforms could enter the market. As a result, the Indian fantasy gaming industry now has more than 70 players! The surge in the number of players has been possible because of India’s first and only sports gaming self-regulatory body, the Indian Federation of Sports and Gaming (IFSG), which came into force in the year 2017.

2) Removal from Play Store

Google has very stringent policies about the apps that can be uploaded on its app better known by the name ‘Play Store’. In its days of infancy, “Dream11 Free” did not offer any paid contest. However, as soon as the app added paid contests, Google had to remove it as its Play Store policies do not allow such apps on its platform.

3) Convincing people that it’s a game of skill – not gambling!

It takes a broad mindset to see the differences between fantasy gaming and betting. In the initial days, without any brand ambassadors and funding, it was an uphill task for the company to market its product as a game of ‘skill.’ However, after the landmark ruling of Punjab and Haryana high court and the Supreme Court to allow the operations of the fantasy app, there has been a huge growth in the number of users and the platform has gained credibility too. Dream11 has now become a household name!

4) Outsmarting the emerging competition

Many fantasy gaming apps have emerged since 2019. But, none of them have been able to reach the benchmark set by Dream11. None of the apps is as fast, robust and intuitive as Dream11. The customer support offered through its app and social media is top-notch.

Dream11 Contest format

Only team sports such as Cricket, Football, Basketball, Volleyball, etc. are listed on Dream11. The platform doesn’t yet offer singles games such as Tennis, Table-Tennis, Badminton, etc.

Users of the app can enter free or paid contests. There’s a paid contest to suit every player’s budget and winnings expectations. Upon the completion of a paid contests, the prize money is distributed among the players “in the winning zone” as per the distribution mentioned across each contest before the match starts.

Users can make a number of “fantasy teams” comprising players from both sides. Each player is awarded certain points by the end of the match, based on certain performance metrics such as ‘runs scored’, ‘wickets taken’, ‘goals and assists”, ‘baskets scored’, etc. There are negative points as well for poor performances. Once all the points have been assigned, users can check their final rank in the leaderboard. There are “mega contests” as well, the winners of which can win lakhs and crores of cash prize, though mega contests have come under the scrutiny of a lot of users who think that many players in the mega contests are ‘bots’ and not actual human beings.

Furthermore, those who just want to test the waters, can enroll in ‘practice contests’ and learn how the whole process works. There is no prize money involved in the practice contests though.

Dream11 Revenue Model

Dream11 doesn’t generate revenue through ad networks such as Google Adsense. It generates its revenue from the joining fee of the contests that each user has to pay in order to participate in a paid public/private contest. Dream11 takes 15-25% of the total pool and this is the only way through which it generates its revenue.

Dream11 reported a net profit of INR 181 crore in FY2020. This feat helped it become one of the few Indian consumer-tech unicorns to have turned profitable. Notably, the company had recorded a loss of INR 87 crore in FY2019.

Dream 11 Funding

Dream 11 has raised funds through multiple rounds of funding since 2014. Come 2018, Sporta Technologies, the parent firm of Dream11 has been raising huge sums of money. For instance:

• September 2018 – Dream 11 raised $100 million from Tencent holdings
• April 2020 – Raised $60 million from Steadview Capital
• September 2021 – Raised $225 million in private equity round comprising Tiger Global Management, Chrys Capital, Footpath Ventures, and TPG.
• March 2021 – Raised $400 million in the Secondary Market consisting of investors – Falcon Edge Capital, D1 Capital Partners and TCV.

Dream11 Marketing Strategies

Dream11 spends the majority of its advertising budget on TV ads and digital marketing , especially social media advertisements. Here are a few notable marketing tactics that the company has used in recent times:

• Dream11 hired Khaby Lame as their new advertisement partner for the second leg of IPL, who is very popular on social media for his tik-tok videos. According to a report in a leading daily, Khaby Lame received INR 2 crore as part of the deal.
• The fantasy gaming platform became the official partner of IPL 2020 when Vivo pulled out for a year. Reportedly, Dream11 spent $2.2 billion to beat its competitors and finalize this deal.
• India’s #1 fantasy gaming app became the title sponsor of the domestic T20 tournament of New Zealand that goes by the name “Super Smash”, in 2019. The New Zealand Cricket Board has extended this relationship till 2026.
• The partnerships of Dream11 are not just limited to Cricket. In 2018, for instance, Dream 11 signed partnerships with the Pro Kabaddi League (PKL), the World Basketball League (WBBL), the International Hockey Federation (FIH), and the British Basketball League (BBL).
• In 2017 too, Dream11 became the official sponsors of many major sports leagues – the most notable ones being Hero Caribbean Premier League and Hero Indian Super League, NBA.

Dream11 Awards & Achievements

• Dream 11 holds a Guinness World Record! The company achieved the incredible feat of the “largest online fantasy cricket match” during the 2019 IPL final between Mumbai Indians (MI) and Chennai Super Kings (CSK). As many as 1,03,17,928 teams were created by dream11 users for the competition. This was the first-ever Guinness World Record created in the online fantasy sports category.
• Dream11 was listed among the top 10 biggest and most popular trends of 2018, as per a Google report.
• The brand was among the top 42 innovative startups as per Inc42’s 42Next list
• Dream 11 clinched the 9 th rank among India’s great Mid-Size workplaces, in 2018.
• It was honoured with the prestigious Red Herring Global 100 Award in 2013. The Red Herring Awards highlight the most exciting startups from Asia, Europe and the Americas.

Dream11 Interesting Facts & Stats

The journey of Dream11 has been quite fascinating. Let’s take a look at some of the interesting facts and stats about the #1 fantasy gaming app:

• The fantasy platform has nearly 100 million verified users
• The company claims to have grown at a Compound Annual Growth Rate (CAGR) of 230% from 2018-2021
• Became a proud member of the Indian Unicorn club – the companies that reach the $1 billion valuation mark – in 2019
• Although the fantasy gaming platform took 3 years to reach the 1 million users mark, it took only 2 months to add 2 million more users.

Dream11 Top Competitors

Although Dream11 has the highest user base of all fantasy platforms, there are some emerging players that are providing decent competition to the former. Let’s take a look at the top competitors of Dream11:

• Paytm First Games

Dream11 Brand Ambassadors

Dream11 has so far appointed many Indian Cricket players as its brand ambassador. You will usually see multiple brand ambassadors of the fantasy gaming brand, especially during the IPL. The following cricketers have been the face of Dream11 on and off:

• Rohit Sharma
• Shikhar Dhawan
• Rishabh Pant
• Hardik Pandya
• Shreyas Iyer
• Jasprit Bumrah

It is interesting to see that Virat Kohli has never featured in any ad for Dream11. He endorses dream11’s rival Mobile Premier League (MPL).

Is it safe to play on Dream11?

This question often crosses the mind of beginners who install the app for the first time. Dream11 is a legal fantasy gaming app; so you shouldn’t worry about its safety anymore. Fantasy sports though can be addictive and users must exercise caution and not over-indulge.

The landscape of fantasy sports has drastically changed over the last decade. New apps are entering the picture at a very rapid pace. As a result, the fantasy gaming industry has already started to become saturated. Innovation, however, is needed to bring some freshness. For instance, a fantasy app could also introduce singles games to make itself more appealing to the fans of badminton, tennis, etc.

All present-day rivals of Dream11 use a similar point system and interface, which makes many users lose interest in the first go itself as most of them are searching for something fresh. Despite the emergence of powerful rivals, Dream11 has only grown and that too by leaps and bounds.

The future of Dream11 looks very promising considering how commercialized every sport is getting. We hope that you got some great information from this case study of Dream11!

For Queries, Feedback & Assistance

Ciim online support, 9:00am - 7:00pm, for admissions & career counselling, call back request.

• Our Trainers
• Student Reviews
• Online Payment
• Online Registration
• Get A Free Class
• Placements Gallery
• Life at CIIM
• Apply for Franchise
• Hire From Us
• Become Trainer
• Scholarships

Refer & Earn

• For Students
• For Teachers
• For Individual

Digital Marketing Courses

• Master in Digital Marketing
• Diploma in Digital Marketing
• Advanced Digital Marketing Certification
• Digital Marketing Foundation Course
• Online Advanced Digital Marketing Certification
• All Courses

Short Courses

• Paid Ads (Google, Facebook) Specialist
• Search Engine Optimisation (SEO) Specialist
• Social Media Marketing Specialist
• Ecommerce Marketing Specialist
• YouTube Marketing Specialist
• Affiliate Marketing Specialist
• Email Marketing Specialist
• Content Writing Specialist
• Google Adsense Specialist
• Amazon Marketing Course

Digital Marketing Courses Across India

• Himachal Pradesh
• Kurukshetra
• Yamunanagar
• Dharamshala
• Bahadurgarh

Digital Marketing Courses Across World

• Umm Al Quwain
• Ras Al Khaimah

Corporate Training Courses

• Corporate Training
• Educational Institutions

Quick Links

• Privacy Policy
• Terms & Conditions
• Get Direction

Apply Before April 27, 2024

To get scholarship of up to.