Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Part A) CREATE THE TABLES

Create database schema for the tables given below using the CREATE TABLE command.

Part B) ADD THE DATA

Populate the table using the INSERT statement. As an ex, the first insert statement for the Supplier table would be as follows:

INSERT INTO Supplier ( Supplier_ID, Supplier_Name, City, Status) VALUES (100, Northern, Sudbury, 20);

Part C) SQL QUERIES

Provide the SQL queries for each of the following:

(Note: provide only the requested information – no more, no less).

a) List all the supplier names and their locations.

b) List all the Part names and colours

c) List all the Supplies with a status of at least 30.

d) List the supplier name and part number for each part in the inventory

e) List all the parts (name and id) supplied by ‘Quality’ (without using Supplier_ID=102)

f) What is total weight for all the parts?

g) List the supplier names who supply the parts located in Sault Ste Marie

h) How many parts are there with quantity more than 300?

i) Provide a parts list for each part in stock, ordered by part number and providing the following details:

Part_ID, Part_Name, Part_Colour, Part_Weight, QtyOnHand, Supplier_Name

1836_Supplier-inventory database.jpg

1830_Parts databae table.jpg

DBMS, Programming

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

Have any Question? 


Related Questions in DBMS

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 ...

Virtualization fundamentalsunit 3 research projectwrite an

Virtualization Fundamentals Unit 3 Research Project Write an overview of *any two* of the following topics. Each overview should be between one half and one full page long. You should use a minimum of two sources for eac ...

Objective this is an individual assignment aimed to give

Objective: This is an individual assignment aimed to give the student exposure to the concepts relating to database systems and optimal strategies for efficient management of databases Learning Outcomes assessed: 1. Crea ...

This assignment consists of two 2 sections a design

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name accor ...

Create a data definition class to model one product sold at

Create a data definition class to model one product sold at a bakery. The product will have a description, cost, and quantity in stock. Instance methods include: accessors for each instance variable, non-validating mutat ...

Assignmentthis assignment requires you to design a video

Assignment This assignment requires you to design a video rental database system that will provide the functionality outlined below. Your grade will be based on how well your system can accommodate the requirements, your ...

1 what is the most popular database model2 how are primary

1. What is the most popular database model? 2. How are primary and foreign keys different? 3. What are the five important software components of a database management system? 4 What are the four major types of data-minin ...

Lab modifying a database design in visiothis assignment

Lab: 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: De ...

Assignmentas the new manager of a convenience store you

Assignment As the new manager of a convenience store, you have noticed issues with the manual method of tracking sales using paper sales tickets and spreadsheets, as well as, shortages on some of the more popular items c ...

Describe a database that might be used in nursing using

Describe a database that might be used in nursing. Using this data, explain the relationship between a field, a record, a table and a database. In addition, what are the advantages of managing database information in Acc ...

  • 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