SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 314 Weeks Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 28 Nov 2017 My Price 10.00

Notepad to write the SQL statements and submit according

Please help me with the attached assignment. This Lab will use MySQL.

 

Submit Your SQL Command File: by using Notepad to write the SQL statements and submit according the lab instructions.

 

Thank you.

  • CIS336 Lab #3 Data Dictionary 
                       
    Table Name Column Name Description of Data Data Type Lgth NOT NULL PK FK Default  
                       
    ZIPCODE                  
      Zip Zipcode INTEGER 11   Y      
      City City name VARCHAR 25 Y        
      State State CHAR 2 Y        
                       
    INSTRUCTOR                  
      Instructor_ID Instructor id number INTEGER 6   Y      
      Salutation Greeting VARCHAR 5          
      First_name First  name VARCHAR 25 Y        
      Last_Name Last name VARCHAR 25 Y        
      Street_Address Street address VARCHAR 50          
      Zip Zipcode INTEGER 11 Y   Y    
                       
    STUDENT                  
      Student_ID Student id number INTEGER 6   Y      
      Salutation Greeting VARCHAR 5          
      First_name First  name VARCHAR 25 Y        
      Last_Name Last name VARCHAR 25 Y        
      Street_Address Street address VARCHAR 50          
      Zip Zipcode INTEGER 11 Y   Y    
      Phone Local phone number VARCHAR 15 Y        
      Employer Employer VARCHAR 50          
      Registration_Date Date registered DATE   Y        
                       
    COURSE                  
      Course_ID Course identifier INTEGER 6   Y      
      Description Course description VARCHAR 50 Y        
      Cost Cost of course DECIMAL 8,2          
      Prerequisite Prerequisite course INTEGER 6     Y    
                       
    SECTION                  
      Section_ID Section identifier INTEGER 8   Y      
      Course_Section_Num Section number in course INTEGER 6 Y        
      Start_Date_Time Date and time course begins DATETIME   Y        
      Location Building and room VARCHAR 10          
      Capacity Max number of students INTEGER 3          
      Instructor_ID Instructor identifier INTEGER 6 Y   Y    
      Course_ID Course identifier INTEGER 6 Y   Y    
                       
    ENROLLMENT                  
      Section_ID Section identifier INTEGER 8   Y Y    
      Student_ID Student identifier INTEGER 6   Y Y    
      Enroll_Date Date of enrollment DATE   Y        
      Final_Grade Grade CHAR 1          
                       
                       
                       
                       
                       
                       

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 28 Nov 2017 10:11 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)