V

@Videonerd03

Book practice for exam

MySQL
8 months ago
CREATE TABLE Author ( AuthorID INT PRIMARY KEY, Name VARCHAR(100), BirthYear INT ); CREATE TABLE Book( Title VARCHAR(100), AuthorID INT, Genre VARCHAR(50),

Practice Query

MySQL
8 months ago
CREATE TABLE Employees ( EmployeeID INT AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(30), LastName VARCHAR(30), DepartmentID INT ); CREATE TABLE Department ( DepartmentID INT AUTO_INCREMENT PRIMARY KEY, DepartmentName VARCHAR(30),

Complex queries three

MySQL
8 months ago
CREATE TABLE Customer ( CustomerID INT AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(30), LastName VARCHAR(30), Email VARCHAR(50) UNIQUE, JoinDate DATE ); CREATE TABLE `Order`( OrderID INT AUTO_INCREMENT PRIMARY KEY,

Complex queries two

MySQL
8 months ago
CREATE TABLE District ( DistrictCode VARCHAR(5) PRIMARY KEY, DistrictName VARCHAR(50) NOT NULL ); CREATE TABLE School ( SchoolID INT, SchoolName VARCHAR(50), DateConstructed DATE, OperatingBudget DECIMAL(3,1) UNSIGNED,

Complex Queries (one)

MySQL
8 months ago
CREATE TABLE Rating ( RatingCode VARCHAR(30) PRIMARY KEY, RatingDescription VARCHAR(30) ); CREATE TABLE Movie ( Title VARCHAR(30), RatingCode VARCHAR(5), Genre VARCHAR(30), Year INT UNSIGNED,

Tyler Hoechlin Table

MySQL
8 months ago
CREATE TABLE Projects ( project_id INT PRIMARY KEY, title VARCHAR(255), -- ENUM Ensures that every project in your table is clearly categorized into one of three types type ENUM('Film', 'TV', 'Video Game'), release_year INT ); CREATE TABLE Movie_Roles ( role_id INT PRIMARY KEY,

Director list

MySQL
9 months ago
CREATE TABLE Directors( DirectorID INT PRIMARY KEY, DirectorName VARCHAR(50) ); CREATE TABLE Movies( MovieID INT PRIMARY KEY, Title VARCHAR(50), ReleaseYear VARCHAR(50), MainCast VARCHAR(50),

Superman table

MySQL
9 months ago
CREATE TABLE Comics ( ComicID INT PRIMARY KEY, Title VARCHAR(150), YearsPublished INT, Publisher VARCHAR(100), Volume INT ); CREATE TABLE Movies ( MovieID INT PRIMARY KEY,

Employee (Practice for exam)

MySQL
9 months ago
-- write a sql statement to insert the indicated data into the employee table -- auto_increment is a feature in SQL that automatically generates a unique number for a column whenever a new row is inserted. -- Most commonlly used for primary keys, ID, or Employee ID CREATE TABLE Employee( EmployeeID INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName VARCHAR(255), LastName VARCHAR(255), Salary DECIMAL(10,2), -- 10 total number of digts

Movie Table (Practice for exam)

MySQL
9 months ago
-- Designate the year column in the movie table as a foreign key to the year column in the YearStats table CREATE TABLE YearStats( YEAR INTEGER PRIMARY KEY, TotalGross BIGINT UNSIGNED, Releases INTEGER ); CREATE TABLE Movies( ID INTEGER PRIMARY KEY,

Football games

MySQL
9 months ago
-- College table CREATE TABLE College( CollegeID INT NOT NULL, Name VARCHAR(45), City VARCHAR(45), State CHAR(2), PRIMARY KEY(CollegeID) ); -- Bowl Game table

library

MySQL
9 months ago
-- TABLE CREATION CREATE TABLE Authors ( AuthorID INT PRIMARY KEY, AuthorName VARCHAR(50), BirthYear INT ); CREATE TABLE Books ( BookID INT PRIMARY KEY,

Phone book

MySQL
10 months ago
-- UNSIGNED means the column cannot be negative; only zero and positive numbers -- AUTO_INCREMENT automatically assigns a unique value to each new row; typically used for primary keys -- Column constraint appears after the column name and data type in a CREATE TABLE statement. Govern values in a single column -- NOT NULL is a column constraint CREATE TABLE address ( address_id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT, address VARCHAR(12) NOT NULL, address2 VARCHAR(12) DEFAULT