Question: SQL EXERCISE HELP ! Write the code to create a database with the following tables: Songs : each song has a title, duration, and genre.

SQL EXERCISE HELP !

Write the code to create a database with the following tables:

Songs: each song has a title, duration, and genre. Title and duration are required; genre is not. Publish date has to be before today, and after the first day of the current year. Genre must be at least 3 characters.

Albums: each album has a title, artist, release date, price, format, and genre. All fields except genre are required. Price can't be negative. Format must be record, cd, or eight track. Release date can be any date after 1/1/1931 if the format is record; any date after 1/1/1968 if the format is eight track; and any date after 1/1/1979 if it's a cd.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock 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!

1. (20 points) Writing data to an SQLite database Locate the dataset named IMDbmovies.csv on Canvas. Use Python code to create a database named cse2050_movies_db.db. Next, create a table named...

Describe the purpose of hash functions, message authentication codes and digital signatures, sketching a possible construction for each of them. [12 marks] A funds transfer system authenticates...

1 . Librarian - Attributes: - librarianId ( Primary Key ) : Unique identifier for each librarian. - name: Full name of the librarian. - contactNumber: Contact phone number. - email: Email address for...

Assignment 4 is to use SQL queries to obtain appropriate data from databases for betting decision making. In this assignment, you will be asked to write SQL queries to get relevant information from...

Assignment 4 Data Extraction Assignment 4 is to use SQL queries to obtain appropriate data from databases for betting decision making. In this assignment, you will be asked to write SQL queries to...

In this assignment, you will be asked to write SQL queries to get relevant information from the database you built from Assignment 3 and therefore to answer some questions pertaining to the S record...

I need to find out what are the queries are supposed to look like. Everywhere is showing very different things and I'm not sure how to do this properly. Pls help. Instructions: In this assignment you...

A student wanted to use the Williamson ether synthesis to make (R)-2-ethoxybutane. He remembered that the Williamson synthesis involves an SN2 displacement, which takes place with inversion of...

If the returns on two stocks are highly correlated, what does this mean? If they have no correlation? If they are negatively correlated?

When Treetop Housing was first incorporated, it raised capital by issuing 1 0 0 , 0 0 0 shares at $ 1 0 per share. Over the course of its first five years of business, Treetop had retained earnings...

CT Corp Comprehensive Question Canadian Tire Corporation, Limited (Canadian Tire) is a family of companies that includes a retail segment and a financial services division, among others. The retail...

(Appendices) UNCOLLECTIBLE ACCOUNT EXPENSE: AGING METHOD. Glencoe Supply had the following accounts receivable aging schedule at the end of a recent year: LO6

(Appendices) ALLOWANCE FOR UNCOLLECTIBLE ACCOUNTS. At the beginning of the year, Kullerud Manufacturing had a credit balance in its allowance for uncollectible accounts of $6,307. During the year...

(Appendices) SALES AND PURCHASE DISCOUNTS: GROSS AND NET METHODS. Sims Company regularly sells merchandise to Lauber Supply on terms 3/15, n/20. During a recent month, the two firms engaged in the...