Course Hero Logo

Assign-3.docx - Assignment # 3 Total: 40 points Submit the...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 2 out of 2 pages.

Assignment # 3Total: 40 pointsSubmit the assignment through the Assignment3 Dropbox.Name the file as:BUSA-526_A3_FIRSTNAME_LASTNAME.DOCXWhat to SubmitScreenshots of the things you do (e.g. creating shema, creating tables, insertqueries)Question 1(10 pts)Create a database schema with the name ‘EmpInfo’Question 2Create tables based on the logical schema below.Note: you need to defineprimary key(s), foreign key(s), constraints, and correct data types to get the credits.
End of preview. Want to read all 2 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
Robert.F
Tags
Foreign key, primary key, Screenshots of the things

Unformatted text preview: (20 pts) Logical Schema: Employee(EmployeeID , EmployeeFirstName, EmployeeLastName) Supervior(EmployeeID , SupervisorID ) Course(CourseID , CourseTitle) EmployeeCourse( EmployeeCourseID , EmployeeID, CourseID , DateCompleted) Legend: Primary Key : Bold and underline. Foreign Key : Italics Question 3(10 pts)Insert 5 sample records for each table....
View Full Document

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture