The below sample data in third normal form was provided by a database designer. Answer the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The below sample data in third normal form was provided by a database designer. Answer the below questions using this data and assume that the below data will exist in the tables. Table: TeamMember Primary key: TeamMemberID TeamMemberID Team MemberName TeamMemberEmail 1 Joe Bloggs joe@theoffice.com 2 Samantha Smith sam@theoffice.com 3 Pete Ngwenya pete@theoffice.com Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID Description Duration StartDate TeamMemberID 1 Build login screen 4 2022-05-06 1 2 Implement inventory 10 2022-05-15 1 management 3 Add logo to splahs 1 2022-05-06 2 screen Q.6.2.1 Write a SQL statement to create the table Task. Hint: The sample data should give you an indication of the data types you should use. (10) The below sample data in third normal form was provided by a database designer. Answer the below questions using this data and assume that the below data will exist in the tables. Table: TeamMember Primary key: TeamMemberID TeamMemberID Team MemberName TeamMemberEmail 1 Joe Bloggs joe@theoffice.com 2 Samantha Smith sam@theoffice.com 3 Pete Ngwenya pete@theoffice.com Table: Task Primary key: TaskID Foreign key: Team MemberID TaskID Description Duration StartDate TeamMemberID 1 Build login screen 4 2022-05-06 1 2 Implement inventory 10 2022-05-15 1 management 3 Add logo to splahs 1 2022-05-06 2 screen Q.6.2.1 Write a SQL statement to create the table Task. Hint: The sample data should give you an indication of the data types you should use. (10)
Expert Answer:
Posted Date:
Students also viewed these computer network questions
-
19.BCS Industries is contemplating issuing a 30 year bond with a coupon rate of 7% (annual coupon payments) and a face value of $1000 per bond. BCS believes it can get a rating of 'A' from Standard &...
-
Blue Corporation, a C-Corporation, has current E&P of $300,000 and accumulated E&P of $1,000,000. Blue Corporation distributes land to its sole shareholder Steve. The land had a FMV of $100,000 and...
-
Four students are running for the position of class president: Ermias (E), Christina (C), Lloyd (L), and Hu (H). A vote of all the students in the class was held and the results are summarized in the...
-
Air flows with negligible friction through a 4-indiameter duct at a rate of = lbm/s. The temperature and pressure at the inlet are T1 = 800 R and P1 = 30 psia, and the Mach number at the exit is Ma2...
-
State whether the following sentences are true or false regarding the nature and uses of governmental-type funds. If the sentence is false, state why. 1. Debt service expenditures and capital outlays...
-
A bank issues a $150,000 fixed-rate, 35-year mortgage with a nominal annual rate of 5.5%. If the required rate drops to 5.0% immediately after the mortgage is issued, what is the impact on the value...
-
Rationalize the denominator of the following: 1. \(\frac{5}{\sqrt{7}}\) 2. \(\frac{3 \sqrt{6}}{2 \sqrt{10}}\)
-
Shania Twain Company was formed on December 1, 2013. The following information is available from Twains inventory records for Product BAP. A physical inventory on March 31, 2014, shows 1,600 units on...
-
On 21st August 2002 the Commonwealth Bank (CBA) announced that it would slash 1550 jobs while creating 550 jobs, a net loss of 1000 jobs. It planned to reduce inefficient operations, task duplication...
-
What is the charge of the metal in vo3?
-
S&P Enterprises will pay an annual dividend of $2.08 a share on its common stock next year. Last week, the company paid a dividend of $2.00 a share. The company adheres to a constant rate of growth...
-
The Company received an order to make school uniforms and uses the job order cost system. The following transactions occurred during 2014 to Job U-101. a.Purchased raw materials at a cost of P...
-
Stairway Company sells a single product. The company's most recent income statement is given below: Sales (5,000 units) 200,000 Less: Variable expenses 120,000 Contribution margin 80,000 Less Fixed...
-
Notsogood Property Developers signed a contract with a customer, OK Property Renters, to construct a commercial building for a consideration of $5 million. The project is expected to last for two...
-
Scott is a new investor and has been closely watching a company by the name of AUS Ltd., a pharmaceutical company aiming to develop a coronavirus vaccine. Scott believes the following returns are...
-
Should Peoples Federal Savings have hedged its September 1 savings certificate rollover? What would you have advised Mr. Myers to do on August 6? How should Mr. Myers explain his future losses to the...
-
Three successive resonance frequencies in an organ pipe are 1310, 1834, and 2358 Hz. (a) Is the pipe closed at one end or open at both ends? (b) What is the fundamental frequency? (c) What is the...
-
You are evaluating two investments that each require $1,000. One is a municipal bond that pays 9 percent interest annually. The interest is exempt from federal and state taxes. The other is a...
-
You should buy insurance and establish an emergency fund before you invest, and you should invest early. Write About It Write several paragraphs explaining why you should take these steps before...
-
List four specific sources of financial information.
Study smarter with the SolutionInn App