Question: Try to create at least 2 table and link them together through mysql join (relationship) Table A has a field in Table B which is

Try to create at least 2 table and link them together through mysql join (relationship) Table A has a field in Table B which is matching both field.

When we call table A statement will respond statement B

1.0 Centralized Database for the college

1.1 Making a Database for Students in Pures College (2 tables 1 international 1 domestics) 1.2

2.0 Inventory of products

2.1 two-there tables related to products such as Nike, adidas etc 2.2 2 tables. 1 sport, runners

3.0 Hospital database

3.1 Admitted patients in different wards

4.0 Payroll

4.1 Salary for employee

5.0 Blood donation 5.1 0

5.2 A 5.3 B 5.4 AB

6.0 Covid-19 vaccination 6.1 Covid Shield

6.2 Pfizer

6.3 Moderna 7.0 Library System 7.1 Books.

For this project you will be able to use PHPMYADMIN in case you encounter any difficulties created tables.

Step by Step Solution

★★★★★

3.42 Rating (177 Votes )

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

Q:

2. Daniel earns $12 per hour at McDonald's he can work up to 50 hours per week. First, draw his labor-leisure budget constraint. How is the slope determined? Show how his budget constraint will...

Q:

Consider a person who can work up to 80 hours each week at a pre-tax wage of $20 per hour but faces a constant 20% payroll tax. Under these conditions, the worker maximizes her utility by choosing to...

Q:

Touche Young has eight auditors. Each can work up to 160 hours during the next month, during which time six projects must be completed. The hours required for each project and the amounts each...

Q:

Review the sample transitional matrix shown in Table. What jobs experience the greatest turnover (employees leaving the organization)? How might an organization with this combination of jobs reduce...

Q:

Claims received by Healthwise Insurance Company are entered into the database at one station, and sent to another station for review. The processing time (in minutes) required for each general type...

Q:

Match (by letter) the following items with the description or example that best fits. Each letter is used only once. Terms __________ 1. Operating activities. __________ 2. Investing activities....

Q:

Selected terms related to the statement of financial position, which were discussed in Chapters 2 through 5, are listed below. Match each definition with its related term by entering the appropriate...

Q:

Tootsie Roll Industries manufactures and sells more than 64 million Tootsie Rolls and 20 mil-lion Tootsie Roll Pops each day. The following items were listed on Tootsie Rolls recent income statement...

Q:

The following table shows data for the simple production function used in Question 2. Capital costs this firm $50 per unit, and labor costs $20 per worker. a. From the information in the table,...

Q:

Assume that you have just been hired as a financial analyst by Tropical Sweets Inc., a mid-sized California company that specializes in creating exotic candies from tropical fruits such as mangoes,...

Q:

On March 10, 2015, Global Solutions, Inc., purchased 5,000 shares of Superior Technologies stock for $ 50 per share. The following information pertains to the fair value of Superior Technologies...

Q:

The adjusting entry for accrued fees was omitted at December 31, the end of the current year. Indicate which items will be in error, because of the omission, on (a) The income statement for the...

Q:

Problem 2 - 4 ( Static ) ( LO 2 - 4 ) What is goodwill? Muttiple Choice An intangible asset representing the excess of consideration transfered over the collective fair values of the net ifentifable...

Q:

(a) Show that the short wavelength cutoff in the x-ray continuous spectrum is given by 2min = 12.4 /V, where V is applied voltage in kilovolts. (b) If the voltage across an x-ray tube is 186 kV what...

Q:

part1 q=2 T/m; P=4T; k 1 =0.5; k 2 =0.2; l=4m Draw N z diagram. part-2 about the rectangle image Material: concrete n=3 compress = -300 kG/cm 2 D KI a

Q:

A 20 KeV electron emits two bremsstrahlung photons as it is being brought to rest in two successive decelerations. The wavelength of the second photon is 1.30 longer than the wavelength of the...

Q:

The general solution, y(t) satisfies the following second order differential equation ay"+ by'+ cy = 3 cos 2t where a, b and c are constants and a # 0. The y(t) depend on whether b 2 > 4ac, b 2 = 4ac...

Q:

Mr Kleenex and Ms Sorbent own and operate a tissue retail business. The partnership agreement indicates that Mr Kleenex is entitled to 60% of the profits and Ms Sorbent 40% The accounting net profit...

Q:

Which of the following is the primary source of energy for the brain? Question 9 options: a) Fructose b) Fructan c) Glycogen d) Galactose

Q:

Create a class called book that can get and set information about books (book name, author, page numbers, ISBN number, price, etc.). Then create objects with this class and get / set information...

Q:

Use the means-objectives network in Figure 6.8 to create a list of alternatives for improving automotive safety. Try to create at least one alternative for each objective listed. Maximize Safety...

Q:

Use the means-objectives network in Figure 6.8 to create a list of alternatives for improving automotive safety. Try to create at least one alternative for each objective listed.

Q:

(a) Design and implement a program that uses for loops to print the following rectangular pattern with a user specified width, height and wall thickness. Check the values entered by the user and, (a)...

Q:

Rev.Confirming Pages C H A P T E R 7 Planning, Composing, and Revising Chapter Outline The Ways Good Writers Write Activities in the Composing Process Using Your Time Effectively Brainstorming,...

Q:

Cirque du Soleil Murielle Cantin dragged her suitcases through the lobby of the hotel. It was one of the nicer hotels in Rio, but she missed her own bed, her own home back in Montreal, Canada. As...