Premium Essay

Sequel

In:

Submitted By emmitt22nv
Words 479
Pages 2
This week the discussion moves to an extremely important part of relational database and that SQL, it stands for Structured Query Language and is a declarative programming language intended for the management of databases. Unlike other languages that use imperative programming, with declarative programming the end-user is establishing the code that is telling the computer what you would like to happen. Structured Query Language is a relatively simple language that a majority of all relational databases utilize in order to influence data in a database (“What is SQL?,” n.d.).

This leads to the question as to why SQL is such a powerful language this is because SQL make available the ability to manipulate any portion of a database through the use of simple commands. Through the use SQL programming language a plethora of functions in a database such as creating and deleting tables, updating and changing data and retrieving specific data to name a few.

By probably the single most powerful expression available to the database programmer in SQL is the employment of the “JOIN” command. At this point you may be thinking to yourself what makes this directive so powerful this is because the function allows the user to process a significant amount of data in a swift and efficient manner. While many individual databases may include two or four tables meanwhile businesses may have hundreds or even thousands of table with need to process data across these table this ultimately shows how the function works and what it does. It creates a temporary table by interconnecting rows across multiple tables through the use of a like field and providing the data (SQL JOIN, n.d.).

The final topic for this week’s forum is Query-By-Example a query creation method which is the most popular is because it is easier to learn than the various other styles of formal query languages

Similar Documents

Premium Essay

Arundel Partners Case Analysis

...purchasing the sequel rights associated with films produced by one or more major movie studios. Movie rights are to be purchased prior to films being made. Arundel wants to come up with a decision to either purchase all the sequel rights for a studio's entire production during a specified period of time or purchase a specified number of major films. Arundel's profitability is dependent upon the price it pays for a portfolio of sequel rights. Our analysis of Arundel's proposal includes a net present value calculation of each movie production company. In order to decide whether Arundel can make money buying movie sequel rights depends on whether the net present value of the production company's movies is higher than the estimated 2M per film required to purchase the rights. Problem Identification: How are the principals of Arundel Partners planning to make money by buying rights to sequels? They would be interested in purchasing the sequel rights for one or more studios¡¦ entire production over an extended period of not less than a year. If a particular film was a hit, and Arundel thought a sequel would be profitable, it would exercise its rights by producing the sequel. Alternatively, they can sell the rights to the highest bidder. Inevitably, the performance of the original films would not justify sequels, and for them the sequel rights would simply not be exercised. For most movies it becomes quite clear after their first few weeks in theaters whether a sequel would be economical...

Words: 277 - Pages: 2

Premium Essay

Arundel

...interested in purchasing the rights to make sequels of all of the studios movies, rather than just some. Why do they believe this venture is profitable? 2. Suppose that you are a movie executive. You are considering a movie version of the life of President Garfield in the months leading up to his assassination by Charles Guiteau in a Washington DC railroad station in 1881. Your analysts have determined that the expected revenues are $94,556,250. They determine that revenues will be distributed binomially as shown in Exhibit 1 (40% annual volatility). Exhibit 1 shows the possible payoffs and the probability of each state occurring (note this information is provided in an Excel file). Assume that the one-year T-Bill rate is 5% (yield with semiannual compounding). If given the green light, the movie will have the following costs: a. $36MM – Negative Costs (assume it is incurred immediately) b. $25MM – Distribution Fees (assume these are paid in one year) c. $32MM – Distribution Expenses (assume these are paid in one year). Should you accept this project? Why? Suppose that Arundel Partners will give you a $2MM check for the rights to the sequel. Do you accept the project? 3. Suppose you come upon another project with exactly the same costs and possible payoffs. However, this film is a movie version of the popular 1960s television show Gilligan’s Island. Would you give the green light to this movie without having sold the sequel rights to Arundel Partners? Why? What is...

Words: 495 - Pages: 2

Free Essay

Arundel Partners

