Question Details

(Solved) -- Table AlarmSummary CREATE TABLE AlarmSummary( AlarmID INT PRIMARY KEY, Summary VARCHAR(30), TroubleType VARCHAR(30), ); -- Table TimeOfOccurence


Design and develop the below queries using professional principles and standards:

  • A set of SQL Statements that returns all rows and all data for each table in your database.
  • Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause
  • Two SQL Statements that join two or more tables in one query.  Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.


My previous code is attached. thanks!

-- Table AlarmSummary
CREATE TABLE AlarmSummary(
AlarmID INT PRIMARY KEY,
Summary VARCHAR(30),
TroubleType VARCHAR(30),
);
-- Table TimeOfOccurence
CREATE TABLE TimeOfOccurence(
TimeOfOccurenceID INT PRIMARY KEY,
FirstOccurence VARCHAR(30),
LastOccurence VARCHAR(30),
Counts VARCHAR(50),
);
-- Table EquipmentTypeLocation
CREATE TABLE EquipmentType(
EquipmentTypeLocationID INT PRIMARY KEY,
DeviceType VARCHAR(50),
Address VARCHAR(50),
Zip VARCHAR(10),
);
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(1, 'EXP Denial of Service', 'Data');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(2, '"INPUT, INVALID TARGET ID"', 'Switching');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(3, 'REPT ALM FAN SM=3 AISLE=0103', 'Switching');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(4, 'REPT ALM MISC 47 DAC', 'Switching');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(5, 'T3 - incoming DS3 LOS', 'Transport');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(6, 'T1 - incoming DS1 LOS', 'Transport');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(7, 'OC3 - inc. OC3 LOS', 'Transport');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(8, 'EXP Denial of Service', 'Data');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(9, 'Node Down - Ping Fail', 'Data');
INSERT INTO AlarmSummary(AlarmID, Summary, TroubleType)
VALUES(10, 'Node Down - Ping Fail', 'Data');
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(1, '2/9/17 7:48AM', '2/10/17 6:44PM', 11);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(2, '2/9/17 8:45AM', '2/10/17 6:44PM', 1);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(3, '2/9/17 4:33AM', '2/10/17 6:44PM', 23);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(4, '2/9/17 11:40AM', '2/10/17 6:44PM', 4);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(5, '2/9/17 6:51PM', '2/10/17 6:44PM', 49);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence, LastOccurence,
LastOccurence,
LastOccurence,
LastOccurence,
LastOccurence,
LastOccurence, Counts)
VALUES(6, '2/9/17 11:01PM', '2/10/17 6:44PM', 37);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(7, '2/9/17 4:20PM', '2/10/17 6:44PM', 1);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(8, '2/9/17 7:48AM', '2/10/17 6:44PM', 1);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(9, '2/9/17 7:48AM', '2/10/17 6:44PM', 7);
INSERT INTO TimeOfOccurence(TimeOfOccurenceID, FirstOccurence,
Counts)
VALUES(10, '2/9/17 7:48AM', '2/10/17 6:44PM', 12);
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(1, 'DMS100', '123 Chelsea St', '34653');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(2, 'DMS10', '123 2nd St', '33616');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(3, '5ESS', '123 George St', '34654');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(4, 'DCO', '123 Grayton Ct', '85128');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(5, 'TEKELEC', '123 Flager Rd', '61652');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(6, 'DANTEL', '123 Okeechobee Ave', '71285');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(7, 'LUCENT', '123 Crush Pl', '90210');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(8, 'CENTURION', '123 Adamo Dr', '123456');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(9, 'TELSEC', '123 3rd St', '33610');
INSERT INTO EquipmentTypeLocation(EquipmentTypeLocationID,
Zip)
VALUES(10, 'NTI', '123 1st St', '36752'); LastOccurence,
LastOccurence,
LastOccurence,
LastOccurence, DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,
DeviceType, Address,

 


Solution details:
STATUS
Answered
QUALITY
Approved
ANSWER RATING

This question was answered on: Sep 05, 2019

PRICE: $18

Solution~000200071960.zip (25.37 KB)

Buy this answer for only: $18

This attachment is locked

We have a ready expert answer for this paper which you can use for in-depth understanding, research editing or paraphrasing. You can buy it or order for a fresh, original and plagiarism-free solution (Deadline assured. Flexible pricing. TurnItIn Report provided)

Pay using PayPal (No PayPal account Required) or your credit card . All your purchases are securely protected by .
SiteLock

About this Question

STATUS

Answered

QUALITY

Approved

DATE ANSWERED

Sep 05, 2019

EXPERT

Tutor

ANSWER RATING

GET INSTANT HELP/h4>

We have top-notch tutors who can do your essay/homework for you at a reasonable cost and then you can simply use that essay as a template to build your own arguments.

You can also use these solutions:

  • As a reference for in-depth understanding of the subject.
  • As a source of ideas / reasoning for your own research (if properly referenced)
  • For editing and paraphrasing (check your institution's definition of plagiarism and recommended paraphrase).
This we believe is a better way of understanding a problem and makes use of the efficiency of time of the student.

NEW ASSIGNMENT HELP?

Order New Solution. Quick Turnaround

Click on the button below in order to Order for a New, Original and High-Quality Essay Solutions. New orders are original solutions and precise to your writing instruction requirements. Place a New Order using the button below.

WE GUARANTEE, THAT YOUR PAPER WILL BE WRITTEN FROM SCRATCH AND WITHIN YOUR SET DEADLINE.

Order Now