Data Management Final Project Plan: Please edit the attached week 6 rough draft

Data Management Final Project Plan:
Please edit the attached week 6 rough draft project plan using the instructions below. Submit the week 6 rough draft project plan with edits as final project plan.
DATA DICTIONARY:
** Missing most of the tables for this section
CREATE TABLE SCRIPTS:
** Missing most of the scriipts. Should be including the scriipts from Week 5 physical design (added below) with following updates
1 – Creation of foreign keys not correct in your scriipts. Please see correct example below:
CREATE TABLE Course(
Course_ID int PRIMARY KEY
, Course_Name varchar(35)
, Course_Descriiption varchar(35)
, Instructor_ID int FOREIGN KEY REFERENCES Instructor(Instructor_ID)
);​
REMINDERS FROM WEEK 5:
Instructor
** FirstName, LastName: varchar
** City: varchar, missing size
** Specialty: varchar
** Address: varchar, increase size
Student:
** PhoneNumber missing datatype and size
** GradeID: integer
Grade:
** GradeID: integer
** GradeType, GradeWeight: missing data size
Instructor:
** PhoneNumber: missing datatype and size
CourseSchedule:
** Add Semester
** Add Year
Week 5 Data Management Project: Physical Design
CREATE TABLE Student (
Student_ID int, PRIMARY KEY
Course_ID int, FOREIGN KEY
First_Name varchar(35),
Last_Name varchar(35),
PhoneNumber,
DOB Date,
Student_Address varchar(20)
Grade_ID varchar, FOREIGN KEY
);
CREATE TABLE Grade (
Grade_ID varchar, PRIMARY KEY
Student_ID int, FOREIGN KEY
COURSE_ID int, FOREIGN KEY
Grade_type varchar,
Grade_weight varchar,
);
CREATE TABLE Instructor(
Instructor_ID int, PRIMARY KEY
Instructor_Name varchar(35),
Speciality varchar(100),
PhoneNumber,
Address varchar(20),
Course_ID int, FOREIGN KEY
);
CREATE TABLE CourseEnrolment(
Course_ID varchar, PRIMARY KEY 1 FOREIGN KEY 1
Student_ID varchar, PRIMARY KEY 2 FOREIGN KEY 2
Instructor_ID varchar, PRIMARY KEY 3 FOREIGN KEY 3
);
CREATE TABLE Course(
Course_ID int, PRIMARY KEY
Course_Name varchar(35),
Course_Descriiption varchar(35),
Instructor_ID int, FOREIGN KEY
);
INSERT INTO student ( Student_ID, Course_ID, First_Name, Last_Name, PhoneNumber, DOB, Student_Address, Grade_ID)
VALUES (Max Miller, ENG1, Max, Miller, 900267147, Feb 18, 2000, 21 Blue Street California, B);

Posted in Uncategorized

Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount