代码:/* 创建数据库 */
create database SuperMarketdb
on primary (
name=SuperMarketdb,
filename='C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\Data\SuperMarketdb.mdf',
size=100MB,
maxsize=200MB,
filegrowth=20MB
)
log on
(
name=SuperMarketlog,
filename='C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\Data\SuperMarketdb.ldf',
size=60MB,
maxsize=200MB,
filegrowth=20MB
)
go
/* 创建基本表 */
use SuperMarketdb
go
/*创建供货表*/--drop table factory
CREATE TABLE Factory (
FactoryID INT Primary key ,
FactoryName varchar(50) NOT NULL ,
FactoryAddress varchar(250) NULL ,
FactoryPhone varchar(50) NULL)
insert Factory values('2','扶苏','上海','3')
GO
/*创建会员表*/
CREATE TABLE Member (
MemberID varchar(10) Primary key ,
MemberCard varchar (20) NOT NULL ,
TotalCost money NOT NULL ,
RegDate datetime NOT NULL)
insert Member values('桑梦媛','001','100','2021.12.30')
GO
CREATE TABLE DEALING (
DEALINGID varchar(10) Primary key ,
DealingPrice money NOT NULL,
DEALINGDate datetime NOT NULL)
insert DEALING values('01','55','2021.12.12')
GO
/*创建商品信息表*/
--d