Create a table Money_xxxx with the following fields and constraints. mid: int primary key auto_increment, code...

Transcribed Image Text:

Create a table Money_xxxx with the following fields and constraints. mid: int primary key auto_increment, code varchar(50) unique, cid: int, type: one char, amount: float, mydatetime: datetime, note: varchar(255) All fields cannot have NULL values, except note. mid is the primary key, and the value should be auto increment by the DBMS. cid is a foreign key references to the id field in CPS3740.Customers table. code should be unique. sid is a foreign key references to the id field in CPS3740.Sources table Create a table Money_xxxx with the following fields and constraints. mid: int primary key auto_increment, code varchar(50) unique, cid: int, type: one char, amount: float, mydatetime: datetime, note: varchar(255) All fields cannot have NULL values, except note. mid is the primary key, and the value should be auto increment by the DBMS. cid is a foreign key references to the id field in CPS3740.Customers table. code should be unique. sid is a foreign key references to the id field in CPS3740.Sources table

Answer rating: 100% (QA)

To create a table named Moneyxxxx with the specified fields and constraints you can use SQL statemen... View the full answer