Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Tasks: Considering the following E-R diagram, you need to translate it into a relational database and add some data to the tables. a) Write SQL

image text in transcribed
image text in transcribed
Tasks: Considering the following E-R diagram, you need to translate it into a relational database and add some data to the tables. a) Write SQL statements to create the corresponding relations and capture as many of the participation and cardinality constraints as possible. Make sure that the data type and size for each attribute are appropriate. b) If some constraints in the diagram cannot be captured, explain why. c) Write SOL statements to insert at least two tuples for each table Make sure your SQL script file can be run successfully in MySQL before submitting it. If it can't be run, your grade for this assignment will be a ZERO. If your file can be run without error messages, the maximum possible points for each portion are listed below: - Create Tables 70 points - Constraints 10 points - Insert Tuples 20 points 5 is an individual assignment - no group submissions are allowed. Submit a script file tains the CREATE TABLE statements, comments on uncaptured constraints, and INSE O statements. The outline of the script file lists as follows: * Name: YourNameGoesHere * Date: "I have neceived or given help on this assignment: YourName DROP DATABASE IF EXISTS Lab3YourLastName; CREATE DATABASE Lab3YourLastName; USE Lab3YourLastName; / Task Task 1: create tables Tasknk/ CREATE TABLE Task 2: uncaptured constraints put your response here Task 3: Add records Taskik; INSERT INTO

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Microsoft SQL Server 2012 Unleashed

Authors: Ray Rankins, Paul Bertucci

1st Edition

0133408507, 9780133408508

More Books

Students also viewed these Databases questions

Question

Comment on the various types of performance standards.

Answered: 1 week ago

Question

Discuss the states of accounting

Answered: 1 week ago