SQL Homework Help l Database Assignment l SQL Project

Our Experts provide answer for your all your SQL assignments and do ensure that you have precise solution that will satisfy you in your academics.

SQL stands for Structured Query Language, and is designed to work with databases, most database systems support SQL although there can be some advanced features that are only available for a specific database engine.

If you require help with your SQL homework then check out this example.

SQL

Problem:

Problem-Based Learning Scenario

A retail store wants to offer its products online in response to numerous customers requesting to be able to purchase the company’s products electronically. The company is beginning to see some growth in spite of the recent economic downturn. The company strives to meet the needs of its customers, including giving them the perception that they
are the company’s highest priority. Being a profitable operation has not always been the case, and the company has historically struggled with customer service issues, inventory-management problems, employee turnover, and poor productivity overall. Naturally, the stakeholders of the company began to lose faith in the viability of the company, and unfortunately, numerous stakeholders have dissolved their relationship with the retail store entirely.

Approximately 7 years ago, the company hired a freelance information technology (IT) organization to create a data-driven information system that would support customer records and order entry. The store manager convinced the owner of the company that this route was the way to go. After all, anything would be an improvement over what the company had at the time. The owner felt that because it was important to have an efficient way to track customers and orders, any computerized system would be sufficient. He was not too proud to share his lack of technological skills, and often deferred to others when it came to making decisions in this area. He often joked that perhaps some computer training would do him and his employees some good. He was never really assured that his data were backed up correctly or that his system was secure. And what if the system crashed or the data started to appear unusual? He also had never heard of any of his employees backing up the system files. If he lost all of his data, he would not know where to turn or what to do. The very idea of his business depending so much on technology was almost too stressful to think about. Deep down, however, he really wanted some assurance that his information was reliable and secure.

The customer records and order entry system that was installed solved a few problems for the short term but quickly proved to lack the capability to meet the goals, objectives, and overall data needs of the company. The freelance technology company provided no documentation on how to use the system or even how it was designed. A large component that was missing was having the ability to track the product inventory. The system in its current state does not seem to be fully functional and often lets employees override the store procedures that the owner has clearly stated should be adhered to. For example, customers are given discounts when they are not eligible, certain products are completely depleted from inventory without being flagged for reorder, and prospects who have never placed an order are set up as customers with a fake order to give them free product samples and promotional materials. This usually involves a person who is friends with an employee collaborating to set up fake order for a product that is not even real.

Although the owner does not feel that he is very technically proficient, he admits that perhaps he should have researched the needs of his company and the possible options before jumping on the first opportunity that presented itself. He knows that he reacted to the problem instead of responding in an effective manner. After all of that trouble, employees cannot keep track of customer records, orders get misplaced on the system, and products that are not in inventory keep coming up as available. The problem has gotten so bad that the owner has directed all employees to resort back to the manual method to handle all daily business transactions.

At this point in the company’s history, the need for positive changes is apparent to the owner. He is committed to his company and his customers. He values all of the input that stakeholders have provided to him over the years and knows that with a little determination, the company can be a success. His employees are loyal to him and appreciate his
attentiveness to their needs and concerns. He knows that each employee is good at solving problems and wants to able to reward all of them by recognizing when they are able to solve problems for the company. He sees his employees as dedicated and capable of meeting any of the goals and objectives that he sets for them. He often compliments them on the
cleanliness of the store and the way that the shelves are organized. He has told them that the company takes pride in its appearance and ability to greet the customer with a smile. This includes having the products that the customer wants at a reasonable price; that is what he calls customer service.

SQL programming assignment help provided by SQL tutors are of great value as they give you clear cut explanation on what is required. SQL programming assignment involves important concepts like- Join (Self join, Right outer Join, Left outer join, Outer join), Intersection, View, Order by, Group by, Triggers and etc.

Problem-Based Learning Perspectives:

Kelly, Customer Service Representative

“Every time customers call me and want to know the status of their order, I feel like it takes forever for the system to provide a simple answer to a simple question. I can understand why customers get frustrated with us because all they want is to know what is going on with their order. After all, they are trying to coordinate their busy lives and such. I feel like an idiot when I cannot answer the customer right away, and I am upset because I thought this system would make things better. I feel like I spend more time listening to customers complain, and it makes me uncomfortable.”

Mark, Cashier

“I don’t understand why I can’t simply give the customers a break sometimes. I know they should not get a discount all the time, but if I know them, I think it is good customer service to make them happy. Plus, the system allows me to do it. If this was such a bad thing, then the system should not allow me to give discounts and promotional products
when I am not supposed to.”

