Problem 1 here: https://www.chegg.com/homework-help/questions-and-answers/databa

Question

Problem 1 here: https://www.chegg.com/homework-help/questions-and-answers/database-systems-sql-problem-1-matrix-manipulations-optimal-use-sql-matrix-operations-impl-q23843783

Database Systems, SQL

Problem 2: The Pets Database

There is another way to import data into mysql. When you start mysql, you should use the –-enable-local-infile option:

sudo mysql –-enable-local-infile –u root

This allows you to import individual tables into a database. Create a new database called pets.

a)Create two tables:

Pet(name:VARCHAR(20),owner:VARCHAR(20),

species:VARCHAR(20),sex:CHAR(1),birth:DATE,death:DATE)

and

Event(name:VARCHAR(20),date:DATE,type:VARCHAR(15),

remark:VARCHAR(255))

b)Load data into these tables using the two file provided , Pet Table Data and Pet Events Table Data. You can use the following command syntax example for Pet Table Data:

mysql> LOAD DATA LOCAL INFILE “Pet Table Data.txt” INTO TABLE pet FIELDS TERMINATED BY ‘,’;

c)Write a SQL query against this database. We’d like to see all the male cats and all the female dogs.

d)Write a SQL query that provides the age of each pet that has had a litter.

Pet Table Data

Pet Events Table Data

Explanation / Answer

Hi,
To print all male dogs and female cats
select * from Pet where species='dog' and sex='f' union
select * from pet where species='cat' and sex='m' ;
using union to join to condiitons
2.age of each pet that had a litter
select age from Pet a, Event b where b.name='litter' and b.name=a.name;
using joing to get all those pet names who had litter
Thumbs up if this was helpful, otherwise let me know in comments

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.