-- DATABASE MANAGEMENT SYSTEMS 2019/20
-- LECTURE 4 QUERIES
-- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

/*
	Consider the Branch table for DreamHome:
		Branch(branchNo, streetAddress, city, postcode, phoneNo)

	Here are the data definition requirements:
		branchNo: Character String, Size: 5, Required, PK
		streetAddress: Character String, Size: 30, Required
		city: Character String, Size: 20, Required
		postcode: Character String, Size 8, Required, Limit values to min length 6
		phoneNo: Character String, Size 12, Required

	QUESTION: Which of the following SQL statement(s) is/are correct to add a new record into the branch table?
*/

INSERT INTO Branch (BranchNo, StreetAddress, City, PhoneNo) 
VALUES ('B0009', '17 High St', 'Swansea', '01792480000')

INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) 
VALUES ('B0009', '17 High St', 'Swansea', 'SA1 6ED', '01792480000')

INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) 
VALUES ('B0009', '17 High St', 'Swansea', 'SA1 6ED', 01792480000)

INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) 
VALUES ('B0009', '17 High St', 'Swansea', 'SA1 6ED', 'NULL')

INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) 
VALUES ('B0009', '17 High St', 'SA1 6ED', '01792480000')

INSERT INTO Branch (BranchNo, StreetAddress, City, Postcode, PhoneNo) 
VALUES ('B0009', '17 High St', 'Swansea', 'SA1 6ED', NULL)
