Define the necessary and sufficient condition for two transactions to be serialisable. Give an example of a non-serialisable execution of a pair of transactions. [3 marks] (c) Define the necessary and sufficient condition for any number of transactions to be serialisable. [1 mark] (d) You may not make use of extra-logical built-in predicates such as findAll. Illustrate with examples from your group project, or from experience you gained working for a commercial software developer, or both. [10 marks Suppose that S(a, b, . . .) and R(a, . . .) are relations (the notation indicates

that attribute a is in the schema of both S and R, while attribute b is only in

the schema of S). Suppose that v is a value; is the following equation always

valid?

(a=v or b=v)

(R ./ S) = (a=v(R)) ./ (b=v(S))

If yes, provide a short proof. If no, provide a counter-example. [2 marks] Your Game

The game you write for this assignment is based on the book Alice's Adventures in Wonderland by Lewis Carroll, also known as Alice in Wonderland. You may base your game on either the book by Lewis Carroll or one of the movie adaptations of the book.

Alice's Adventures in Wonderland is in the public domain. You can access a copy of the work online through Project Gutenberg.

Alice in Wonderland makes for an entertaining adventure game, because there are many rooms (scenes), as well as a number of key characters and situations you may employ in your game. I'm on Chapter 7: Using Object-Oriented Javascript. When I click on the white box under "Pick a Date", I'm supposed to open up a calendar. I'm also supposed to activate the countdown for my selected reservation, as well as the payment. But it seems that no matter how much code I try to change, I can't get the page to work the way the assignment wants it. I'd really like some help here with how the code here should be written. You are not expected to follow the entire plot of the book, nor are you expected to program the entire book, all the items, or all the characters.

Rather, your game is to be an adaptation of the book into the form of an adventure game in which your characterAlice, perhapssees various scenes and characters and can interact with them and with the items found in their vicinity. There is no requirement that your main character (i.e., you, the player) represents Alice, although this is probably the most common choice.

For example, you may start your game as Alice, above ground, who encounters the white rabbit and talks to him. Eventually, you find the rabbit hole and fall down to the room containing "eat me" and "drink me." Consuming these items will presumably have the same effect as in the book.

Likewise, you may interact with the Cheshire Cat, the Mad Hatter and other book characters. Prolonged interaction with the Red Queen will, presumably, prove to be unfortunate.

Ultimately, you will decide how the book characters, scenes and items "come to life" in your game. 1. Suppose you are helping a human resource manager in a company that requires you to retrieve the biodata of the applicants or potential employees. Provide an HTML or java code of an application design that displays the biodata of the applicants and presents them on a table or array, containing their profile information and educational background. Include a conditional control structure that asks the applicant for the number of years if he says he has work experience. For creative purposes, you can design any layout and provide which information should be included in a biodata. Remember to put the gathered biodata from the different applicants in a table with "Add", "Delete" and "Search" buttons.

In other words, the program must utilize the three types of control structures namely sequential, conditional and looping including combinatorials as well as arrays in your program. 1. Suppose you are helping a human resource manager in a company that requires you to retrieve the biodata of the applicants or potential employees. Provide a flowchart of an application design that displays the biodata of the applicants and presents them on a table or array, containing their profile information and educational background. Include a conditional control structure that asks the applicant for the number of years if he says he has work experience. For creative purposes, you can design any layout and provide which information should be included in a biodata.

The HTML code should be working () with no errors Need an online web store design in HTML, CSS and Java.