Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started