Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
4.3k views
in Computer by (69.4k points)
edited by

Create a table with the under mentioned structures

Table : EMP Table : PROJECT Table : DEPT
EmpNo NUMBER(4) ProjId NUMBER(4)
DeptNo NUMBER(2 ProjDesig CHAR(20
EmpName CHAR(10) ProjStartDT DATE
Job CHAR(10)  ProjEndDT DATE
Manager NUMBER(4) BudgetAmount NUMBER(7)
Hiredate DATE MaxNoStaff NUMBER(2)
Salary NUMBER(7,2)
Commission NUMBER(7,2

1 Answer

+1 vote
by (61.3k points)
selected by
 
Best answer

CREATE TABLE EMP(EmpNo INTEGER(4), DeptNo INTEGER(2), EmpName CHAR(10), Job CHAR(10), Manager INTEGER(4), HireDate DATE, Salary DECIMAL(7,2), Commission DECIMAL(7,2));

CREATE TABLE PROJECT(ProjId INTEGER(4), ProjDesign CHAR(20), ProjStartDT DATE, ProjEndDT DATE, BudgetAmount INTEGER(7), MaxNoStaff INTEGER(2)); 

CREATE TABLE DEPT(DeptNo INTEGER(2), DeptName CHAR(12), Location CHAR(12));

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

Categories

...