Question: create database DDLPractice use DDLPractice create table authors au id char (11) not null primary key, au_lname varchar (40) not null, au_fname varchar(20) not null,

create database DDLPractice use DDLPractice create table authors au id char

create database DDLPractice use DDLPractice create table authors au id char (11) not null primary key, au_lname varchar (40) not null, au_fname varchar(20) not null, phone char(12) null, address varchar (40) null, city varchar(20) null, au_state char(2) null, zip char(5) null create table publishers pub_id char (4) not null primary key, pub_name varchar (40) null, address varchar (40) null, city varchar(20) null, pub_state char (2) null create table titles title_id char(6) not null primary key, title varchar (80) not null, title_type char (12) nul1, pub_id char (4) null references publishers (pub_id) price money null, pubdate smalldatetime null

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!

SQL Exercise Using the given query below and write queries (with subqueries) to answer the following questions. 1. Which publishers haven't published a cook book? 2. Which publisher has the highest...

How do you create indexes for these queries? What are the correct statements that will help the queries index correctly. We already created queries but we need help with indexing thanks! CREATE...

SQL Help This question uses the code in Schedule.sql. The query below is intended to calculate how much each enrolled student will owe for each Winter 2003 course he's taking, assuming that each...

CREATE DATABASE [Cooking Simulator] GO USE [Cooking Simulator] GO CREATE TABLE [Chef] ( [ChefId] CHAR(6) PRIMARY KEY CHECK ([ChefId] LIKE 'CHF[0-9][0-9][0-9]'), [ChefName] VARCHAR (20) NOT NULL,...

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many employees do not have children? 5. Which...

Use the ' Premiere Products Company ' SQL script file found in the D2L content folder called 'SQL Scripts'. Paste the contents of this script into a query tab of MySQL Workbench and execute it. This...

MySQL Database Simple Schema I need help on creating a database through mysql and the basic schema that needs to be written in notepad. I have something like this so far but I am not sure how to do...

7. Write a SQL statement to create a table employees including columns employee id, first name, last name, email, phone number hire date, job_id, salary, commission, manager id and department_id and...

Write a GUI javafx or swing application in Java that allows user to select Employees by their city. Employee Info Select Employee by City 300111222 SARA Elsa 300233444 300111777 Laura 300223444 Elsa...

SQL Help Use the file to create the initial database and tables. Require Using Create 1. Create a table that implements the many-to-many relationship between titles and authors. Include a field to...

2. A yellow wrinkled (MMBB) and white smooth (mmbb) corn kernel was crossed (MmBb). What is the probability of getting the following phenotypic traits: a. Yellow wrinkled b. Yellow smooth c. White...

The inventory costing method that can be used only for goods that are not ordinarily interchangeable is the Weighted average cost method Fifo method Lifo method Specific identification method

what programs can I use to help pay for my child to attend a private school from elementary to 12th grade

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

4. To what extent do you think measures of a countrys wellbeing should be included when comparing the performance of countries? Should there be something like the balanced scorecard, discussed in...

2. In your opinion do you think that measures of social performance should be considered when deciding managers pay? If so what measures should be used?

2. Obtain a copy of the safety policy for either your college or your workplace. a. Use this to identify the roles of various people in the organisation in relation to health and safety. b. Use the...