Scribd
Upload
5 views1 page

SQL Database Creation Guide

The document contains SQL commands for creating a database named 'myDB' and three tables: 'Customers', 'Products', and 'Vendors'. Each table is defined with specific fields and data types, including primary keys and foreign keys. The structure is designed to manage customer, product, and vendor information.

Uploaded by

Sock the Cat
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
5 views1 page

SQL Database Creation Guide

The document contains SQL commands for creating a database named 'myDB' and three tables: 'Customers', 'Products', and 'Vendors'. Each table is defined with specific fields and data types, including primary keys and foreign keys. The structure is designed to manage customer, product, and vendor information.

Uploaded by

Sock the Cat
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Name: Shylle John Reyvet S Mortera Section: BSIT 202A

CREATE DATABASE myDB;

CREATE TABLE Customers( CustomerID int NOT NULL PRIMARY KEY, FirstName
varchar(50), LastName varchar(50), Email varchar(50), Gender varchar(50), Birthdate date, );

CREATE TABLE Products( ProductID int NOT NULL PRIMARY KEY, Description
varchar(250), Quantity int, Price decimal(10, 2), VendorID int NOT NULL FOREIGN KEY, );

CREATE TABLE Vendors( VendorID int NOT NULL PRIMARY KEY, Name varchar(50),
ContactNum int, );

You might also like