CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) );   CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL ); EXTRACT YEAR. Using the tables above, create a query that returns all the rows from the movie table and displays the movie id, movie title, and movie’s release year (not the full date). Must provide screenshots of the resulting table.

create database CTU__YourICASNoGOUSE CTU__YourICASNo;GOCREATE TABLE Course(    CourseID int PRIMARY KEY,    CourseName varchar(255),    CourseDesc varchar(255),);insert into Course(CourseID,CourseName,CourseDesc)values(11334,'Foundation','Basic1')insert into Course(CourseID,CourseName,CourseDesc)values(11335,'MCSD','Basic2');insert into Course(CourseID,CourseName,CourseDesc)values(11336,'MCSE','Basic3');insert into Course(CourseID,CourseName,CourseDesc)values(11337,'MCSA','Basic4');insert into Course(CourseID,CourseName,CourseDesc)values(11338,'CAD','Basic5'); CREATE TABLE Students(    ICASNo int Primary Key,    StudentName varchar (255),    StudentSurname varchar (255),    StudentContact varchar (255),    StudentEmail varchar(255),    HighSchoolAttended varchar(255),    courseID varchar (255),);insert into…

PLZ help with the following: 1. Populate every relation with “sufficient” representative rows (at least 4 for each table). Create table book (title varchar(80) not null, year INT not null , num INT primary key , subject Varchar(50) null);    Create table client (CID int primary key,fname varchar(20), lname varchar(20), type varchar(6), constraint checkclient check (type in ('Faculty', 'Student')));     Create table author (year INT, ID INT primary key, fname varchar(50) not null,lname varchar(50)); Create table BookAuthors(booknum int, authorID int, primary key (booknum, authorID), constraint fk_book foreign key (booknum) references book(num),constraint fk_author foreign key (authorid) references author(id));   create table bookcheckouts( booknum int, clientID int, checkoutdate date, expectedDuedate date not null, returnedate date, primary key (booknum, clientID, checkoutDate),constraint book_checks foreign key(booknum) references book(num),constraint book_clients foreign key…

Database course:  a.  Add attribute deptId to the table course.   b.  Update deptId in table course of course NW3101 to “NW”.   c.  Create a view named batch1 that contains student id, student name and the department name of all students.

Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx  as the value for the employee ID for every row inserted.   You may choose values for the other columns   Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row).   Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin

create a unique Key Index

CREATING TABLES USING oracle APEX   CREATE TABLE DEPT ( DEPTNO NUMBER(10) NOT NULL, DNAME VARCHAR2(50) NOT NULL, LOC VARCHAR2(50), CONSTRAINT DEPT_PK PRIMARY KEY (DEPTNO) );   NOTNULL constraint is used it represents cell should not be empty Here NUMBER AND VARCHAR are data types   Step 2 Now create emp table   CREATE TABLE EMP( EMPNO NUMBER(10) NOT NULL, ENAME VARCHAR2(50) NOT NULL, JOB VARCHAR2(50), MGR VARCHAR2(50), HIREDATE DATE, SAL NUMBER(6), DEPTNO NUMBER(10) NOT NULL, CONSTRAINT EMP_PK PRIMARY KEY(EMPNO), CONSTRAINT EMP_FK FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO) );   oracle consists of standard DATE formats we have to use that PRIMARY KEY is used to uniquely identify records from the table FOREIGN KEY is used to establish the connection between any two tables Here DEPT is a resultant table of EMP table   Step 3 Now SALGRADE TABLE   CREATE TABLE SALGRADE ( GRADE NUMBER (10) NOT NULL, LOSAL NUMBER(6), HISAL NUMBER(6), CONSTRAINT SALGRADE_PK PRIMARY KEY…

Hi triggers Update and using Xampp and this table: CREATE TABLE MEMBER(STUDENT_ID CHAR(6) NOT NULL,CLUB_CODE VARCHAR(4) NOT NULL,MEMBER_DATE DATE NOT NULL,MEMBER_POSITION VARCHAR(15) NOT NULL,MEMBER_ATTENDANCE CHAR(2) NOT NULL,PRIMARY KEY (STUDENT_ID,CLUB_CODE),FOREIGN KEY (STUDENT_ID) REFERENCES STUDENT (STUDENT_ID) ON DELETE RESTRICT ON UPDATE CASCADE,FOREIGN KEY (CLUB_CODE) REFERENCES CLUB (CLUB_CODE) ON DELETE RESTRICT ON UPDATE CASCADE); INSERT INTO MEMBER VALUES('100027','C201','2020-03-25','Secretary','12'),('100027','C202','2020-04-11','Member','11'),('100032','C201','2020-02-23','President','12'),('100050','C201','2020-03-25','Member','10'),('100132','C202','2020-04-11','Treasurer','10'),('100074','C203','2020-04-09','President','12'),('100074','C204','2020-04-25','Treasurer','12'),('100051','C204','2020-04-25','Member','9'),('100064','C207','2020-04-25','Vice…