{"id":434553,"date":"2018-04-25T03:59:13","date_gmt":"2018-04-25T03:59:13","guid":{"rendered":"https:\/\/essaypaper.org\/assignment-on-creating-sql-table-relationships\/"},"modified":"2018-10-24T09:08:56","modified_gmt":"2018-10-24T09:08:56","slug":"assignment-on-creating-sql-table-relationships","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/assignment-on-creating-sql-table-relationships\/","title":{"rendered":"Assignment on Creating SQL Table Relationships"},"content":{"rendered":"
\n
\n

This assignment on SQL table relationships was completed by an expert who is knowledgeable in the IT sphere. You can read this sample, but you can\u2019t present it as your own homework. On our blog, in addition to this sample, a variety of different examples of tasks and their solutions are presented. In any case, the use of our service will be helpful for you, as we also offer expert help. It is worth paying attention to Assignment.EssayShark.com because we offer the best help with technical assignments on the market.<\/em><\/p>\n

While your order is being completed, you have the opportunity to contact the expert directly via chat and ask any questions. Our service occupies a special place in students\u2019 lives. First of all, it concerns those students who don\u2019t have time to deal with their homework. Using our service is absolutely legal, and your personal information will be secure. Read our IT sample to see how our experts solve tasks.<\/em><\/p>\n<\/blockquote>\n

Creating Tables and Establishing Relationships Using SQL<\/strong><\/h2>\n

The Department of labor and wages, on the basis of specifications of products, schedules a production plan of demand for workers of different specialties and qualifications.<\/p>\n

Input information:<\/p>\n

The Production Department gives the specifications of the product and the need, in hours, for workers of different professions and places in the context of workshops and production units for each product.<\/p>\n

The planning section generates the schedule of release, which contains the planned number of products of each type for each date.<\/p>\n

Listed is the creation of tables and relationships between them and basic queries of SQL. Note: creating a database is done in SQL Server 2014.<\/p>\n

CREATE DATABASE<\/span> WorkforcePlanning<\/p>\n

CREATE TABLE<\/span> Department (ID int<\/span> NOT NULL,
Name nvarchar<\/span>(40) NOT NULL ,
PRIMARY KEY<\/span> (ID))<\/p>\n

CREATE TABLE<\/span> Speciality (ID int<\/span> NOT NULL,
DepartmentID int<\/span> NOT NULL,
Name nvarchar<\/span>(40) NOT NULL,
Qualification int<\/span> NOT NULL,
Gap time<\/span> NOT NULL,
PRIMARY KEY<\/span> (ID),
FOREIGN KEY<\/span> (DepartmentID) REFERENCES<\/span> Department(ID))<\/p>\n

CREATE TABLE<\/span> Demand (ID int<\/span> NOT NULL,
SpecialityID int<\/span> NOT NULL,
Amount int<\/span> NOT NULL,
PRIMARY KEY<\/span> (ID),
FOREIGN KEY<\/span> (SpecialityID) REFERENCES<\/span> Speciality(ID))<\/p>\n

CREATE TABLE<\/span> Products (ID int<\/span> NOT NULL,
Name nvarchar<\/span>(40) NOT NULL,
Price decimal<\/span>(12, 2) NOT NULL,
PRIMARY KEY<\/span> (ID))<\/p>\n

CREATE TABLE<\/span> CalendarPlan (ID int<\/span> NOT NULL,
ProductID int<\/span> NOT NULL,
DepartmentID int<\/span> NOT NULL,
Quantity int<\/span> NOT NULL,
Shelf date<\/span> NOT NULL,
PRIMARY KEY<\/span> (ID),
FOREIGN KEY<\/span> (ProductID) REFERENCES<\/span> Products(ID),
FOREIGN KEY<\/span> (DepartmentID) REFERENCES<\/span> Department(ID))<\/p>\n

INSERT INTO<\/span> Department (ID , Name)
VALUES<\/span> (1 ,\u2019Bridges Dpt\u2018<\/span><\/span>),
(2 ,\u2019Wheels Dpt<\/span>\u2018),
(3 ,\u2019Hinges Dpt<\/span>\u2018),
(4 ,\u2019Generators Dpt<\/span>\u2018),
(5 ,\u2019Engines Dpt<\/span>\u2018);<\/p>\n

INSERT INTO<\/span> Speciality (ID , DepartmentID , Name, Qualification , Gap)
VALUES<\/span> (1 ,1, \u2018Tinker<\/span>\u2018, 2, CONVERT<\/span>(time<\/span>, \u201810:00:00<\/span>\u2018)),
(2 , 2, \u2018 Mechanic<\/span>\u2018, 1, CONVERT<\/span>(time<\/span>, \u201820:00:00<\/span>\u2018)),
(3 , 3, \u2018 Locksmith<\/span>\u2018, 5, CONVERT<\/span>(time<\/span>, \u201811:00:00<\/span>\u2018)),
(4 , 4, \u2018Electrician<\/span> \u2018, 3, CONVERT<\/span>(time<\/span>, \u201816:00:00<\/span>\u2018)),
(5 , 5, \u2018Tire installer<\/span>\u2018, 4, CONVERT<\/span>(time<\/span>, \u201817:00:00<\/span>\u2018));<\/p>\n

INSERT INTO<\/span> Demand (ID , SpecialityID , Amount)
VALUES<\/span> (1 , 1, 4),
(2 , 2, 2),
(3 , 3, 1),
(4 , 4, 3),
(5 , 5, 6);<\/p>\n

INSERT INTO<\/span> Products (ID , Name , Price)
VALUES<\/span> (1 , \u2018Wheels\u2019<\/span>, 2500.00),
(2 , \u2018Bridge<\/span>\u2018, 2000.00),
(3 , \u2018Hinge<\/span>\u2018, 1500.00),
(4 , \u2018Generator<\/span>\u2018, 1250.00),
(5 , \u2018Engine<\/span>\u2018, 1000.00);<\/p>\n

INSERT INTO<\/span> CalendarPlan (ID , ProductID , DepartmentID, Quantity, Shelf)
VALUES<\/span> (1 , 3, 2, 20, CONVERT<\/span>(date<\/span>, \u201830\/09\/1<\/span>5\u2032, 3)),
(2 , 2, 1, 10, CONVERT<\/span>(date<\/span>, \u201825\/09\/15<\/span>\u2018, 3)),
(3 , 4, 3, 40, CONVERT<\/span>(date<\/span>, \u201820\/09\/15<\/span>\u2018, 3)),
(4 , 5, 5, 70, CONVERT<\/span>(date<\/span>, \u201811\/09\/15<\/span>\u2018, 3)),
(5 , 1, 4, 50, CONVERT<\/span>(date<\/span>, \u201810\/09\/15<\/span>\u2018, 3));<\/p>\n

\"\"<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"

This assignment on SQL table relationships was completed by an expert who is knowledgeable in the IT sphere. You can read this sample, but you can\u2019t present it as your own homework. On our blog, in addition to this sample, Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,25],"tags":[],"class_list":["post-434553","post","type-post","status-publish","format-standard","hentry","category-essay-paper-writing","category-samples"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/434553","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=434553"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/434553\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=434553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=434553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=434553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}