go to
Create? Table? cook
(Department number? char(3)? Isn't it? null? Elementary? Keys? Check(len =3? And then what? Substring (coefficient number, 1, 1)='x'? And then what? Substring (coefficient number, 2,2) like' [0-9][0-9]'),
What's the name of this dish? char(4)? Isn't it? Empty,
What are the characteristics of the cuisine? Charles? Isn't it? Empty,
)
Create? Table? Representative dish
(dish number? char(3)? Isn't it? null? Elementary? Keys? Check(len =3? And then what? Substring (dish number, 1, 1)='c'? And then what? Substring (dish number, 2, 2) like' [0-9][0-9]'),
Department number? char(3)? Foreign? Key (department number)? Reference materials? Is the cuisine (department number) not? Empty,
Name of the dish? Charles? Isn't it? Empty,
Recipes? Charles? Isn't it? Empty,
Features? Charles? Isn't it? Empty)
Create? Table? Representative restaurant
(store number? char(3)? Isn't it? null? Elementary? Keys? Check(len) =3? And then what? Substring (storage number, 1, 1)='d'? And then what? Substring (store number, 2,2) such as "[0-9][0-9]"),
The dish number? char(3)? Foreign? Key (dish number)? Reference materials? Representative dish (dish number)? Isn't it? Empty,
Store name? Charles? Isn't it? Empty,
Address? Charles? Isn't it? Empty,
Average consumption? Charles? Isn't it? Empty,
Reservation phone number? char(8)? Check (substring (reservation phone, 1, 8)? Such as "[0-9] [0-9] [0-9] [0-9] [0-9] [0-9] [0-9]"? Isn't it? Empty)
You create a new cai database (or you can name it yourself), then create a new query, copy the above, execute each table one by one, and then refresh the database.