...FINANCE Corporate Finance and Banking Arundel Partners: The Sequel Project The East Wind Amol Marathe 140843 Linglan Tan 140838 Xiangyu Zhou 140912 Date: 20/11/2014 Arundel Partners: The Sequel Project The East Wind Executive Summary: Arundel group is looking into the project of purchasing the sequel rights associated with films produced by one or more major movie studios in United States. Arundel believes that they can calculate a value for the rights to produce these sequels and take a position by investing in a portfolio conformed of these rights. Arundel Partners plans to make money by negotiating an option price below its net present value calculation and obtaining its expected returns on the option. The proposal is appealing to studios because sales of sequel rights can help them finance initial production, If particular movie becomes a sequel then the value of the option will increase and Arundel will either exercise the right to make the sequel or sell the right either to the original studio or a third party willing to take on the project. The principals at Arundel Partners are inclined to buy a portfolio of all these sequel rights rather than individual films given that Arundel wants to avoid buying the rights of movies that are not expected to perform well. Movie rights are supposed to be purchased prior to films being made. Arundel wants to come up with a decision to either purchase all the sequel rights for a studio's entire production during a specific...

Words: 3629 - Pages: 15

Premium Essay

Arundel Partners Case

...Partners: The Sequel Project 1. Why do the principals of Arundel Partners think they can make profits buying movie sequel rights? They would be interested in purchasing the sequel rights for one or more studios¡¦ entire production over an extended period of not less than a year. If a particular film was a hit, and Arundel thought a sequel would be profitable, it would exercise its rights by producing the sequel. Alternatively, they can sell the rights to the highest bidder. Inevitably, the performance of the original films would not justify sequels, and for them the sequel rights would simply not be exercised. For most movies it becomes quite clear after their first few weeks in theaters whether a sequel would be economical or not, based upon each film's box office performance. 2. Why do they want to buy a portfolio of rights in advance rather than negotiating film-by-film? It is of critical importance to Arundel that a number of films and a price per film is agreed upon before either Arundel or the studio knew which films would generate the option of a sequel. In addition, once production started, the studio would inevitably form an opinion about the movie and the likeliness that a sequel would be possible. This would put Arundel at a disadvantage, because they would then have to negotiate the price for sequel rights on each film produced, while knowing much less than the production studio about the film. 3. Estimate the per-film value of a portfolio of sequel rights using...

Words: 390 - Pages: 2

Free Essay

This Isn't Real

...Assignment and Rationale: For this project, you are required to find three legitimate, same-genre movie posters from the last decade and write a report revealing your genre awareness findings and conclusions about both the stability and flexibility of the movie genre represented in these three posters. You may choose the movie genre, and you may find that you’re working with a multi-hyphenated genre (e.g., thriller-crime-drama). This is fine, as long as you can find three movie posters that represent this particular genre. However, I advise you to not go too obscure in your choices, as this might limit or make difficult your selection, and I also request you stay away from choosing posters for movies already clearly linked (e.g., sequels, trilogies). Also, I encourage you to consider the country of origin for the movies and posters, as this will alter/change the content of the poster. For the sake of uniformity, use the U.S./English version of a movie poster, if possible. The movie poster functions as a shorthand version of all that the movie is trying to represent or present. As such, the posters...

Words: 431 - Pages: 2

Free Essay

Avatar

