Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

. Create a new database named according to your firstname lastname-PartB (E.g., Eran Rubin - Part B) 2. The database should contain tables that

. Create a new database named according to your firstname lastname-PartB (E.g., Eran Rubin - Part B) 2. The database should contain tables that implement the following ER diagram. It is up to you to decide on the appropriate types to for the attributes you create in the tables. Y Note: you can create the database using the GUI similarly to part A, OR get a 10% bonus by creating the two table using queries in Access (See the file "Access Screenshots.pdf" on Canvas for this); And adding the relationship using the GUI as shown in point 13-18 above. BirthYear Student Name SID Has 1 Name Supervisor SupID

Step by Step Solution

There are 3 Steps involved in it

Step: 1

CREATE DATABASE Evan Rubin Part B USE Evan Rubin partB CREATE TABLE Student SID INT NOT N... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

identify the factors influencing foreign market entry strategies

Answered: 1 week ago

Question

What is a fat client? What is a thin client?

Answered: 1 week ago