Question: Make an erd diagram and a schema diagram with these entities 1. admin reg 3. professor reg - id (PK) - Email - Password

Make an erd diagram and a schema diagram with these entities 1.

Make an erd diagram and a schema diagram with these entities 1. admin reg 3. professor reg - id (PK) - Email - Password - id (PK) - FirstName - LastName - Course - Department - Email - Password 2. email sent - id (PK) - sent to - sent.cc 4. students reg 5. student request 6. tutor apply - id (PK) - id (PK) - id (PK) - FirstName - LastName - Course - Email - FirstName - LastName - Email - Course - Subject - FirstName - LastName - Email - Course - Password - Program - Info - Uni - Degree - Feedback - Info 7. tutor reg - id (PK) - FirstName - LastName - TUID Email - Course - Password - Info

Step by Step Solution

★★★★★

3.48 Rating (161 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 Databases Questions!

Construct another graph of investments and national savings. Assume that they intersect at the world interest rate. Show 1) how expansionary fiscal policy changes the net export and 2) how the...

Case Study: Quick Fix Dental Practice Technology requirements Application must be built using Visual Studio 2019 or Visual Studio 2017, professional or enterprise. The community edition is not...

A small consulting company wants to make the switch to QuickBooks Online. All of their expenses are paid at the time they are incurred, so there is no need to track bills in the system. There is only...

Bob is a sales clerk at a retail clothes store. When he locks the store for the evening at closing time, he is unaware that a customer is in the change room. The customer is unable to call anyone and...

please answer the question as per the check list 2 The old ERD 3 The new Normalized ERD 4 A summary of the changes that you have applied to your design. User user_id:int username: varchar(255)...

Use the E-R Diagram and execute the HR.SqL to create the initial setup and data for the lab assignment 1) E-R DIAGRAM 2)HR.SQL to create initial setup: after sql setup answer the below questions 1 to...

My task is follow the correction in the report contents. Submit the technical review report on following topics. Use case naming and description. Completeness of the formal use case. Correctness of...

CIS336 Lab 2: The Expanded Entity Relationship Diagram LAB OVERVIEW Scenario and Summary This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will be...

Database Lab 2: The Expanded Entity Relationship Diagram LAB OVERVIEW Scenario and Summary This lab introduces the next step in creating a data model, the Entity Relationship Diagram (ERD). You will...

In some countries, such as Japan and Germany, corporations develop close long-term relationships with one bank and rely on that bank for a large part of their financing needs. In the United States,...

Use the solubility rules (Table 4.1) to decide which of the following compounds are expected to be soluble and which insoluble. a. Ca(NO3)2 b. AgBr c. MgI2 d. PbSO4

Using Double Integrals, Calculate the Area bounded b y y = x 3 - x 2 - 2 x + 2 , & y = 2

Refer to RE10-7. Dexters beginning cumulative costs for Year 2 were $500,000 and ending cumulative costs were $3,000,000. Calculate Dexters average cumulative costs. In RE10-7, Dexter Construction...

Carnival Corporation has recently placed into service some of the largest cruise ships in the world. One of these ships, the Carnival Dream, can hold up to 3,600 passengers and cost $750 million to...

Wyoming Woodworks is evaluating two capital investment proposals for a retail outlet store, each requiring an investment of $1,000,000 and each with a five-year life and expected total net cash flows...

The following data are accumulated by McDermott Motors Inc. evaluating two competing capital investment proposals: Determine the expected average rate of return for each proposal. Testing Equipment...

Oregano Inc. was formed on July 1, 2014. It was authorized to issue an unlimited number of common shares and 100,000 shares of cumulative and non-participating preferred shares carrying a $2...

Critically evaluate an organizational strategic leadership situation of Warren Buffet, analyzing the paradigms and other factors influencing leadership strategic effectiveness and organizational...

In Exercises 2534, use mathematical induction to prove that each statement is true for every positive integer n. 2 is a factor of n 2 + 3n.

Explain how to square a binomial difference. Give an example with your explanation.

Shown again is the table indicating the marital status of the U.S. population in 2010. Numbers in the table are expressed in millions. Use the data in the table to solve Exercises 110. Express...

Many kinds of games people play rely on randomness. Cite three different methods commonly used in the attempt to achieve this randomness, and discuss the effectiveness of each.

A basketball player with a 65% shooting percentage has just made 6 shots in a row. The announcer says this player "is hot tonight! She's in the zone!" Assume the player takes about 20 shots per game....

At its website (www.gallup.com), the Gallup Poll publishes results of a new survey each day. Scroll down to the end, and you'll find a statement that includes words such as these: Results are based...