Sandy, Product Manager

“This new system was supposed to help me manage product inventory more efficiently but it isn’t. I do not have time to go back into the warehouse and count everything. I told customers that we had plenty of stock, and we actually had none in the warehouse, so naturally the customers are really angry with me. But it is not my fault. The system told a different story, and I relied on the system to be right. Now the owner is mad at me because he thinks I am not capable of doing my job. He says I should always check to make sure that the system is not lying, but I don’t have the time to do this!”

Ralph, Store Manager

“I really thought a new system was the way to go; after all, technology is supposed to solve all problems, right? Why can’t things just work? The owner is really upset because we spend so much time trying to fix problems that occur on a daily basis that we do not have time to make things better in the store. At this point, we will never be able to sell
our products online. We cannot even manage the store we have! Orders get misplaced, customers are angry because the wrong products come in on their orders, and I am really tired. I just don’t understand it. I have seen technology actually help businesses run more smoothly. Why does technology not work for us?”

Ellen, Customer

“I love the convenience of shopping online. With my busy lifestyle, I have no time to go shopping at the store for what I need. I do appreciate being treated with respect as a customer too. After all, I should get the product I want at a fair price and should have the ability to choose from a wide selection. I love the websites that have
customer support options so that I can call if I have a problem. I will be honest, however, that I have little patience for order mix-ups and things like that. A company that sticks by its word, though, means a lot to me. We all make mistakes; it’s how we fix those mistakes that matters.”

Deliverable 1

The retail store has provided you with a list of some of the business rules that they use to conduct business on a daily basis. The company has also provided you with the subjects of interest to them, namely those things that the company wants to track in the process of taking orders from their customers. What can be done to effectively document
the relational database system solution that you are proposing to the retail store?

The project deliverables are as follows:

  • Subjects of Interest (proposed entities)
    • Customers
    • Orders
    • Products
    • Add a minimum of 3 of your own subjects of interest based on
      > your retail store.
  • Business Rules
    • Each product is assigned to a maximum of 1 category.
    • A person who has placed at least 1 order is a customer.
    • All products have a minimum reorder level.
    • Add a minimum of 3 of your own business rules based on your
      > retail store.
  • Entity–Relationship Model (4–5 pages)
    • Include a list of the business rules that will be enforced by
      > the proposed database system.
    • Include a list or table of the entities, attributes (including
      > data types), relationships, and cardinality constraints.
    • Include an entity–relationship (E–R) diagram that uses crow’s
      > foot notation and graphically depicts the entities, attributes
      > (including data types), and relationships (including degree
      > and cardinality constraints).
    • Verify that the data design that is depicted in the E–R diagram
      > adheres to a minimum of third normal form (3NF), and if
      > necessary, provide documentation and justification for the use
      > of a higher level of normal form.
  • Provide your analysis as to how this part of the project fulfills
    > the mission and 1 or more goals of the case study organization.
  • Note: Use Microsoft Visio or equivalent to create the
    > E–R diagram. You will embed the diagram in the Word document and
    > also provide it as an attachment.

You need to be very good at these in order to develop good queries. This involves sometime good online help with SQL programming from our online SQL expert. You can approach us with all your SQL programming queries and can get easy help with SQL assignment.

Deliverable 2

The case study retail store has provided a list of reports and data
manipulation tasks that are needed in the processing of orders for their
customers. Answer the following:

  • What structured query language (SQL) statement scripts are needed to
    > create the database schema for the relational database system and
    > manipulate the data in the solution that you are proposing to the
    > company?
  • How does each of these scripts specifically support the goals and
    > objectives of the company?

The project deliverables are as follows:

  • Data Manipulation Tasks
    • Insert 20 records into each table for testing purposes.
    • Delete an entire order by using the unique identifier for
      > that order.
    • Update the price of a product by using the unique identifier for
      > that product.
    • Add a minimum of 3 of your own data manipulation language (DML)
      > scripts based on the needs and specifications of your
      > retail store.
  • Report List
    • Total revenue (sales) per month, grouped by customer
    • Total revenue (sales) per month, grouped by product
    • Total count of products, grouped by category
    • Add minimum of 3 of your own report scripts based on the needs
      > and specifications of your retail store (one must be
      > a CROSSTAB)
  • SQL (4–5 pages)
    • Include the database definition language (DDL) scripts to CREATE
      > to database schema as described in the
      > entity–relationship (E–R) diagram (Unit 2).
    • Include the database manipulation scripts (DML) that will be
      > used to INSERT, DELETE, and UPDATE data in the proposed
      > database system.
    • Include the SELECT, CROSSTAB, and AGGREGATE FUNCTION statements
      > that will be used to read data from the proposed
      > database system.
    • Provide your analysis as to how this part of the project
      > fulfills the mission and 1 or more goals of the case
      > study organization.
    • Provide the following attachments (in addition to embedding in
      > document):

      • DDL.sql (including CREATE and INSERT statements so that they
        > execute in the correct order)
      • DML.sql (including DELETE and UPDATE statements so that they
        > can be executed in any order as selected)
      • REPORT.sql (including SELECT, CROSSTAB, AGGREGATE
        > FUNCTION statements so that they can be executed in any
        > order as selected)
    • Note: You will embed each script in the Word document and
      > also provide it as an attachment.

SQL programming also involve important DBMS concepts like Entity relationship diagram which shows the table relationship with all primary keys and foreign keys. When you create your queries you can use create query and then select to generate any report and when you want to delete the column, can use delete and when drop a table can use Drop queries.

Report.sql

 --1 . Total revenue (sales) per month, grouped by customer

 set dateformat dmy 
 select customer_id,b.customer_name, sum(quantity*product_price) 
 from 
 (
     select a.products_id,a.product_price,b.order_id,b.quantity,c.customer_id
     from Products a,Order_Items b ,Orders c
     where a.products_id = b.product_id
     and b.order_id = c.order_id
     and c.order_date between '01/07/2014' and '31/07/2014'
)a,Customers  b 
where a.customer_id = b.customers_id
group by customer_id,customer_name

 --2 Total revenue (sales) per month, grouped by product

 select products_id,product_name, sum(product_price*quantity) 
 from 
 (
     select a.products_id,a.product_name, a.product_price,b.order_id,b.quantity,c.customer_id
     from Products a,Order_Items b ,Orders c
     where a.products_id = b.product_id
     and b.order_id = c.order_id
     and c.order_date between '01/07/2014' and '31/07/2014'
)a
group by products_id,product_name

--3 Total count of products, grouped by category

select a.category_id,a.category_name ,count(*) totalProduct
from Product_category a, Products b 
where a.category_id =  b.products_id
group by a.category_id,a.category_name
order by a.category_id

--

-- Codetab folow order_date , AGGREGATE  function 
     select a.products_id,a.product_name,
     sum(case when order_date between '01/01/2014' and '31/03/2014' then product_price*quantity else 0 end) Q1,
     sum(case when order_date between '01/04/2014' and '30/06/2014' then product_price*quantity else 0 end)Q2,
     sum(case when order_date between '01/07/2014' and '30/09/2014' then product_price*quantity else 0 end) Q3,
     sum(case when order_date between '01/10/2014' and '31/12/2014' then product_price*quantity else 0 end) Q4
     from Products a,Order_Items b ,Orders c
     where a.products_id = b.product_id
     and b.order_id = c.order_id
     group by a.products_id,a.product_name

     select customer_id,b.customer_name, sum(quantity*product_price) 
     from 
     (
         select a.products_id,a.product_price,b.order_id,b.quantity,c.customer_id
         from Products a,Order_Items b ,Orders c
         where a.products_id = b.product_id
         and b.order_id = c.order_id
         and c.order_date between '01/07/2014' and '31/07/2014'
    )a,Customers  b 
    where a.customer_id = b.customers_id
    group by customer_id,customer_name
    having sum(quantity*product_price)  > 1000000000

    --------------------------------- THEN END -----------------------------------------

     --and c.order_date between '01/07/2014' and '31/07/2014'

This is quite easy but when comes with importance if using it-here come the problem. You needed then an expert guidance. Experts from our website on SQL programming has helped you to gain tremendous knowledge and provide help with SQL programming assignment.

DDL.SQL

