Create a table called Customers with following attributes. U…
Create a table called Customers with following attributes. Use appropriate date type and constraints/property id : will be of number type, the value will be implicitly assigned by the system. The first id will be 1000 and each time you insert a new record, database engine will automatically increment the value of id by 5 firstName: will hold text data, can not be null lastName: will hold text data, can not be null email: will hold text data phone: will hold both numbers and/or text data, format will be xxx-xxx-xxxx, or xxxxxxxxxx (Hint: use SQL_VARIENT data type), can not be null dateOfBirth: will hold date SSN: will hold ssn nos, format will be xxx-xx-xxxx creditCardNo: will be of number type
Read Details