...Avatar is a 2009 American[8][9] epic science fiction action film directed, written, co-produced, and co-edited by James Cameron, and starring Sam Worthington, Zoe Saldana, Stephen Lang, Michelle Rodriguez, Joel David Moore, Giovanni Ribisi, and Sigourney Weaver. The film is set in the mid-22nd century, when humans are mining a precious mineral called unobtanium on Pandora, a lush habitable moon of a gas giant in the Alpha Centauristar system.[10][11][12] The expansion of the mining colony threatens the continued existence of a local tribe of Na'vi – a humanoid species indigenous to Pandora. The film's title refers to a genetically engineered Na'vi body with the mind of a remotely located human, and is used to interact with the natives of Pandora.[13] Development of Avatar began in 1994, when Cameron wrote an 80-page treatment for the film.[14][15] Filming was supposed to take place after the completion of Cameron's 1997 film Titanic, for a planned release in 1999,[16] but according to Cameron, the necessary technology was not yet available to achieve his vision of the film.[17] Work on the language of the film's extraterrestrial beings began in summer 2005, and Cameron began developing the screenplay and fictional universe in early 2006.[18][19] Avatar was officially budgeted at $237 million.[5] Other estimates put the cost between $280 million and $310 million for production and at $150 million for promotion.[20][21][22] The film made extensive use of cutting edge motion capture filming...

Words: 466 - Pages: 2

Free Essay

Journalism

...JRL CH 3 Extra Slide Info I. Conglomeration Consequences a. Oligopoly - a concentration of media industries into an ever smaller number of companies b. More safe choices: i. Copycat TV (ace of cakes, cake boss, cupcake wars) ii. Sequels to proven hits (rocky 1,2,3,4,5…) iii. Battleship: The Movie c. Availability: Wal-Mart only wants to carry top 2% of new releases. d. Are the Consequnces all Bad? iv. In 2009, Disney bought Marvel Comics v. As of fall 2012, Disney owns Star Wars – first sequel due for 2015 vi. Defenses: 1. Consolidation is realistic in a FRAGMENTED world 2. Economies of Scale: bigger operations have a lower relative cost vii. Criticisms: 3. Focus on the bottom line over quality 4. Conflicts of interest viii. News consequences: less coverage of congress, Washington, pentagon, world II. Media Behavior is Changing e. Day-and-date release: Many movies are released to multiple formats (theater, DVD, on-demand and download) on the same day f. Multiple platforms g. Theater attendance has fallen since 2002 h. Music sales are down by half since 1999 i. Newspapers are declining; DVD sales are flat III. Audience Fragmentation j. While media consolidates, its audiences are becoming more narrowly defined (fragmenting) k. Once, you ix. Read a newspaper ...

Words: 298 - Pages: 2

Premium Essay

Arundel : Options Case

...Arundel Partners – The Sequels Project After evaluation of the proposed acquisition of the movie sequel rights, we recommend to offer movie studios as a per-movie price to purchase the sequel rights for their entire portfolio of movies the studios are going to produce over the next year.  Arundel should make an offer to buy sequel rights as the average NPV (on a per film basis ) is $5.51 mn (this is the value calculated using real options method). Hence, we should pay a price below $5.51mn. As per informal inquiries made by us, the studios would be tempted to accept the price of $2mn or more and would not even consider a price below $1mn. We propose that we should negotiate for the price of $2mn. This would give us a profit of $3.51 mn per film. The movie studio might (or might not) be willing to sell these rights at this price because it helps the studios mitigate the risk associated with producing the sequel. Also, the fact that there is no liquid market for rights to produce sequels will also drive the price lower on account of lack of demand. Average value of Sequel rights per film using DCF Analysis Average value of sequel rights per film across all studios 1. There are 99 films in the portfolio. Arundel Partners will only produce films for which hypothetical NPV is greater than zero. Hence, we calculate NPV of each film at Year 0. Since the exhibits state that the values are already preset values, we have not rediscounted them. NPV (At year 0)...

Words: 1681 - Pages: 7

Free Essay

Arundel Partners

...Arundel Partners: The Sequel Project Question 1: Arundel Partners thinks they can make money by buying the rights to sequels because of the possible arbitrage opportunity between the price they would pay for an option to sequels and the sequels’ real value. Therefore, valuing the option correctly takes great importance. The partners want to buy a portfolio of rights in advance rather than negotiating film-by-film to buy them because it is of critical importance to Arundel that a number of films and a price per film are agreed upon before either Arundel or the studio knows which films would generate the option of a sequel. If not, once production starts the studio would inevitably have more information on the likeliness that a sequel would be possible. This would put Arundel at a disadvantage, because they would then have to negotiate the price for sequel rights on each film produced while knowing much less than the production studio about the film. For example, if the studio knew that obtaining the rights for the literary work the first movie is based upon took a lot of haggling and work, and that the script has gone through fifteen revisions with six different writers, then the studio may be keen to get rid of the sequel rights. While a film’s profitability is always a gamble, there are often early signs such as these that a movie is going to be a jumbled mess that cost the studio way too much money to produce in the first place. These films tend to do...

Words: 1483 - Pages: 6

Premium Essay

Rejdkal

...one reason for them to buy the rights to create sequels would be to exploit a possible arbitrage in between the price they would pay for an option to sequels and its real value. Therefore valuing the said option correctly is of the most importance. 1.2 We believe that portfolio negotiation rather than on a film-by-film basis will level the playing field. Since the partners do not have experience in the movie making industry and those on the other side of the negotiating table do, it would be easier for the movie industry executive to figure out which movie would be a hit and which would be a miss and try to sell Arundel the rights to only those movies that will not be followed by a successful sequel. 2.1 NPV calculation. According to the Exhibit 4, based on 14 pairs of first films and their first sequels, average sequel negative cost as a percentage of first film negative cost was 120%. Also according to the same exhibit based on 61 pairs of first films and their first sequels average sequel rental revenue as a percentage of first film rental revenue was 70%. If we assume that Exhibit 7 represents “the universe” of films available for analysis then data from Exhibit 8 can be used to calculate what percentage of movies has been followed by a profitable sequel. According to the said exhibit 26 sequels achieved one-year return of 0.2 or higher. Therefore we can assume that the same number of movies was followed by a profitable sequel, i.e. 26. Since Arundel will have an option to...

Words: 369 - Pages: 2

Premium Essay

Identity

... a) Why do the principals of Arundel Partners think they can make money buying movie sequel rights? The principle point is that they want to buy the rights of movies that can become, if successful sequels. When successful they can choose to produce the movie by themselves or to sell to the highest bidder (other production companies). When the first movie is successful the initial investment for the right is easily covered by the potential benefit of the (potential) sequels. As explained in the case, Arundel will notice the success or failure of a movie investment after the first few weeks of exhibition. b) Why do the partners want to buy a portfolio of rights in advance rather than negotiating film-by-film to buy them? Arundel want to buy a portfolio of right in advance rather than negotiating film-by-film because before production nobody has enough information about the potential of the movie. When the production has started, the movie studios have more information than Arundel. Then, they (movie studios) can already see the potential of a sequel or not. This is an example of asymmetry of information that could have implication on the bargaining power of Arundel. In addition, by buying a broad portfolio of sequel rights Arundel diversifies its risks (more than 30 investments could eliminate the specific risk). Moreover by buying purchasing a broad portfolio of sequel rights, Arundel is increasing its probability of having a highly successful investment and...

Words: 551 - Pages: 3

Premium Essay

13,1977,21

...In Jonathan Lethem's personal narrative essay "13,1977,21, " Lethem reflects on when he was 13 years old, in the year 1977 where he watched the film Star Wars 21 times. However, the essay is not actually talking about the Star Wars film. It is about how Lethem used going to the movies to remove himself or hide from the real life such as his mother's illness and the recent divorce of his parents.  The essay is very informal. Lethem uses sarcasm, curses, witty comments and references to pop culture in his text. The witty tone and cleverness are good, but it probably wouldn't appeal to a more formal and professional reader. The tone could be described as witty but also nostalgic. With reflecting on his trips to the movie theater along, Lethem reflects on his awkward preteen years, which it was speculated by his parents whom he was a boy.  As I think, Lethem numbered each paragraph to go alone with the significant of numbers in his essay. For example, the title of essay "13,1977,21" begins to make sense once he introduces the events of 1977, where he watched a film 21 times at the age of 13. These numbers are very meaningful. Lethem's 21 trips to the movie theater to see Star Wars was not entirely his fascination with or like the movie. He used plaza as a hiding place from the gradual loss of his mother to the brain tumor and already absent father. Watching the film many times in the summer of 1977 can help him to copy with his teenage struggles....

Words: 269 - Pages: 2

Premium Essay

Response to "13, 1977, 21" by Jonathan Lethem

...Alyssa M. Gonzalez “13, 1977, 21” In Jonathan Lethem’s personal narrative essay, “13, 1977, 21”, Lethem reflects on when he was 13 years old, in the year 1977, where he watched the film Star Wars 21 times. But the essay is not actually about the Star Wars film. It is about the way Lethem used going to the movies to remove himself, or “hide” from the realities of his life, such as his mother’s illness and awkward pre-teenage years. The first few sentences of Lethem’s essay is where he blatantly tells the readers that he’s watched Star Wars twenty-one times in four months. He then uses the next three paragraphs to reflect on the circumstances surrounding his trips to the movie theater in the summer of 1977 and trying to understand what triggered him to go all twenty-one times. He describes the theater he watched the film in, down to the street in Manhattan it was on, and the interior of the theatre, that he explains was “a superior place to watch anything”. He also mentions that getting into the theater itself was “an accomplishment, both elevating and slightly dangerous”. He describes the popularity of the film at the time, where he says “any kid with a television had brought a single ticket for the same film in a single summer”, but emphasizes that he was a part of the small percent that turned watching the film into a full blown obsession. In the second paragraph, Lethem questions why he even went all twenty-one times. He writes: “But what actually occurred...

Words: 635 - Pages: 3

Premium Essay

My Film Experience

...Maureen Jacob ID # 14231227 Mej44f@mail.missouri.edu Film Studies 1800: Intro to Film Studies Question 1- Ever Since I was young I have enjoyed watching movies. I am the youngest of four kids, and that definitely affected my film watching experience as a kid; I always had to watch the movies my siblings wanted to watch, because of course the youngest, or at least me, did not have much say in those types of things. Although, at that point in my life I didn’t like being able to choose movies, now I realize it opened my eyes to a lot of different types of movies, even older films, since my oldest sibling is 10 years older than me. I have always been a huge fan of Disney and Pixar movies and still watch them today, when I’m bored or need some cheering up. I think that Toy Story is my favorite. I like the idea of channeling your inner kid and just being able to have some fun through your film watching experience. I also find myself looking in the Romantic Comedy section most often on Netflix. I like the balance of love and laughs. When I was young, my sisters introduced me to Sleepless in Seattle, and it is probably one of those movies I can watch time and time again. I like drama as well, I can honestly say that The Titanic is in my top five favorite movies, but that can also do with the fact that I love Leonardo Dicaprio. As you can see I like a very wide range of movies. I am not really to big of a sci-fi person and have never had interest in watching Star Wars, which...

Words: 1241 - Pages: 5

Premium Essay

Edward Scissorhands Sequel

...Those who loved the classic film "Edward Scissorhands" played by Johnny Depp have probably always wondered if that movie will ever have a sequel or a remake. IB Times reported about Tim Burton's thoughts of a sequel regarding one of his masterpieces and unfortunately, his answer is a no. The 57-year-old director told Entertainment Weekly about his experience with Edward Scissorhands 25 years ago. And when he was asked if he is thinking of a sequel, he compared the idea to revisiting a nightmare. He thinks that there are certain things and projects that are meant to happen just once after they have been released the first time. In Burton's own words, "For me, they're very singular things, and I think -- yeah, some things, I easily get why...

Words: 289 - Pages: 2