GO
/****** Object:  Table [dbo].[Addresses]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO

--1.
IF OBJECT_ID('dbo.Employees', 'U') IS NOT NULL
drop table [dbo].[Employees]

--2
IF OBJECT_ID('dbo.Order_Items', 'U') IS NOT NULL
   drop table [dbo].[Order_Items]

--3.
IF OBJECT_ID('dbo.Orders', 'U') IS NOT NULL
drop table [dbo].[Orders]
--4.
IF OBJECT_ID('dbo.Products', 'U') IS NOT NULL
drop table [dbo].[Products]
--5.
IF OBJECT_ID('dbo.Product_category', 'U') IS NOT NULL
drop table [dbo].[Product_category]
--6.
IF OBJECT_ID('dbo.Customers', 'U') IS NOT NULL
drop table [dbo].[Customers]
--7.
IF OBJECT_ID('dbo.Addresses', 'U') IS NOT NULL
drop table [dbo].[Addresses]

CREATE TABLE [dbo].[Addresses](
    [address_id] [bigint] NOT NULL,
    [line1] [varchar](50) NOT NULL,
    [line2] [varchar](50) NULL,
    [city] [varchar](50) NOT NULL,
    [zip_postcode] [varchar](6) NOT NULL,
    [state_province_contry] [varchar](50) NOT NULL,
    [contry] [varchar](50) NOT NULL,
    [other_address_details] [varchar](50) NULL,
 CONSTRAINT [PK_Addresses] PRIMARY KEY CLUSTERED 
(
    [address_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Customers]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Customers](
    [customers_id] [bigint] NOT NULL,
    [customers_address_id] [bigint] NOT NULL,
    [customer_name] [varchar](20) NOT NULL,
    [customer_phone] [varchar](15) NOT NULL,
    [customer_email] [varchar](30) NOT NULL,
    [date_become_customer] [date] NOT NULL,
    [other_customer_details] [varchar](50) NULL,
 CONSTRAINT [PK_Customers] PRIMARY KEY CLUSTERED 
(
    [customers_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Employees]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Employees](
    [employe_id] [bigint] NOT NULL,
    [employe_name] [varchar](20) NOT NULL,
    [employee_address_id] [bigint] NOT NULL,
    [employe_start_date] [date] NOT NULL,
    [employe_position] [varchar](20) NOT NULL,
 CONSTRAINT [PK_Employees] PRIMARY KEY CLUSTERED 
(
    [employe_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Order_Items]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Order_Items](
    [order_id] [bigint] NOT NULL,
    [product_id] [bigint] NOT NULL,
    [quantity] [bigint] NULL,
    [discount] [tinyint] NULL,
 CONSTRAINT [PK_Order_Items] PRIMARY KEY CLUSTERED 
(
    [order_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Orders]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Orders](
    [order_id] [bigint] NOT NULL,
    [customer_id] [bigint] NOT NULL,
    [order_status] [varchar](50) NULL,
    [order_date] [date] NULL,
    [order_details] [text] NULL,
 CONSTRAINT [PK_Orders] PRIMARY KEY CLUSTERED 
(
    [order_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Product_category]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Product_category](
    [category_id] [bigint] NOT NULL,
    [category_name] [varchar](20) NOT NULL,
    [category_description] [text] NULL,
 CONSTRAINT [PK_Product_category] PRIMARY KEY CLUSTERED 
(
    [category_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[Products]    Script Date: 7/26/2014 3:37:58 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Products](
    [products_id] [bigint] NOT NULL,
    [product_category] [bigint] NOT NULL,
    [product_name] [varchar](50) NOT NULL,
    [product_price] [numeric](18, 0) NOT NULL,
    [product_discount_price] [numeric](18, 0) NOT NULL,
    [product_description] [text] NULL,
    [quantitie_in_stockes] [bigint] NOT NULL,
    [minimum_reorder_quantitie] [bigint] NOT NULL,
 CONSTRAINT [PK_Products] PRIMARY KEY CLUSTERED 
(
    [products_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
ALTER TABLE [dbo].[Customers]  WITH CHECK ADD  CONSTRAINT [FK_Customers_Addresses] FOREIGN KEY([customers_address_id])
REFERENCES [dbo].[Addresses] ([address_id])
GO
ALTER TABLE [dbo].[Customers] CHECK CONSTRAINT [FK_Customers_Addresses]
GO
ALTER TABLE [dbo].[Employees]  WITH CHECK ADD  CONSTRAINT [FK_Employees_Addresses] FOREIGN KEY([employee_address_id])
REFERENCES [dbo].[Addresses] ([address_id])
GO
ALTER TABLE [dbo].[Employees] CHECK CONSTRAINT [FK_Employees_Addresses]
GO
ALTER TABLE [dbo].[Order_Items]  WITH CHECK ADD  CONSTRAINT [FK_Order_Items_Orders] FOREIGN KEY([order_id])
REFERENCES [dbo].[Orders] ([order_id])
GO
ALTER TABLE [dbo].[Order_Items] CHECK CONSTRAINT [FK_Order_Items_Orders]
GO
ALTER TABLE [dbo].[Order_Items]  WITH CHECK ADD  CONSTRAINT [FK_Order_Items_Products] FOREIGN KEY([product_id])
REFERENCES [dbo].[Products] ([products_id])
GO
ALTER TABLE [dbo].[Order_Items] CHECK CONSTRAINT [FK_Order_Items_Products]
GO
ALTER TABLE [dbo].[Orders]  WITH CHECK ADD  CONSTRAINT [FK_Orders_Customers] FOREIGN KEY([customer_id])
REFERENCES [dbo].[Customers] ([customers_id])
GO
ALTER TABLE [dbo].[Orders] CHECK CONSTRAINT [FK_Orders_Customers]
GO
ALTER TABLE [dbo].[Products]  WITH CHECK ADD  CONSTRAINT [FK_Products_Product_category] FOREIGN KEY([product_category])
REFERENCES [dbo].[Product_category] ([category_id])
GO
ALTER TABLE [dbo].[Products] CHECK CONSTRAINT [FK_Products_Product_category]
GO
USE [master]
GO
ALTER DATABASE [Test] SET  READ_WRITE 
GO

 USE [Test]
--1 Table Addresses

SET DATEFORMAT YMD

--1.
DELETE FROM [dbo].[Order_Items]
--2.
DELETE FROM [dbo].[Orders]
--3.
DELETE FROM [dbo].[Products]
--4.
DELETE FROM [dbo].[Product_category]
--5.
DELETE FROM [dbo].[Employees]
--6.
DELETE FROM [dbo].[Customers]
--7.
DELETE FROM [dbo].[Addresses]

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (1, 'Nguyen Oanh', '12 District', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Thanh Loc')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (2, 'Nguyen Si', 'Binh Thanh District', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Binh Thanh')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (3, 'Dien Bien Phu', 'Binh Thanh District', 'Ho Chi Minh', '084', 'Ho Chi Minh ', 'Viet Nam', 'Binh Thanh')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (4, 'Nguyen Buu', 'Hoang Kiem', 'Ha Noi', '084', 'Ha Noi', 'Viet Nam', 'Hoang Kiem')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (5, 'Lam Tam', 'Hoang Mai', 'Ha Noi', '084', 'Ha Noi', 'Viet Nam', 'Hoang Mai')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (6, 'Cung La Thieu', 'Hoang Viet', 'Ha Noi', '084', 'Ha Noi', 'Viet Nam', 'Hoang Viet')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (7, 'Viet Tech', 'Dong Da', 'Ha Noi', '084', 'Ha Noi', 'Viet Nam', 'Dong Da')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (8, 'Lukuka', 'Matham', 'Ha Noi', '084', 'Ha Noi', 'Viet Nam', 'Lukuka')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (9, 'Nguyen Kiem', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (10, 'Quang Trung 10', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (11, 'Quang Trung 11', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (12, 'Quang Trung 12 ', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (13, 'Quang Trung 13', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (14, 'Quang Trung 14', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (15, 'Quang Trung 15', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (16, 'Quang Trung 16', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (17, 'Quang Trung 17', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (18, 'Quang Trung 18', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (19, 'Quang Trung 19', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

INSERT INTO [dbo].[Addresses] ([address_id], [line1], [line2], [city], [zip_postcode], [state_province_contry], [contry], [other_address_details])
VALUES (20, 'Quang Trung 20', 'Go Vap', 'Ho Chi Minh', '084', 'Ho Chi Minh', 'Viet Nam', 'Go Vap')

-- 2 .Customers
DELETE FROM [dbo].[Customers]
GO

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (1, 1, 'Nguyen Van', '09113321', 'dungvan1308@gmail.com', '20140706', 'Nguyen Van Dung')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (2, 2, 'Nguyen Hung', '1213123424', 'dungvan1308@gmail.com', '20140726', 'Nguyen Van A')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (3, 3, 'Nguyen Van 3', '13131234235', '324234324', '20140706', 'Nguyen Van 3')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (4, 4, 'Nguyen Van 4', '12131234124', '34234234', '20140726', 'Nguyen Van 4')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (5, 5, 'Nguyen Van 5', '43234234', '234234234', '20140726', 'Nguyen Van 5')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (6, 6, 'Nguyen Van 6', '4234234', '324234@YAHOO.COM', '20140726', 'Nguyen Van 6')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (7, 7, 'Nguyen Van 7', '423423443', '3423542345', '20140726', 'Nguyen Van 7')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (8, 8, 'Nguyen Van 8', '234234243', '234234234', '20140726', 'Nguyen Van 8')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (9, 9, 'Nguyen Van 9', '23412421', '1234234', '20140726', 'Nguyen Van 9')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (10, 10, 'Nguyen Van 10 ', '3423435', '234243234', '20140726', 'Nguyen Van 10')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (11, 11, 'Nguyen Van 11', '3423435', '234243234', '20140726', 'Nguyen Van 11')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (12, 12, 'Nguyen Van 12', '3423435', '234243234', '20140726', 'Nguyen Van 12')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (13, 13, 'Nguyen Van 13', '3423435', '234243234', '20140726', 'Nguyen Van 13')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (14, 14, 'Nguyen Van 14', '3423435', '234243234', '20140726', 'Nguyen Van 14')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (15, 15, 'Nguyen Van 15', '3423435', '234243234', '20140726', 'Nguyen Van 15')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (16, 16, 'Nguyen Van 16', '3423435', '234243234', '20140726', 'Nguyen Van 16')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (17, 17, 'Nguyen Van 17', '3423435', '234243234', '20140726', 'Nguyen Van 17')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (18, 18, 'Nguyen Van 18', '3423435', '234243234', '20140726', 'Nguyen Van 18')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (19, 19, 'Nguyen Van 19', '3423435', '234243234', '20140726', 'Nguyen Van 19')

INSERT INTO [dbo].[Customers] ([customers_id], [customers_address_id], [customer_name], [customer_phone], [customer_email], [date_become_customer], [other_customer_details])
VALUES (20, 20, 'Nguyen Van 20', '3423435', '234243234', '20140726', 'Nguyen Van 20')

-- 3 Employees
DELETE FROM [dbo].[Employees]
GO

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (1, 'Employee 1', 1, '20140726', '1')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (2, 'Employee 2', 2, '20140726', '2')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (3, 'Employee 3', 3, '20140726', '3')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (4, 'Employee 4', 4, '20140726', '4')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (5, 'Employee 5', 5, '20140726', '5')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (6, 'Employee 6', 6, '20140726', '6')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (7, 'Employee 7', 7, '20140726', '7')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (8, 'Employee 8', 8, '20140726', '8')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (9, 'Employee 9', 9, '20140726', '9')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (10, 'Employee 10', 10, '20140726', '10')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (11, 'Employee 11', 11, '20140726', '11')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (12, 'Employee 12', 12, '20140726', '12')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (13, 'Employee 13', 13, '20140726', '13')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (14, 'Employee 14', 14, '20140726', '14')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (15, 'Employee 15', 15, '20140726', '15')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (16, 'Employee 16', 16, '20140726', '16')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (17, 'Employee 17', 17, '20140726', '17')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (18, 'Employee 18', 18, '20140726', '18')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (19, 'Employee 19', 19, '20140726', '19')

INSERT INTO [dbo].[Employees] ([employe_id], [employe_name], [employee_address_id], [employe_start_date], [employe_position])
VALUES (20, 'Employee 20', 20, '20140726', '20')

-- 4 . Orders

DELETE FROM [dbo].[Orders]
GO

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (1, 1, 'Normal', '20140726', 'Order details 1')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (2, 2, 'Normal', '20140726', 'Order details  2')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (3, 3, 'Normal', '20140726', 'Order details 3')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (4, 4, 'New', '20140726', 'Order details 4')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (5, 5, 'New', '20140726', 'Order details  5')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (6, 6, 'New', '20140726', 'Order details 6')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (7, 7, 'New', '20140726', 'Order details  7')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (8, 8, 'New', '20140726', 'Order details  8')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (9, 9, 'New', '20140726', 'Order details  9')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (10, 10, 'New', '20140726', 'Order details  10')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (11, 11, 'New', '20140726', 'Order details  11')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (12, 12, 'New', '20140726', 'Order details  12')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (13, 13, 'New', '20140726', 'Order details  13')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (14, 14, 'New', '20140726', 'Order details  14')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (15, 15, 'New', '20140726', 'Order details  15')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (16, 16, 'New', '20140726', 'Order details  16')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (17, 17, 'New', '20140726', 'Order details  17')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (18, 18, 'New', '20140726', 'Order details  18')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (19, 19, 'New', '20140726', 'Order details  19')

INSERT INTO [dbo].[Orders] ([order_id], [customer_id], [order_status], [order_date], [order_details])
VALUES (20, 20, 'New', '20140726', 'Order details  20')

-- 5 .Product_category

DELETE FROM [dbo].[Product_category]
GO

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (1, 'Category 1', 'Category Descript 1')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (2, 'Category 2', 'Category Descript 2')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (3, 'Category 3', 'Category Descript 3')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (4, 'Category 4', 'Category Descript 4')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (5, 'Category 5', 'Category Descript 5')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (6, 'Category 6', 'Category Descript 6')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (7, 'Category 7', 'Category Descript 7')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (8, 'Category 8', 'Category Descript 8')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (9, 'Category 9', 'Category Descript 9')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (10, 'Category 10', 'Category Descript 10')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (11, 'Category 11', 'Category Descript 11')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (12, 'Category 12', 'Category Descript 12')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (13, 'Category 13', 'Category Descript 13')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (14, 'Category 14', 'Category Descript 14')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (15, 'Category 15', 'Category Descript 15')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (16, 'Category 16', 'Category Descript 16')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (17, 'Category 17', 'Category Descript 17')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (18, 'Category 18', 'Category Descript 18')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (19, 'Category 19', 'Category Descript 19')

INSERT INTO [dbo].[Product_category] ([category_id], [category_name], [category_description])
VALUES (20, 'Category 20', 'Category Descript 20')

-- 6 . Product
DELETE FROM [dbo].[Products]
GO

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (1, 1, 'Product 1', 100000, 5000, 'product decription 1', 1, 1)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (2, 2, 'Product 2', 100000, 5000, 'Product descrtion 2', 2, 2)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (3, 3, 'Product 3', 100000, 5000, 'Product descrtion 3', 3, 3)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (4, 4, 'Product 4', 100000, 5000, 'Product descrtion 4', 4, 4)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (5, 5, 'Product 5', 100000, 5000, 'Product descrtion 5', 5, 5)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (6, 6, 'Product 6', 100000, 5000, 'Product descrtion 6', 6, 6)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (7, 7, 'Product 7', 100000, 5000, 'Product descrtion 7', 7, 7)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (8, 8, 'Product 8', 100000, 5000, 'Product descrtion 8', 8, 8)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (9, 9, 'Product 9', 100000, 5000, 'Product descrtion 9', 9, 9)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (10, 10, 'Product 10', 100000, 5000, 'Product descrtion 10', 10, 10)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (11, 11, 'Product 11', 100000, 5000, 'Product descrtion 11', 11, 11)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (12, 12, 'Product 12', 100000, 5000, 'Product descrtion 12', 12, 12)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (13, 13, 'Product 13', 100000, 5000, 'Product descrtion 13', 13, 13)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (14, 14, 'Product 14', 100000, 5000, 'Product descrtion 14', 14, 14)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (15, 15, 'Product 15', 100000, 5000, 'Product descrtion 15', 15, 15)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (16, 16, 'Product 16', 100000, 5000, 'Product descrtion 16', 16, 16)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (17, 17, 'Product 17', 100000, 5000, 'Product descrtion 17', 17, 17)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (18, 18, 'Product 18', 100000, 5000, 'Product descrtion 18', 18, 18)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (19, 19, 'Product 19', 100000, 5000, 'Product descrtion 19', 19, 19)

INSERT INTO [dbo].[Products] ([products_id], [product_category], [product_name], [product_price], [product_discount_price], [product_description], [quantitie_in_stockes], [minimum_reorder_quantitie])
VALUES (20, 20, 'Product 20', 100000, 5000, 'Product descrtion 20', 20, 20)

-- 7 Order_Items
DELETE FROM [dbo].[Order_Items]
GO

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (1, 1, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (2, 2, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (3, 3, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (4, 4, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (5, 5, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (6, 6, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (7, 7, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (8, 8, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (9, 9, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (10, 10, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (11, 11, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (12, 12, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (13, 13, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (14, 14, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (15, 15, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (16, 16, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (17, 17, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (18, 18, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (19, 17, 100000, 1)

INSERT INTO [dbo].[Order_Items] ([order_id], [product_id], [quantity], [discount])
VALUES (20, 20, 100000, 1)

You can be a very good expert on SQL programming and then you can be a good expert. This can only happen when you have good helping hand. Our online expert with SQL programming can be excellent in providing help with SQL programming. You can be ensured of good grade by our experts. This has enabled us to establish trust among online student communities across globe. There are also scenario where project involves Java embedding SQL code.

Gaining concept on SQL is always easy when it come to our SQL programming expert. This is something which our expert are able to establish over a years of time. We have assisted all the students from globe. They have gained good knowledge and hence confidence on SQL programming.

DML.SQL

 SET DATEFORMAT YMD

--1.
DELETE FROM [dbo].[Order_Items]    WHERE <Search Conditions,,>
GO 
--2.
DELETE FROM [dbo].[Orders]  WHERE <Search Conditions,,> 
GO 
--3.
DELETE FROM [dbo].[Products]  WHERE <Search Conditions,,> 
GO 
--4.
DELETE FROM [dbo].[Product_category]  WHERE <Search Conditions,,> 
GO 
--5.
DELETE FROM [dbo].[Employees]  WHERE <Search Conditions,,>
GO 
--6.
DELETE FROM [dbo].[Customers] WHERE <Search Conditions,,>
GO

--7.
DELETE FROM [dbo].[Addresses] WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Products]
   SET [products_id] = <products_id, bigint,>
      ,[product_category] = <product_category, bigint,>
      ,[product_name] = <product_name, varchar(50),>
      ,[product_price] = <product_price, numeric(18,0),>
      ,[product_discount_price] = <product_discount_price, numeric(18,0),>
      ,[product_description] = <product_description, text,>
      ,[quantitie_in_stockes] = <quantitie_in_stockes, bigint,>
      ,[minimum_reorder_quantitie] = <minimum_reorder_quantitie, bigint,>
 WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Product_category]
   SET [category_id] = <category_id, bigint,>
      ,[category_name] = <category_name, varchar(20),>
      ,[category_description] = <category_description, text,>
 WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Orders]
   SET [order_id] = <order_id, bigint,>
      ,[customer_id] = <customer_id, bigint,>
      ,[order_status] = <order_status, varchar(50),>
      ,[order_date] = <order_date, date,>
      ,[order_details] = <order_details, text,>
 WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Order_Items]
   SET [order_id] = <order_id, bigint,>
      ,[product_id] = <product_id, bigint,>
      ,[quantity] = <quantity, bigint,>
      ,[discount] = <discount, tinyint,>
 WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Employees]
   SET [employe_id] = <employe_id, bigint,>
      ,[employe_name] = <employe_name, varchar(20),>
      ,[employee_address_id] = <employee_address_id, bigint,>
      ,[employe_start_date] = <employe_start_date, date,>
      ,[employe_position] = <employe_position, varchar(20),>
 WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Customers]
   SET [customers_id] = <customers_id, bigint,>
      ,[customers_address_id] = <customers_address_id, bigint,>
      ,[customer_name] = <customer_name, varchar(20),>
      ,[customer_phone] = <customer_phone, varchar(15),>
      ,[customer_email] = <customer_email, varchar(30),>
      ,[date_become_customer] = <date_become_customer, date,>
      ,[other_customer_details] = <other_customer_details, varchar(50),>
 WHERE <Search Conditions,,>
GO

UPDATE [dbo].[Addresses]
   SET [address_id] = <address_id, bigint,>
      ,[line1] = <line1, varchar(50),>
      ,[line2] = <line2, varchar(50),>
      ,[city] = <city, varchar(50),>
      ,[zip_postcode] = <zip_postcode, varchar(6),>
      ,[state_province_contry] = <state_province_contry, varchar(50),>
      ,[contry] = <contry, varchar(50),>
      ,[other_address_details] = <other_address_details, varchar(50),>
 WHERE <Search Conditions,,>
GO

I hope that after looking at these examples you decide to contact us to offer you help with Sql assignment.

Our Experts always follow simple approach while providing solution on SQL programming help. They provide you simple query which can be easily understandable by anyone. When you submit it to your university, your university professor will never establish a link that you have copied it from anywhere. Your need and our service both go hand in hand. This is something which can be done when you come to us for SQL programming assignment help. When you come to us, our student coordinator can always be a helping hand and can guide you to establish engagement with our online SQL experts. You can interact and then once done with your SQL programming assignment can be happy.

You can be ensured that your SQL programming homework help is completed within time. Your solution is plagiarism free and is testing well before delivering it to you. Our online SQL expert believes in providing easy help with easy comments so that you are able to gain confidence on us.  Our online SQL experts are available all the time at your service.