mysql-表、ER图、索引与视图的基础操作

1、创建数据库以及表
创建数据库和使用数据库：
dropdatabase if exists dingbao;
createdatabase dingbao;
         use dingbao;
创建数据表和插入数据：关键在于给报纸订阅表中设置cno和pno为外键。
droptable if exists paper;
droptable if exists cp;
droptable if exists customer;
 
createtable paper(
         pno varchar(10) not null,
    pna varchar(10) not null,
    ppr float not null,
    primary key(pno)
    )engine = InnoDB;
 
insertinto paper values("000001", "人民日报", 12.5),
                                                        ("000002","解放军报", 14.5),
                        ("000003","光明日报", 10.5),
                        ("000004","青年报", 11.5),
                        ("000005","扬子日报", 18.5);
 
 create table customer(
         cno varchar(10) not null,
    cna varchar(10) not null,
    adr varchar(20) not null,
    primary key(cno)
    )engine = InnoDB;
 
insertinto customer values("0001", "李涛", "无锡市解放东路123号"),
                                                           ("0002", "钱金浩","无锡市人民西路234号"),
                           (&