Transform the ERD in Figure Q3(a)(i) into a logical model. Assignment courseCode assignment Number H weight...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Transform the ERD in Figure Q3(a)(i) into a logical model. Assignment courseCode assignment Number H weight due Date has Course courseCode courseName isFor enrols Figure Q3(a)(i) Submission student Id courseCode assignment Number date Submitted score submits Student student Id program Question 3 (35 marks) (a) (i) Transform the ERD in Figure Q3(a)(i) into a logical model. Assignment courseCode assignment Number H weight due Date has Course courseCode Bo courseName isFor enrols Figure Q3(a)(i) Submission student Id courseCode assignment Number date Submitted score submits Student student Id program (ii) Refer to the description of the columns and relationships and then code the appropriate SQL statements to create the tables, derived from the ERD in Figure Q3(a)(i). You must use the same table names and the same column names as given in Figure Q3(a)(i) or your statements will be marked as incorrect. List your SQL statements in the order that they should be executed. Description for columns: studentId is a whole number starting from 1000000 with step increment 1 and is auto-generated. program is at most 50 characters and is one of these values: Accountancy, Finance, Information and Communication Technology, Business Administration. courseCode is exactly 5 characters starting with two letters (A-Z) followed by 3 digits (0-9). courseName is at most 50 characters long. assignmentNumber is a running number for each course and can be generated with a trigger. weight is an integer that is greater than 0, dueDate is a date at least one week after today's date. dateSubmitted is a date with default value today's date, score is a decimal number between 0 and 100. All columns are required except for dateSubmitted and score Constraints Refer to Figure Q3(a)(i) for the minimum and maximum cardinalities. enrols relationship - delete cascade and update disallowed for actions on Student and delete/update disallowed for actions on Course. has relationship - delete and update cascade. submits relationship - delete cascade and update disallowed. isFor relationship - delete and update disallowed. Transform the ERD in Figure Q3(a)(i) into a logical model. Assignment courseCode assignment Number H weight due Date has Course courseCode courseName isFor enrols Figure Q3(a)(i) Submission student Id courseCode assignment Number date Submitted score submits Student student Id program Question 3 (35 marks) (a) (i) Transform the ERD in Figure Q3(a)(i) into a logical model. Assignment courseCode assignment Number H weight due Date has Course courseCode Bo courseName isFor enrols Figure Q3(a)(i) Submission student Id courseCode assignment Number date Submitted score submits Student student Id program (ii) Refer to the description of the columns and relationships and then code the appropriate SQL statements to create the tables, derived from the ERD in Figure Q3(a)(i). You must use the same table names and the same column names as given in Figure Q3(a)(i) or your statements will be marked as incorrect. List your SQL statements in the order that they should be executed. Description for columns: studentId is a whole number starting from 1000000 with step increment 1 and is auto-generated. program is at most 50 characters and is one of these values: Accountancy, Finance, Information and Communication Technology, Business Administration. courseCode is exactly 5 characters starting with two letters (A-Z) followed by 3 digits (0-9). courseName is at most 50 characters long. assignmentNumber is a running number for each course and can be generated with a trigger. weight is an integer that is greater than 0, dueDate is a date at least one week after today's date. dateSubmitted is a date with default value today's date, score is a decimal number between 0 and 100. All columns are required except for dateSubmitted and score Constraints Refer to Figure Q3(a)(i) for the minimum and maximum cardinalities. enrols relationship - delete cascade and update disallowed for actions on Student and delete/update disallowed for actions on Course. has relationship - delete and update cascade. submits relationship - delete cascade and update disallowed. isFor relationship - delete and update disallowed.
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 Based on the information provided about the ERD and the table descriptions here are the SQL statements to create the tables in the order they should be executed Student table CREATE T... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these mathematics questions
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona....
-
Let S be the portion of the cylinder y = e x in the first octant that projects parallel to the x-axis onto the rectangle R yz : 1 y 2, 0 z 1 in the yz-plane. Let n be the unit vector normal to S...
-
Three noise sources produce intensity levels of 70, 73, and 80 dB when acting separately. When the sources act together, their intensities add. (a) Find the sound intensity level in decibels when the...
-
Why doesnt every person or organization invest all available funds into the stock market, which has the highest expected return?
-
Develop your key relations chart for this chapter. Remember that a key relations chart is not a core dump but is selective.
-
Accounting educators are discussing ways to incorporate communication skills, both oral and written, into accounting information systems courses. Why do you think these skills are deemed crucial for...
-
Company : Target Identified a new strategic direction for the company?. Please provide fully detail of the answer and reference also
-
The soil mass in Figure P9-13 is loaded by a force transmitted through a circular footing as shown. Determine the stresses in the soil. Compare the values of r using an axisymmetric model with the ...
-
Who were the individuals participating in the round table discussion, and what was their respective relevance to the Murdaugh cases? Discuss the five deaths...
-
Pete s father died on January 4 , 2 0 2 3 . The father had owned stock for JUST 1 0 months ( bought it on March 4 , 2 0 2 2 for $ 1 4 5 , 0 0 0 ) and the stock was transferred to Pete through his dad...
-
Gwen is age 5 1 , married, and reported AGI of $ 1 1 9 , 0 0 0 in tax year 2 0 2 3 . She is an active participant in her employer's pension plan. What amount of deductible IRA contribution is...
-
Suppose that a rectangle's area is 9 square feet. Choose a variable to represent the width of the rectangle: What is a reasonable domain for your variable? Find a formula for the height of the...
-
Acme Company plans to invest $170,000 in a project that has a 3-year economic life. Acme expects the project to produce net cash inflows of $65,000 in Year 1 and $55,000 in Year 2. Assuming the...
-
OnTime Packaging is the world's leading express-distribution company. In addition to its 643 aircraft, the company has more than 57,000 ground vehicles that pick up and deliver packages. Assume that...
-
4.0g bullet is fired from a 5.0kg gun with a speed of 600 m/sec. What is the speed of the recoil of the gun? What is the direction of the recoil?
-
Write a program to move a signed number from smaller register to bigger register. Hint: movzx ax, bl Topic: Data Related Operators and Directives in assembly language
-
David and Darlene Jasper have one child, Sam, who is 6 years old. The Jaspers reside at 4639 Honeysuckle Lane, Los Angeles, CA 90248. David's Social Security number is 577-11-3311, Darlene's is...
-
Leslie and Leon Lazo are married and file a joint return for 2012. Leslie's Social Security number is 466-47-3311 and Leon's is 467-74-4451. They live at 143 Snapdragon Drive, Reno, NV 82102. For...
-
Quince Corporation has taxable income of $450,000 for its 2012 calendar tax year. Calculate the corporation's income tax liability for 2012 before tax credits. $_________
-
The amounts of time (in months) that 16 stars of The Bachelorette and their chosen partner stayed together as of April 2021 are listed. 208 12 3 12 18 94 3 75 8 36 75 20 24 045
-
The six top-earning states in 2019 by median household income are listed. 1. Maryland 2. New Jersey 3. Hawaii 4. Massachusetts 5. Connecticut 6. Alaska
-
The ages of the Supreme Court justices as of April 7, 2021 In Exercises 25 and 26, find the range, mean, variance, and standard deviation of the population data set. 66 56 72 49 82 71 66 60 53
Study smarter with the SolutionInn App