Question: Data Dictionary: Table Name Patient Doctor Attribute Name P_Num P_FirstName P_LastName P_Contact Num D_Num D_FirstName D_LastName D_ContactNum D_Type Contents Customer Number Customer First Name

Data Dictionary: Table Name Patient Doctor Attribute Name P_Num P_FirstName P_LastName P_Contact Num D_Num D_FirstName D_LastName D_ContactNum D_Type Contents Customer Number Customer First Name Customer Last Name Customer Telephone Number Doctor Number Doctor First Name Doctor Last Name Doctor Telephone Number Type of Doctor 4.1 Using the correct SQL command create the two tables stated in the data dictionary. 4.2 Using the correct SQL command following information for the Patient table: (001, Anna, Smith, 0317075310) 4.3 Using the correct SQL command following information for the Doctor table: (401, Dawn, Thomas, 3012233445, GP) 4.4 Use the correct SQL command to see all contents in the Patient table. 4.5 Use the correct SQL command to see all contents in the Doctor table. 4.6 Remove the details for Patient 001 from the Patient table. Type INTEGER VARCHAR(35) VARCHAR(35) CHAR(10) INTEGER CHAR(35) CHAR(35) CHAR(10) CHAR(10) (10 Marks) (2 Marks) (2 Marks) (2 Marks) (2 Marks) (2 Marks)

Step by Step Solution

★★★★★

3.27 Rating (165 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

42 Ans ... View full answer

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 Programming Questions!

Create a HTML file with one text box and three buttons for Average, Minimum and Maximum. The user will input numbers with spaces in the text box. After the buttons are pressed, you need to show the...

Horizontal and vertical links are hinged to a wheel, and forces are applied to the links as shown. Knowing that 75 a = mm, determine the value of P and the reaction at A. 100 mm 100 mm 100 mm 90 N

Horizontal and vertical links are hinged to a wheel, and forces are applied to the links as shown. Determine the range of values of the distance a for which the magnitude of the reaction at A does...

1. What opportunity did Nach Waxman identify when founding Kitchen Arts & Letters? 2. What are the business-definition aspects of KA&L (offer, target market, capability, problem solving)? 3. What is...

The following business scenarios are independent from one another: 1. Chris Hann purchased an automobile from Classic Auto Sales for $10,000. 2. Sal Pearl loaned $15,000 to the business in which he...

Condensed financial data of Cheng Inc. follow. Additional information: 1. New equipment costing $85,000 was purchased for cash during the year. 2. Old equipment having an original cost of $57,500 was...

Assume that Craig Reed is the sole proprietor of Nuclear Company. At the end of the first year of operations (December 31, 2010), the following financial data for the company are available: Mr. Reed...

Journalize the entries to record the following selected held-to-maturity investment transactions for Green Corp.: 1. Purchased for cash $2,000,000 of ABC Corp. eight-year, 5% bonds at 98.98 on their...

The equity sections from Hovo Corporations 2015 and 2016 balance sheets follow. Stockholders Equity (December 31, 2015) Common stock $20 par value, 30,000 shares authorized, 17,000 shares issued and...

Flexible budgets and the motivational role of budgets Club Atlantic is an all-weather holiday complex providing holidays throughout the year. The fee charged to guests is fully inclusive of...

21. ALL_SOURCE will help us to a) Displays the objects in the database b) Describes the text source of all stored objects in the database c) None of the above d) Describes the text source of the...

Based on the information given in the figure, determine the necessary power input to the compressor (Win). Yout=26 kJ/kg P = 600 kPa T2=600 K Air m = 0.02 kg/s P = 100 kPa T = 480 K Win = ?

Read the article, "This Map Shows the Scale of the 16th- and 17th-Century Scottish Witch Trials" located in the module resources. When reviewing this article, you may consult the map or the text. As...

Suppose that L is a location function of an object, given as L(t) instantaneous velocity of the object at t First we compute and simplify L(5+ h). L(5+ h) = = 2t 1. We will compute the 5 as follows....

Use the following account balances from the adjusted trial balance of Flora Wholesalers: Account Debit Balance Credit Balance Cash $ 4,200 Accounts receivable $ 300 Accounts payable $ 1,100 H. Jones,...

A physician hopes to advocate for a new medical records system that he believes will save his department money. He has a good idea of the money that can be saved each year, and has received several...

Albury Company is adding a new assembly line at a cost of $8.5 million. The company expects the project to generate cash flows of $2 million, $3 million, $4 million, and $5 million over the next four...

7. Baladna wants to analyze process that includes delivery by suppliers, production inside the company, transportation to to its customers and information systems. Then it also wants to find out...

The received voltage in a 75 antenna of a wireless communication system is modeled as a Rayleigh random variable, What does the value of the parameter need to be for the received power to be 10W ?...

Find the PSD of the process A discrete random process, X[n], is generated by repeated tosses of a coin. Let the occurrence of a head be denoted by 1 and that of a tail by - 1. A new discrete random...

The power spectrum at the input to an ideal BPF is Let the transfer function for the ideal BPF be Determine the autocorrelation function of the output. You may have to make a reasonable approximation...

In a _______ study, the participants do not know if they are part of the control group or the experimental group. Only the experimenter knows who is in each group. a. double-blind b. placebo c....

If Dr. Swasey is like most psychologists, where does she probably work? a. university/college b. self-employed c. federal government d. state or local government

Which of the following is an example of observer bias? a. You ask your fellow students to be participants in a study of adult memory. b. You develop an opinion of what you expect to see in an...