Create a SQL table using your name with the following features: the columns of your table must include, at least the data types (in this order) and one more of your choice NOTE: You need to specify a 2 column (i.e 2 attribute 1. varchar (n), // where n covers the string length you want to enter 2. Int, 3. decimal, (precision = 8, scale = 3 4. date. 5. ??? your choice here ??? Table constraints: 1. It has a two column primary key 2. a check constraint on 2 columns, on the decimal and the date field 3. Use '2024-02-18' date as the default on the date field 5. write down your relational schema 5. Create the table, insert at least 4 rows, and do a Select * to show them example don't just copy these, change the constraint names
Create a SQL table using your name with the following features: the columns of your table must include, at least the data types (in this order) and one more of your choice NOTE: You need to specify a 2 column (i.e 2 attribute 1. varchar (n), // where n covers the string length you want to enter 2. Int, 3. decimal, (precision = 8, scale = 3 4. date. 5. ??? your choice here ??? Table constraints: 1. It has a two column primary key 2. a check constraint on 2 columns, on the decimal and the date field 3. Use '2024-02-18' date as the default on the date field 5. write down your relational schema 5. Create the table, insert at least 4 rows, and do a Select * to show them example don't just copy these, change the constraint names
Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter20: Activity-based Costing (abc)
Section: Chapter Questions
Problem 5R
Related questions
Question
![Create a SQL table using your name with the following features:
the columns of your table must include, at least the data types (in this order) and one more of your choice
NOTE: You need to specify a 2 column (i.e 2 attribute
1. varchar (n), // where n covers the string length you want to enter
2. Int,
3. decimal, (precision = 8, scale = 3
4. date.
5. ??? your choice here ???
Table constraints:
1. It has a two column primary key
2. a check constraint on 2 columns, on the decimal and the date field
3. Use '2024-02-18' date as the default on the date field
5. write down your relational schema
5. Create the table, insert at least 4 rows, and do a Select * to show them
example don't just copy these, change the constraint names](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F242b0708-be53-4a48-9ba1-e32737d381db%2Fcf121846-4d71-46d9-8d48-a3a98b9d4066%2Flw83rhk_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Create a SQL table using your name with the following features:
the columns of your table must include, at least the data types (in this order) and one more of your choice
NOTE: You need to specify a 2 column (i.e 2 attribute
1. varchar (n), // where n covers the string length you want to enter
2. Int,
3. decimal, (precision = 8, scale = 3
4. date.
5. ??? your choice here ???
Table constraints:
1. It has a two column primary key
2. a check constraint on 2 columns, on the decimal and the date field
3. Use '2024-02-18' date as the default on the date field
5. write down your relational schema
5. Create the table, insert at least 4 rows, and do a Select * to show them
example don't just copy these, change the constraint names
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
![Pkg Acc Infor Systems MS VISIO CD](https://www.bartleby.com/isbn_cover_images/9781133935940/9781133935940_smallCoverImage.gif)
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L