Forums
This topic is locked
relate tables.
Posted 08 Nov 2007 08:14:23
1
has voted
08 Nov 2007 08:14:23 skeet young posted:
can anyone relate these table to each other?EMPNO NOT NULL NUMBER(4)
ENAME VARCHAR2(10)
JOB VARCHAR2(9)
HIREDATE DATE
SAL NUMBER(7,2)
DEPTNO NUMBER(2));
Table child;
Create table child (
F_name varchar(20),
L_name varchar(20),
Age number,
Date of Birth varchar(20),
Id number,
Address varchar (25),
Gender varchar (10),
Race varchar(20));
Parent table;
Create table parent(
F_name varchar(20),
L_name varchar(20),
Date of Birth varchar(20),
Address varchar (25),
Id number
Phone number);
Building table;
Create table building(
Name varchar (30),
Address varchar (20),
Room number);