Create the database with these tables using SQL commands. Prefix the table names with project_. Make sure the primary key and foreign key constraints are in place in the database. As evidence, include screenshots of each table design screen, and the corresponding SQL commands. MembersMemberIDMemberNameGenderPhoneDOBDate JoinedInitial WeightMembership TypeActivityRecordRecordIDRecordDateMemberIDMembershipsMembership TypeDiscountFeesActivity DoneRecordIDActivityTimeSpentActivity TypesActivityNameActivity TypeFitnessMeasuresDocumentIDMeasureDateMemberIDBMIFatWeight

Answered: Create the database with these tables…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Create the database with these tables using SQL commands. Prefix the table names with project_. Make sure the primary key and foreign key constraints are in place in the database. As evidence, include screenshots of each table design screen, and the corresponding SQL commands.

Members
MemberID
MemberName
Gender
Phone
DOB
Date Joined
Initial Weight
Membership Type
ActivityRecord
RecordID
RecordDate
MemberID
Memberships
Membership Type
Discount
Fees
Activity Done
RecordID
Activity
TimeSpent
Activity Types
ActivityName
Activity Type
FitnessMeasures
DocumentID
MeasureDate
MemberID
BMI
Fat
Weight

Expert Solution

Step 1

Note: since you have not include sample data that to be insert's we have provided datatype that are possible for given Attributes in data base ;

Make sure create table in order which sql command are provided

First create those table that do not have foreign key . say, Memberships and ActivityTypes

Step by step

Solved in 3 steps with 1 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions