c)What about the portal columns containing a textual description of each assignment and the assignment weight? Those textual descriptions are stored in the Assignmentstable. •It seems we need to connect the Markstable to the Assignmentstable. What is the primary key for the Assignmentstable? The CourseandAssignNumfields. Once again you need to link two tables by matching the values of twofields. d)Finally, the course grade shown bottom right. See if you can figure out how that’s done. You’ll need to create a calculated field in the Markstable, and a calculated field in the Studentstable, but nothing more. Details left to the reader…Password-protected solutions to these questions are in Learn. (Use a blank password.)
CS200 Assignment 9 Page 6 of 6Bonus [10 marks] The following are some examples of what you can do in SQL’s WHEREclause: •compare a field value with a literal valueexample: name = ‘Tony’ •compare two field values —often used in a relationship conditionexample: Students.IDN = Register.IDN •combine comparisons using an ORexample: (Course = ‘Biol’) OR (Course = ‘Phys’) •combine comparisons using an ANDexample: (Surname = ‘Tony’) AND (Students.IDN = Marks.IDN) AND (Course = ‘Biol’) •other assorted operators can be usedexample: (Mark > 80) AND (Mark < 90) AND NOT (Studnum = 8912345) The above are different examples of what you can do with an SQL whereclause as opposed to a FileMaker Find. Explain how to do each of the above queries in both SQL and in FileMaker’s Find Mode(or, when necessary, explain how to do the query in one application and note that it is not possible to do in the other). Note: This is essentially a compare and contrast question. This question is not asking how you would do the particular SQLexample given in FileMaker, but how you would do the bolded statements in both applications (i.e. do not explain how to find “Tony” specifically). Assume that your reader is an experienced user of both SQLand FileMakerPlease enter your answer in a properly (but not elaborately) formatted MS Worddocument named username_a9bonus(or username1_username2_a9bonus) of at most one page showing your name and username (or codes, if you are working with a partner) at the beginning of your document. Comment: this is the sort of question you should habitually ask yourself when you have available two applications, either of which might be suitable for the same task. It is also a typical CS 200 examination question, for which this is good practice. . Submission Instructions •Create a folder called username_Assign9•Move each of the assignments files (username_A9Q1 orusername1_username2_A9Q1, username_A9Q2 orusername1_username2_A9Q2 andusername_a9bonus orusername1_username2_a9bonus)to this folder. •Compress this folder and name it username_Assign9.zipand submit it to the Assignment 9 Dropbox on Learn.