FirstName EID Name LastName Employee Birthdate TEL n Age work date ID m Name Project Rate In the physical design phase, which SQL statement is the most correct one to create the Employee table in the above E-R diagram for the MySQL database? O create table Employee (EID varchar(10) primary key, FirstName varchar(50), LastName varchar(50), Age int, Birthday date, TEL varchar(20)); O create table Employee (EID varchar(10) primary key, FirstName varchar(50), LastName varchar(50), Birthday date); O create table Employee (EID varchar(10) primary key, Name varchar(50), TEL varchar(20)); O create table Employee (EID varchar(10) primary key, Name varchar(50), Age int, Birthday date);

FirstName EID Name LastName Employee Birthdate TEL n Age work date ID m Name Project Rate In the physical design phase, which SQL statement is the most correct one to create the Employee table in the above E-R diagram for the MySQL database? O create table Employee (EID varchar(10) primary key, FirstName varchar(50), LastName varchar(50), Age int, Birthday date, TEL varchar(20)); O create table Employee (EID varchar(10) primary key, FirstName varchar(50), LastName varchar(50), Birthday date); O create table Employee (EID varchar(10) primary key, Name varchar(50), TEL varchar(20)); O create table Employee (EID varchar(10) primary key, Name varchar(50), Age int, Birthday date);

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter9: Joining Data From Multiple Tables

Section: Chapter Questions

Problem 10HOA: An EMPLOYEES table was added to the JustLee Books database to track employee information. Display a...

See similar textbooks