Question: CREATE TABLE member ( memberID INT primary key , Firstname varchar (20), Lastname varchar (20), Phonenumber INT, Address varchar (30), Paymentmethod varchar (20), Typemember varchar

CREATE TABLE member

(

memberID INT primary key ,

Firstname varchar (20),

Lastname varchar (20),

Phonenumber INT,

Address varchar (30),

Paymentmethod varchar (20),

Typemember varchar (20), Schedule INT ,

);

Please use primary key,foreign key in MS SQL .and show screenshot too

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!

Q:

MIcrosoft SQl server. Answer correctly - dont spam Share screenshot Customer Table: CREATE TABLE CUSTOMER ( CID int PRIMARY KEY, ENAME varchar (30) not null, Name varchar (30), Address varchar (50)...

Q:

Provide the $QL for the following data requests. Your SQL should be written as a single script that can be pasted into MySQL and run without edits. Make sure you use the proper notation for your...

Q:

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many employees do not have children? 5. Which...

Q:

Need help with these questions. MySQL Q12: List the names of all member(s) from California and the names of the salespeople that they work with. Q13: List the names of all artists who have recorded...

Q:

Design the following queries. (MySql) For each title id, report the number of sound files (Mp3 file and the realaud file, use UNION ALL ) The following is the date:...

Q:

MYSQL Q13: List the names of all artists who have recorded more than one title and the number of titles they have recorded. ( You must use either Equi-join or Inner join)...

Q:

SQL Help This question uses the code in Schedule.sql. The query below is intended to calculate how much each enrolled student will owe for each Winter 2003 course he's taking, assuming that each...

Q:

Using the following books.sql table, an example of using a query against the books.sql database is below in the class DisplayAuthors to . Perform the following: Select a specific author and list all...

Q:

Using the following books.sql table, and modify the existing Java class DisplayAuthors to query the sql database. And perform the following: M odify the code to query for the following: Select a...

Q:

Instructions 1. Using the ER Diagram, create an SQL script the implements the design in a text file. a. Use the create_databases.sql script as a template or guide. b. In your script create the...

Q:

Ultimately a treasurer must choose among alternative strategies to manage transaction exposure. Explain the two main decision criteria that must be used.

Q:

XYZ Corporation is considering investing in a new project that has a potential return of $500,000. However, there is also a 20% chance that the project could fail, resulting in a loss of $250,000....

Q:

QUESTION 1 ( 4 9 marks ) Primark Ltd is the manufacturer of the very popular, Prima energy drink. Primark Ltd has a 3 0 June financial year - end. Primark Ltd s manufacturing process follows the...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Question How do employer health and accident benefits fit into a cafeteria plan?

Q:

Question Should an employer finance its obligations under a death benefit plan in advance?

Q:

Question What mistakes in plan design or other circumstances would cause an employer death benefit to be included in the employees estate?