资源描述:
《数据库实验报告(SQL语句)》由会员上传分享,免费在线阅读,更多相关内容在教育资源-天天文库。
1、数据库实验姓名:学号:班级:老师:1.实验第一部分(1)创建数据库并建立6张表CreateTablebook_category(category_idvarchar(5)Primarykey,categoryvarchar(10));CreateTablemember_level(levelvarchar(6)Primarykey,dayssmallint,numberssmallint,feesmallint);CreateTableloss_reporting(reader_idvarchar(5)Primarykey,loss_dat
2、edatetime);CreateTableborrow(reader_idvarchar(5),book_idvarchar(5),date_borrowdatetime,date_returndatetime,losschar(2),Primarykey(reader_id,book_id));CreateTablebooks(book_idvarchar(5)Primarykey,book_namevarchar(5),authorvarchar(20),publishingvarchar(20),category_idvarchar
3、(5),pricemoney,date_indatetime,quantity_inint,quantity_outint,quantity_losssmallint,Foreignkey(category_id)Referencesbook_category(category_id))CreateTablereader(reader_idvarchar(5)Primarykey,reader_namevarchar(20),sexchar(2),birthdaydatetime,phoneint,Mobilevarchar(11),car
4、d_namevarchar(8),card_idvarchar(18),levelvarchar(6),daydatetime,Foreignkey(level)Referencesmember_level(level))(1)向这6张表输入数据Reader表(外键先留空):INSERTINTOreader(reader_id,reader_name,sex,birthday,phone,Mobile,card_name,card_id,day)VALUES('r001','李铭','男','19880307','62127790','13
5、671100110','身份证','230106198803070178','20100801');INSERTINTOreader(reader_id,reader_name,sex,birthday,phone,Mobile,card_name,card_id,day)VALUES('r002','刘晓鸣','男','19900809','84778123','13671007896','身份证','210103199008094326','20100801');INSERTINTOreader(reader_id,reader_nam
6、e,sex,birthday,phone,Mobile,card_name,card_id,day)VALUES('r003','李明','男','20010221','84900581','13901020111','身份证','230106200102216634','20100801');INSERTINTOreader(reader_id,reader_name,sex,birthday,phone,Mobile,card_name,card_id,day)VALUES('r004','张鹰','女','19701112','516
7、81212','13812669002','身份证','230106197011120145','20100620');INSERTINTOreader(reader_id,reader_name,sex,birthday,phone,Mobile,card_name,card_id,day)VALUES('r005','刘竟静','女','19991007','51681213','13756705671','身份证','230106199910070766','20090405');INSERTINTOreader(reader_id,
8、reader_name,sex,birthday,phone,Mobile,card_name,card_id,day)VALUES('r006','刘成刚','男','1990