数据库

create table Family
(
    Code varchar(50) primary key ,
    Name varchar(50) not null,
    Sex bit
)

 

create table  Nation
(

       Code varchar(50) primary key,
       Name varchar(50)       

);


create table  Info
(

       Code int auto_increment primary key,

       name varchar(50),

       sex bit,

       birthday date,

       height float,

       nation varchar(50) references nation(code)
)