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

Fundamentals of databases assignment 1 -q1 explain the

Fundamentals of Databases Assignment 1 - Q1. Explain the distinction between total and partial constraints. Q2. Explain the difference between a weak and a strong entity set. Q3. Explain the distinction between disjoint ...

Ms access database assignment helpdo the easy way i really

MS ACCESS Database assignment help (DO THE EASY WAY I really just need this asap) (I have the database file ready to email to you. I dont think it let me upload the database file here.) Create a simple excel spreadsheet ...

The use of an access database has become very common over

The use of an Access database has become very common over the last 10 years. Access is the preferred desktop database because server databases such as structured query language (SQL) and others are too complex and are be ...

Relational databases theory and practice assignmentanswer

Relational databases: theory and practice Assignment ANSWER ALL QUESTIONS Question 1 - Use the block notes to answer the following questions: i. Explain what is meant by the process of denormalization and how it is done. ...

Mis 204 hands-on activityaccess - forms and

MIS 204 Hands-On Activity: Access - Forms and Reports Introduction In this assignment you will learn how to create forms and reports to access and analyze your data. Forms are useful for data entry and navigation. Report ...

Prepare a brief report that describes how data warehouses

Prepare a brief report that describes how data warehouses and online transaction processing complement each other. In your report make sure to include the following: • Why do companies use data warehouses? • What are the ...

The strayer oracle server may be used to test and compile

The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server. A multina ...

Assignment1write a query that retrieves studentlastname

Assignment 1. Write a query that retrieves student.last_name, student.first_name and total number of enrollments from the student and enrollment tables. Your query should also include students that do not have any enroll ...

Hotel reservationsproject descriptionthe main portion of

Hotel Reservations Project Description: The main portion of the resort is the hotel. The hotel wants to store information about hotel guests, reservations, and rooms. You will design tables, import data from Access and E ...

Database design discusion post and assignmentdiscusion post

Database Design Discusion Post and Assignment Discusion Post: Data as a Corporate Resource and Foreign Keys Please respond to BOTH of the following questions: Question A Discuss how data can be a corporate resource and d ...

  • 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

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

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen