Question: Create a new table called Birthday with the following columns: BusinessEntitylD column as an integer, and a DoB (Date of Birth) column in as date.

Create a new table called Birthday with the following columns: BusinessEntitylD column as an integer, and a DoB (Date of Birth) column in as date.\ Add a constraint to make BusinessEntitylD a primary key.\ Insert one record for BusinessEntitylD 1 and include 1990/01/01 as the birthday.\ Once added, query your new table showing the new record.\ Submit the Word document (with screenshots).

1. Create a new table called Birthday with the following columns: BusinessEntitylD column as an integer, and a DoB (Date of Birth) column in as date. 2. Add a constraint to make BusinessEntitylD a primary key. 3. Insert one record for BusinessEntitylD 1 and include 1990/01/01 as the birthday. 4. Once added, query your new table showing the new record. Submit the Word document (with screenshots). 1. Create a new table called Birthday with the following columns: BusinessEntitylD column as an integer, and a DoB (Date of Birth) column in as date. 2. Add a constraint to make BusinessEntitylD a primary key. 3. Insert one record for BusinessEntitylD 1 and include 1990/01/01 as the birthday. 4. Once added, query your new table showing the new record. Submit the Word document (with screenshots)

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!

The human resources department has requested that you create a table that can be used to store birthdays in the database. This table will be used to support a newsletter that is distributed...

Create a table called 'client' with the following columns... Please use MySQL and assume MariaDB Please provide comments and explanation 1. Create tables in the given order -- 32 points Create a...

Create a table called client with the following columns. THIs is done is MySQL & MariaDB format - id - an auto-incrementing integer which is the primary key, size 11 - first_name - a varchar with a...

SQL scripts for each question I NEED HELP FOR QUESTIONS (9,10,11,12) Create Database schema called ClassAssignment Use ClassAssignment database for rest of the exercise. Create a table called Project...

SQL scripts for each question I NEED HELP FOR QUESTIONS NUMBERS (5, 6, 7 , 8) Starting from "Insert following values into the Project table." the answers should be written in sql scripts Create...

SQL scripts for each question Create Database schema called ClassAssignment Use ClassAssignment database for rest of the exercise. Create a table called Project with the following columns:...

SQL scripts for each question I NEED HELP FOR QUESTIONS (13,14,15,16) Create Database schema called ClassAssignment Use ClassAssignment database for rest of the exercise. Create a table called...

(I need help with hands-on practice in working with DDL, DML, and Constraints using the MySQL workbench tool. In this practice assignment, points will be given to correct answers and clean and clear...

Using MySQL syntax create and run the following SQL scripts for the problems listed below within ... Using MySQL syntax create and run the following SQL scripts for the problems listed below within...

Using MySQL syntax create and run the following SQL scripts for the problems listed below within the sales_co schema. A script needed to create the sales_co schema can be found on D2L named...

What is a mutually exclusive project? How should managers rank mutually exclusive projects?

Compare tax rates in the USA versus other countries. What impact could these differences have on keeping jobs at home?

Alex complained that the conference was a (waste/waist) of time

Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Date Activities Units Acquired at Cost March 1 Beginning inventory...

5. There has been some discussion among the employees in your companys insurance claims processing unit about forming a union. Company management has asked you to research existing labor agreements...

5. Management is developing a company workplace monitoring program to track compliance with safety procedures at an offshore oil rig platform in the Gulf of Mexico. The monitoring program is expected...

5. Get feedback from employees on the initial design. Use focus groups, town hall meetings, suggestion systems, or email polls. Share all the details so that employees can effectively evaluate the...