abc /*dummy type for co-dependant objects*/ create type dep_t_k / /*employee object*/ create type emp_t_k as object( EMPNO char(6), FIRSTNAME varchar(12), LASTNAME varchar(15), WORKDEPT ref dep_t_k, SEX char(1), BIRTHDATE date, SALARY number(8,2) ) / /*department object - replace dummy type (same name difference as object)*/ create type dep_t_k as object( DEPTNO char(3), DEPTNAME varchar(36), MGRNO ref emp_t_k, ADMRDEPT ref dep_t_k ) / /*employee table*/ create table OREMP_k of emp_t_k( constraint OREMP_k_pk primary key(EMPNO), constraint OREMP_k_nn1 FIRSTNAME not null, constraint OREMP_k_nn2 LASTNAME not null, constraint OREMP_k_chk1 check(Sex in('M','m','F','f')) ) / /*department table*/ create table ORDEPT_k of dep_t_k( constraint ORDEPT_k_pk primary key(DEPTNO), constraint ORDEPT_k_nn1 DEPTNAME not null ) / /*add references to employee table*/ alter table OREMP_k add constraint OREMP_k_fk1 foreign key(WORKDEPT) references
Posts
Keeping Your Child Safe on the Internet
- Get link
- Other Apps
Keeping Your Child Safe on the Internet The Internet can be wonderful for kids. They can use it to research school reports, communicate with teachers and other kids, and play interactive games. But online access also comes with risks, like inappropriate content, cyberbullying , and online predators. Using apps and websites where kids interact, predators may pose as a child or teen looking to make a new friend. They might prod the child to exchange personal information, such as address and phone number, or encourage kids to call them, seeing their phone number via caller ID. Parents shold be aware of what their kids see and hear on the Internet, who they meet, and what they share about themselves. Talk with your kids, use tools to protect them, and keep an eye on their activities.