Question: write a procedure to create the tables in your database, tables as in the image. U means unique content when creating the tables, check if

write a procedure to create the tables in your database, tables

write a procedure to create the tables in your database, tables as in the image. U means unique content when creating the tables, check if such tables exist, if so, delete it and create a new one.

Person id_person Integer (10) BirthDate date Data ID_Data_Person integer (10) Id person Integer (10) id_name into ger(10) Data type Integer (10) Name Id_name into ger(10) name varchar(40) U Data type Datat a type integer(10) name varchar(20) U

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!

This is my database Homework 2. Write a procedure to create the tables in your database, tables as in the image. U means unique content when creating tables, check if such table exists, if so, delete...

1- write a procedure to create the tables in your database, tables as in the image. U means unique content when creating the tables, check if such tables exist, if so, delete it and create a new one....

Lab 2 Relational Database defining tables, viewing the structure of the defined tables, and adding records into tables. The outline of the script file lists as follows: Task 1 : Write a SQL statement...

Tasks: Write a SQL statement to select the database with your last name to store the data. If it does not exist in your MySQL server, use "CREATE DATABASE" command to create one. WRITE SQL statements...

Write a script, one step at a time, to generate the DB schema of the movie rental database. Test the partial results by inspecting the tables in SQLDeveloper. Do not proceed to the next step until...

* * * * Please write an sql script with the table provide * * * Objectives: Write SQL statements to define a database, to define tables, to view the table structures, to upload data into the tables...

Part 2 - Prototype ( Marks: 1 0 0 ) For this Part, you will need to build a fully working web application prototype. This prototype will include all the features listed in the instructions section of...

Consider the following database schema for student organizations. Students ( ID , fName, lName, phone, dateOFBirth ) Clubs ( ID , title, establishedDate ) Note that table Clubs has two candidate...

1. (10 points) Write SQL code to create the tables that implements the following design in a database named Library : - Include the drop statements and GO at appropriate places - ISBN is a Primary...

Data follow for the Construction Division of D. Jack Inc.: Required: 1. Compute the margin and turnover ratios for each year. 2. Compute the ROI for the Construction Division for each year. Year 1...

a- Ms Miriam is working as an interior designer with Well Decoration Sdn Bhd. For the whole year of 2017, she receives the following income: Salary(gross) RM11,200 per month Bonus RM 9,000 A fully...

A 2 6 0 0 0 7 % bond redeemable at par with interest payable annually id bought 1 2 . 5 yrars before maturity determine the premium ot discount price of the bond 9 % compounded annually 5 %...

Prepare an income statement for Mostyn Company for the yesr ended 30 June 2019, given the following account balances. (a) Prepare an income statement for Mostyn Company for the year ended 30 June...

4. What are the facts that need to be considered? What assumptions are you making?

2. Who are the stakeholders, and how would they define the problem? What are the values of greatest importance to these stakeholders?

1. What is the values dilemma presented in this short case study? What values seem at issue as you define the problem?