北工大数据库实验报告(3)

singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(03,'周杰伦','36岁','男','中国台湾省','1979年1月18日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(04,'陈信宏','40岁','男','福建省泉州市','1975年12月6日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(05,'石锦航','40岁','男','浙江宁波','1975年12月11日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(06,'温尚翊','39岁','男','台湾省新竹市','1976年11月28日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(07,'蔡升晏','38岁','男','台湾省高雄市','1977年4月25日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(08,'刘谚明','42岁','男','台湾省苗栗市','1973年7月28日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(09,'王俊凯','16岁','男','中国重庆市','1999年9月21日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(10,'王源','15岁','男','中国重庆市','2000年11月8日'); commit work; insert into singers_2417810(singers_num,singers_nam,singers_ages ,singers_sex,singers_np,singers_birthday) values(11,'易烊千玺','15岁','男','中国湖南省','2000年11月28日'); commit work;

4.组合/歌手信息表

Create table bands_2417810

(bands_num varchar(3),bands_nam varchar(20),bands_date varchar(15));

insert into bands_2417810(bands_num,bands_nam,bands_date) values(01,'邓丽君','1953年1月29日');

commit work;

insert into bands_2417810(bands_num,bands_nam,bands_date) values(02,'崔健','1961年8月2日');

commit work;

insert into bands_2417810(bands_num,bands_nam,bands_date) values(03,'周杰伦','1979年1月18日');

commit work;

insert into bands_2417810(bands_num,bands_nam,bands_date) values(04,'五月天','1997年3月29日');

commit work;

insert into bands_2417810(bands_num,bands_nam,bands_date) values(05,'TFBOYS','2013年8月3日');

commit work;

5.组成关系表

Create table form_2417810

(singers_num varchar(3),bands_num varchar(3));

insert into form_2417810(singers_num,bands_num) values(01,01); commit work;

insert into form_2417810(singers_num,bands_num) values(02,02); commit work;

insert into form_2417810(singers_num,bands_num) values(03,03); commit work;

insert into form_2417810(singers_num,bands_num) values(04,04); commit work;

insert into form_2417810(singers_num,bands_num) values(05,04); commit work;

insert into form_2417810(singers_num,bands_num) values(06,04); commit work;

insert into form_2417810(singers_num,bands_num) values(07,04); commit work;

insert into form_2417810(singers_num,bands_num) values(08,04); commit work;

insert into form_2417810(singers_num,bands_num) values(09,05); commit work;

insert into form_2417810(singers_num,bands_num) values(10,05); commit work;

insert into form_2417810(singers_num,bands_num) values(11,05); commit work;

Create table publish_2417810dr

(bands_num varchar(3),albums_num varchar(3));

insert into publish_2417810(bands_num,albums_num) values(01,01); commit work;

insert into publish_2417810(bands_num,albums_num) values(02,02); commit work;

insert into publish_2417810(bands_num,albums_num) values(03,03); commit work;

insert into publish_2417810(bands_num,albums_num) values(04,04); commit work;

insert into publish_2417810(bands_num,albums_num) values(05,05); commit work;

6.收录关系表

Create table record_2417810

(albums_num varchar(3),songs_num varchar(3));

insert into record_2417810(albums_num,songs_num) values(01,01); commit work;

insert into record_2417810(albums_num,songs_num) values(01,02); commit work;

insert into record_2417810(albums_num,songs_num) values(02,03); commit work;

insert into record_2417810(albums_num,songs_num) values(02,04); commit work;

insert into record_2417810(albums_num,songs_num) values(03,05); commit work;

insert into record_2417810(albums_num,songs_num) values(03,06); commit work;

insert into record_2417810(albums_num,songs_num) values(04,07); commit work;

insert into record_2417810(albums_num,songs_num) values(04,08); commit work;

insert into record_2417810(albums_num,songs_num) values(05,09); commit work;

insert into record_2417810(albums_num,songs_num) values(05,10); commit work;

7.演唱关系表

Create table sing_2417810

(songs_nam varchar(3),bands_num varchar(3));

insert into sing_2417810(songs_nam,bands_num) values(01,01); commit work;

insert into sing_2417810(songs_nam,bands_num) values(02,01);

commit work;

insert into sing_2417810(songs_nam,bands_num) values(03,02); commit work;

insert into sing_2417810(songs_nam,bands_num) values(04,02); commit work;

insert into sing_2417810(songs_nam,bands_num) values(05,03); commit work;

insert into sing_2417810(songs_nam,bands_num) values(06,03); commit work;

insert into sing_2417810(songs_nam,bands_num) values(07,04); commit work;

insert into sing_2417810(songs_nam,bands_num) values(08,04); commit work;

insert into sing_2417810(songs_nam,bands_num) values(09,05); commit work;

insert into sing_2417810(songs_nam,bands_num) values(10,05); commit work;

8.用户登录表

Create table User_2417810

(UserNum varchar(30) primary key not null,UserPass varchar(10)); insert into User_2417810 values( '7810','7810'); commit work;

create table money_2417810(album_num varchar2(2),price varchar2(5)); insert into money_2417810(album_num,price) values(01,50); commit work;

insert into money_2417810(album_num,price) values(02,40); commit work;

insert into money_2417810(album_num,price) values(03,50); commit work;

insert into money_2417810(album_num,price) values(04,60); commit work;

insert into money_2417810(album_num,price) values(05,30); commit work;

三、FormBuilder界面设计

1.用户登录界面