Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a Write SQL queries to create tables with keys and relations corresponding to each of the following question. Note that you should submit Q1.sql for

image text in transcribed

a Write SQL queries to create tables with keys and relations corresponding to each of the following question. Note that you should submit Q1.sql for Question 1, Q2.sql for Question 2 To submit select all your sal file and compress into .zip file named YourRoll Number_YourName.zip NOTICE that when creating the SQL commands as request, you MUST keep the name of tables, relationships, attributes and data type of attributes as SAME as given in the given ERD. Attributes have written with underline are Primary key of each entity. Attributes which reference to the primary key of another table must have the same name as the attributes in the primary key of the referencing table. When submitting the responses for this question, submit only SQL statements for creating tables with corresponding keys and foreign keys. No SQL statement specifying the database name like create database, alter database or use databasename is accepted. Question 1 (Q1.sql): Gender: bit ActivityID: int Name: nvarchar(30) MemberID: int FullName: nvarchar(50) Date: Date Activities Participates Members Description: nvarchar(100) Date Of Birth: Date Organizes Joins Manage ToDate: Date Clubs FromDate: Date ClubID: int Name: nvarchar(100)

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

C++ Database Development

Authors: Al Stevens

1st Edition

1558283579, 978-1558283572

More Books

Students also viewed these Databases questions

Question

What does Disney do best to connect with its core consumers?

Answered: 1 week ago

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago