Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Draw the ER diagram for the following situation:

Real Estate Investment Company owns many shopping malls in different locations across the country. Each mall is identified by the unique number and is allocated the marketing manager. Within each shopping mall, there are many shops of different sizes and each shop has the unique number assigned. To encourage rental of its shops, company gives a negotiated discount to retailers who have shops in more than one mall. For each retailer renting shop, company needs to keep track of company name as well as name and phone number of contact person. Each shop generates the income stream that could vary from month to month because rental is based on a flat rental charge and a negotiated percentage of sales revenue. Rental period for each shop is maintained by a company. Each shop also has monthly expenses for scheduled and unscheduled maintenance and, for each maintenance event, the date, detail of maintenance, and total expenses are stored. Company requires to keep track of monthly income and expenses for each shop and to do ad hoc querying related to rental and maintenance of each shop.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M94668

Have any Question? 


Related Questions in DBMS

Database design discusion 150 wordsnormalizationplease

Database Design Discusion (150 words) Normalization Please respond to BOTH of the following questions: Question A In your own words discuss the benefits of normalization. Question B Do you think we should normalize our d ...

Assignmentproject descriptionextreme h2o is a company that

Assignment Project Description: Extreme H2O is a company that specializes in water sports. It is considering adding some new experiences for its customers. In a nearby community, there is a small river that can be used f ...

Homeworkunlimited pickers is a group of workers who have

Homework Unlimited Pickers is a group of workers who have joined together to provide harvesting services to farmers who need to have their crops brought in. The organization has many teams of workers who travel from loca ...

Task - overview of business casealive amp boating aampb is

Task - Overview of business case: Alive & Boating (A&B) is a small start-up company that sells small boats in Wagga. A&B keeps its models in several showrooms across the city. At this stage customers cannot view the avai ...

Assignment advanced relational databaseproject- advance

Assignment: Advanced Relational Database PROJECT- Advance SQL Overview: Using the knowledge garnered thus far, please solve all of the below problems. Please run the attached SQL script file at the SQL*PLUS prompt. This ...

Graph databases assignment1choose a social network that you

Graph Databases Assignment 1. Choose a social network that you use. Say, FaceBook, Twitter, LinkedIn, or anything else. 2. Design a model to store and manage relationship data from these social networks in a graph databa ...

Computer sciencein reference to your database design

Computer Science In reference to your Database Design Proposal: Proposal Outline, provide a narrative analysis of the customer and user needs by defining the customers and users as well as describing their individual nee ...

Database analysis and designimplement the initial database

Database Analysis and Design Implement the initial database design for the Enterprise Resource Planning conceptual model described by the following requirements in your selected RDBMS. You need to create the Entity-Relat ...

Assignmentthis must be your own unique work you cannot have

Assignment THIS MUST BE YOUR OWN UNIQUE WORK: you cannot have the exact same table as another student and you cannot turn in something you find online!Your work will be checked against a plagiarism database. The format m ...

Assignment database environment proposalas one of the

Assignment: Database Environment Proposal As one of the program outcomes for the Bachelor of Science in Information Technology program, students must design and develop a database using professional principles and standa ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro