Question: Create an database. 2. Create an table in that database. The table will have five columns: 2a. Two columns will have two different numeric datatypes.

 Create an database.

2. Create an table in that database. The table will have five columns:

2a. Two columns will have two different numeric datatypes.

2b. Two columns will have two different character datatypes

2c. One column will contain date or time data.

3. Populate that table with six rows of data.

Show the following:

1. The command you used to create the database.

2. The command you used to create the table.

3. The command you used to populate the table.

4. A screen clip of running "SELECT * FROM ;"

I want to see all six rows of data in your table.

You may name the table and columns anything you wish.

You may make the columns any datatype you wish as long as

two are numeric, two are string, and one is date/time.

When populating the table, please do not enter personal information

about you or anyone else.

Using Postgres

Step by Step Solution

3.34 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Certainly here are the steps to create a database create a table populate it with data and perform a ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!