Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

Creating Tables and Entering Data Using SQL

The purpose of this assignment is to give you practice with creating database structure using SQL and using the INSERT command to add data.

Read the University Archaeology Museum case. Then use the appropriate command-line client software with Postgres or mySQL to create the database structures necessary for the tables in this document. (They represent only a portion of the tables necessary for the complete museum database.)

Name your database museum. Please also adhere to column names and data types as specified in this document.

Once you have created the tables, load them with the data provided.

Hand in output that lists your tables, their columns, and the test data. How you get the first two depends on the DBMS you are using:

• PostgreSQL: Issue the following two commands. Paste the output into a Word or plain text document to submit.

i) SELECT table_name FROM information_schema.tables WHERE table_schema = ‘public’;

ii) SELECT column_name FROM information_schema.columns WHERE table_name = ‘table_name’;

• MySQL: Issue the following two commands. Paste the output into a Word or plain text document to submit.

i) SHOW TABLES

ii) DESCRIBE table_name

Then issue SELECT * FROM table_name for each table in the database. Paste the output into the Word or plain text document.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M91577

Have any Question? 


Related Questions in DBMS

Part 1identify and explain the default logins or user

Part 1 Identify and explain the default logins or user accounts for one of the database vendors discussed in the chapter. Part 2. Case Project 6-1: Database Password Policies, page 199 Create and document a written passw ...

Application creating and populating a databasesuppose you

Application: Creating and Populating a Database Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. ...

In general my report talks about the database management

In general, my report talks about the Database management system. But I want to a specific topics of it in 3 pages. The topics are: 1. Comparison between File approach and Database approach. 2. Advantages and disadvantag ...

Overviewfor this assignment you will implement and query a

Overview For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create the database structures, to fill the database with da ...

Database systemretail store database Database system Retail Store Database: Relationships

Database system Retail Store Database: Relationships • Conduct an in-depth examination and analysis of the database, Week2_RetailStore.accdb . Apply the concepts of database systems that you have learned this week. For e ...

Your assignment should be submitted in a single word doc

Your assignment should be submitted in a single Word doc (.doc or .docx). It should include your scenario diagram for Problem 1, and your Ruby source code for Problems 2 and 3. Contact me or post to our discussion board ...

Home libraryisbntitleauthor Home Library I SBN Title Author LastName Author_FlrstName

Home Library I SBN Title Author LastName Author_FlrstName Publisher Date Edition Media 369852 Cosmos Sagan Carl Random House 1980   Book 741258 No Secrets Simon Carly Elektra 1972   CD 654789 Symphony No 3 Dur Eroica Op ...

When 100 ml of m10 h2so4 is mixed with 500 ml of my10 naoh

When 100 ml of M/10 H2SO4 is mixed with 500 ml of My/10 NaOH then nature of resulting solution and normality of excess reactant left is

Application creating and populating a databasesuppose you

Application: Creating and Populating a Database Suppose you have a small retail store and decide to create a database to track sales. You have information about recent sales that you want to use for testing the database. ...

The following assignment is based on the database

The following assignment is based on the database environment designed in the Week Three Individual Assignment. Your database project must meet the following requirements: • Create a database using professional principle ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate