Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Answer all the problems. You might use exs illustrations or diagrams to support the answer. You have to implement database system using any RDBMS.

Departmental store maintains inventory of goods about its sections. Each section could sell a number of items. Item sold by one section might be part of other section also. Departmental store has number of registered buyers. Some of the buyers, though, might not be registered. A buyer purchases one or more items and number of such items. Buyer gets a bill for the purchases s/he made. A buyer could purchase many times in a month. A buyer might buy several times even in a single day. Buyer who had made purchase of more than Rs10,000/- in a month, is given a status of preferred buyer. Preferred buyer is given a discount of 5% on all purchases on all the purchases made in the next month. Store obtains all items from the stockiest. Each item has the item code. All acquisition of items is recorded. Cost price of an item of a different acquisition might be different. Selling price of the item is decided by cost price of that item, handling overheads and profit margin. For all the items the store presently uses them as fixed quantity.
Perform following tasks for the store. Make and state assumptions, if any.

1)   List the entities, their attributes and relationships for the description and make the ER-diagram for the Store. You might use concept of keys, aggregation, generalisation, cardinality etc. in a proper way.                   

2) Design appropriate RDBMS tables for ER-diagram so created in problem 1. Database design must include keys, foreign keys, constraints and referential integrity constraints.   

3) Implement database design which you have created in problem 2 using the RDBMS – our advice is that you select either MySQL or MS ACCESS to do so.       

4) Create following data entry forms with appropriate checks for database so created.

a) Create a form to enter all the information about items being purchased by the buyer on a particular sale.

b) Create the form to register a new buyer.               

5) Enter at least 4 sets of records in each table. Enter marks directly in tables except for the data which could be entered using data entry form created in problem 3.   

6) Create following reports for the database you have created. The reports must have proper headings and page numbers and must include totals, if required.           

a) Create bill of a purchase.

b) Create a price list of items.

c) Create the list of preferred buyers.

d) Create the detailed list of purchases made by a single buyer.       

7) prepare and run the following SQL queries for your database:        

a) Determine the details of the buyers who have made purchases of more than 15,000 in a month..

b) Determine the price of the costliest item and the names of all the buyers who have bought it.

c) Determine the item details of the item that has been sold the most.

d) Determine the difference in number of average buyers on weekends and the number of average buyers on weekdays.

e) Determine the stockiest form whom maximum number of items are acquired.

8) Design two views for database which you have designed and implemented. One view must be for the Manager of the Departmental Store who is interested in knowing about performance (quantity sold) of different items in various sections. The other view is for a buyer who could view his/her purchases made from the stores. Identify on what tables and what fields these two would be allowed to have access. Implement these views or prepare equivalent queries for the view defining expression using SQL.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M92324
  • Price:- $70

Priced at Now at $70, Verified Solution

  • AsyU replied

    Honestly good quality of solution, and i would like to thanks mywordsolution.com for providing me an excellent service.. thank you so much...

Have any Question? 


Related Questions in DBMS

Restaurants and fast-food chains rely heavily on business

Restaurants and fast-food chains rely heavily on business intelligence to make important decisions. Casinos do as well. Some of the leading restaurants, fast-food chains, and casinos using data warehouses include AFC Ent ...

Describe a dbms and its functions list at minimum three of

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each. Your response should be at least 200 words in length. Explain what mobile devices are and why ...

Movie theater database entity-relationship modeldevelop a

Movie Theater Database: Entity-Relationship Model Develop a Microsoft Access database based upon the below Entity Relationship Model. Be sure to include tables, fields, keys, relationships, and data in your database. You ...

Lab assignment working with additional database objectslab

Lab Assignment: Working with Additional Database Objects LAB OVERVIEW Scenario and Summary There is a lot more to a database than just tables and the data in them. A very important part of database security has to do wit ...

Data analysis assignment- apriori analysis and cluster

Data Analysis assignment- ApriorI analysis and Cluster analysis CLUSTER ANALYSIS The purpose of this assignment is to demonstrate steps performed in a K-Means Cluster analysis. Review the "k-MEANS CLUSTERING ALGORITHM" s ...

Data information decision please respond to the

"Data Information Decision" Please respond to the following: • With the obvious pace of current technology development, data continues to grow daily. Imagine that you are a Database Administrator for a large organization ...

Lab 2 modifying a database design in visiothis assignment

Lab 2: Modifying a Database Design in Visio This assignment contains two Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment. Use "Appendix A: ...

Analytical assignment individual or group of max two

Analytical Assignment (Individual or Group of Max two students) What is Research article? Review articles provides summary of current state of the research on a particular topic. Ideally, the writer searches for everythi ...

Exercise 1 - html and Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance

Exercise 1 - HTML and XML ID Name Stars Facilities Address Distance from center (KM) Available 1 Les Jardins du Marais 3 Internet 74 rue Amelot, Paris, 75011 2 True 2 Golden Tulip Little Palace 4 Internet Gym Parking Res ...

Warehouse management system projectproject deliverablesthe

Warehouse management system project Project Deliverables The project requires students to perform three phases: (a) requirements analysis, (b) system and database design, and (c) a project plan. Note that in the phase 3, ...

  • 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