In: Computer Science
Answer:
Query:
Create table Product(
ProductNo number,
CompanyName varchar2(25),
ModelNo varchar2(10),
ProductName varchar2(25),
Primary Key(ProductNo));
Output:
Table has been created.
Result:
Product table will be created with columns ProductNo, CompanyName,
ModelNo, and ProductName
Explanation:
ProductNo is a number so the data type is
number.
CompanyName is a string so the data type is
varchar2
ModelNo is the combination of numbers and letters so it's data type
is varchar2
ProductName is a string so the data type is
varchar2.
ProductNo holds unique values so it is the Primary
key.
Thanks and All the best. Let me know in case if you have any doubts.