can you normalise this table? CustomerQuantity FilmRental Date FilmNameEmailds@gmail.com 12/09/2019 Gamer1ds@gmail.com12/09/2019 Dark2Watersds@gmail.com 12/09/2019 Inception 3rw@gmail.com 05/01/2020 A Space1Odysseyjs@gmail.com 26/08/2020Dark1Watersjs@gmail.com26/08/2020 Taxi2Driverjs@gmail.com 26/08/2020 The Dark 2KnightForrest 1Gump18/03/2020 Dark1Waters18/03/2020 Gamer 3Rental Customer CustomerIDIDName2594456123DanielSmith2594456123DanielSmith2594 456123 DanielSmith3412 827162 RogerWilliams8972198256Jon Snow8972 198256 Jon Snow8972198256Jon Snow8972 198256 Jon Snow js@gmail.com 26/08/20205119 049821 Angelaaj@gmail.comJones5119 049821Angelaaj@gmail.comJonesTotalPrice Price£3.2 £23.1£2.6 £23.1£4.9£23.1£2.1£2.1£2.6£17.3£1.9£17.3£3.5£17.3£3.9£17.3£2.6£12.2£3.2£12.2

Task : Given the table. The task is to normalize the table.

Rental Date Film Quantity Film Rental Customer Customer Customer Name Email ID ID Name ds@gmail.com 12/09/2019 Gamer 1 2594 456123 Daniel Smith 2594 456123 Daniel ds@gmail.com 12/09/2019 Dark 2 Smith Waters 2594 456123 Daniel ds@gmail.com 12/09/2019 Inception 3 Smith 3412 827162 Roger rw@gmail.com 05/01/2020 A Space 1 Williams Odyssey 8972 198256 Jon Snow js@gmail.com 26/08/2020 Dark 1 Waters 8972 198256 Jon Snow js@gmail.com 26/08/2020 Taxi 2 Driver 8972 198256 Jon Snow js@gmail.com 26/08/2020 The Dark 2 Knight 26/08/2020 Forrest 1 8972 198256 Jon Snow js@gmail.com Gump 5119 049821 Angela aj@gmail.com 18/03/2020 Dark 1 Jones Waters 5119 049821 Angela aj@gmail.com 18/03/2020 Gamer 3 Jones Total Price Price £3.2 £23.1 £2.6 £23.1 £4.9 £23.1 £2.1 £2.1 £2.6 £17.3 £1.9 £17.3 £3.5 £17.3 £3.9 £17.3 £2.6 £12.2 £3.2 £12.2

Rental Date Film Quantity Film Rental Customer Customer Customer Name Email ID ID Name ds@gmail.com 12/09/2019 Gamer 1 2594 456123 Daniel Smith 2594 456123 Daniel ds@gmail.com 12/09/2019 Dark 2 Smith Waters 2594 456123 Daniel ds@gmail.com 12/09/2019 Inception 3 Smith 3412 827162 Roger rw@gmail.com 05/01/2020 A Space 1 Williams Odyssey 8972 198256 Jon Snow js@gmail.com 26/08/2020 Dark 1 Waters 8972 198256 Jon Snow js@gmail.com 26/08/2020 Taxi 2 Driver 8972 198256 Jon Snow js@gmail.com 26/08/2020 The Dark 2 Knight 26/08/2020 Forrest 1 8972 198256 Jon Snow js@gmail.com Gump 5119 049821 Angela aj@gmail.com 18/03/2020 Dark 1 Jones Waters 5119 049821 Angela aj@gmail.com 18/03/2020 Gamer 3 Jones Total Price Price £3.2 £23.1 £2.6 £23.1 £4.9 £23.1 £2.1 £2.1 £2.6 £17.3 £1.9 £17.3 £3.5 £17.3 £3.9 £17.3 £2.6 £12.2 £3.2 £12.2

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter11: User Interfaces, Visual Basic For Applications (vba), And Collaboration Features

Section: Chapter Questions

Problem 15AYK

See similar textbooks

Similar questions

View the clip below. What is the title of the game and who was the designer and manufacturer? What characteristics make the game unique? Why is this game significant in the history of video games? https://nv.instructuremedia.com/fetch/QkFoYkIxc0hhUVNGeFpnQk1Hd3JCeXZvRFdFPS0tMWE1OGM0OTQ0YzY0ZWRlYmFiZTBjMzkxNjIzMDU4OGY1OTE0ZWUzYw.mp4
Designing a full web page, on the home page, cards are displayed to display information about products (for example, Apple devices), each card contains a picture of the device and a simple overview of it, and when you press the card, move to a new page containing all the details of this device, and also a button to go back to the main page to see the other cards. Cards must be interactive when you hover the cursor on them, showing some effects such as image resizing or something like that. The number of cards must not be less than 5 cards
Visit the following webpage: https://archive.org/details/National_Geographic_Wallpapers This webpage hosts a collection of 506 images from National Geographic Magazine with most of these images previously being part of an international photography contest. Your task is to randomly choose 5 images and identify the objects within those images using Google’s vision API. Submit your iPython notebook code, and screenshots of output as shown below. You may need to reactivate your Google vision API account (or billing information for trial cycles) if you haven’t used it recently. Here is the sample code import base64 import urllib import os import io import PIL from IPython.display import display, Image GOOGLE_API_KEY = '' #Use your Google API key here pip install google-api-python-client from googleapiclient.discovery import build service = build('vision', 'v1', developerKey=GOOGLE_API_KEY) cat = 'C:\\Users\\Instagram and neural networks\\cat.jpg' def label_image(path=None, URL=None,…
totalEvens totalEvens . valuels MTE BITP 1113 Programming Technique - Word A ahmed garcad AG File Home Insert Draw Design Layout References Mailings Review View Help Acrobat O Tell me what you want to do & Share E Align - Group HBreaks - Spacing Indent D Line Numbers E Left: 0 cm 1 Before: 0 pt Margins Orientation Size Columns Position Wrap Send Selection bề Hyphenation - Bring Text v Forward v Backward E Right: 0 cm After: 8 pt Pane A Rotate Page Setup Paragraph Arrange d. Your best friend needs help with the C++ programming. She wants to develop a program that can produce the output as illustrated in Figure 3.2. Unfortunately, her program as shown in Figure 3.3 has given TWELVE (12) errors during the compilation and now you are trying to figure out what is wrong with the program. Based on the scenario, identify the errors. List down the lines of the code that contain errors and write the correct ones. Use TABLE 3.1 to write down your answer. Please enter 20 integers The numbers you…
MTE BITP 1113 Programming Technique - Word A ahmed garcad AG File Home Insert Draw Design Layout Acrobat O Tell me what you want to do & Share References Mailings Review View Help HBreaks - E Align - Spacing 1t Before: 0 pt Indent DLine Numbers E Left: 0 cm Group Position Wrap Send Bring Text Forward - Backward Margins Orientation Size Columns Selection bề Hyphenation E Right: 0 cm = After: 0 pt Pane Rotate Page Setup Paragraph Arrange a. Write C++ statement to declare a variable named START with its initial value 23.5 b. Write the following formula in C++ language V = 9a+(3b)'-4a c. Refer to the C++ program in Figure 1.1, and answer Question lc (i) - (xi). #include #include #define border 146 using namespace std; int main () { double radius1,volume1, radius2, volume2; double Totalvolume = 0; const double PI = 3.14; char grade; Totalvolume++; cin >> radius1 >> radius2; volumel=4.0/3*PI*pow(radius1,3); Totalvolume += volume1; Volume2=4 0/3*PT*now(radius2 31. Page 2 of 11 949 words DE…
MTE BITP 1113 Programming Technique - Word A ahmed garcad AG File Home Insert Draw Design Layout References Mailings Review View Help Acrobat O Tell me what you want to do & Share 'Paragraph Spacing - A O Effects Aa TITLE Title Title Title TITLE Title Title Title Title TITLE TTLE He HE 1 Hnc Headio Heading! Heading1 HEADING ! Headine Heading1 Themes Colors Fonts Watermark Page Page O Set as Default Color v Borders Document Formatting Page Background c. Write a complete program that can displays output as shown in the samples in Figure 2.1 The program will prompt the user for two (2) integer numbers. Then, the program will display a calculator menu and prompt the user to enter his choice. If the user enters 1 / 2 / 3, the program will perform the calculation according to the choice, display the result of the calculation and end the program. If the user enters 4, the program will display "Exit" and ends. An error message "Invalid input" will be displayed if the user enters a number…
When we submit the form, where will it send the form data for processing? @model HelloWorldMVC.Models.AppMessage Hello World App @Model. Message @ViewBag.Message Enter Message : Submit
Part B: Website DevelopmentThis project will give you ample opportunity to showcase your creative skills. The website projectcontains a set of webpages written in HTML and CSS. The website highlights the most importantfeatures of Abu Dhabi city and the UAE. The website contains images of areas, photographs ofthe most prominent leaders, and key milestones. The website project can be summarized as below:-- Create a main page that has the flag of UAE, important information about the UAE, anda menu with labels as {leaders, areas, universities, contact us}.- The leader page contains photos of leaders and some information for each one.- The areas page contains the name of seven areas in UAE and some information for eachone as well as some of the photos of key milestones for each one.- The universities page contains the name of the universities in UAE with some informationfor each one. You can add some photos and the URL link of each university.- Create a dummy contact us page with a form to…
Intro/Homepage: This first case will be used to give the user the first look at what the whole project is about. They see the beginning stage and interact with all the links to the movies, characters, and descriptions. Browse MCU Shows: This case will be for the customers and users to be able to navigate through the feature and see what they are specifically. They can use it to find which exact Marvel Cinematic Universe movie/show they wish to watch and see what character they like. View MCU Movie Details: This case will be for users to get more information about specific Marvel movies/shows. It will give more details like the cast, the run time, the review score, the characters involved and etc. I need help making an ARCHITECTURAL DESIGN, DECOMPOSITION DESCRIPTION, DESIGN RATIONALE, and HUMAN INTERFACE DESIGN for the use cases above for a website I am making. Thank you.
html/css/ javascript 1.In this project, you will have to design a survey form that includes relevant questions like name, age, email, address, contact number, and other questions, depending on the type of company or organization you are shaping the form. You should brainstorm a survey idea and come up with at least 10 other fields for which to gather information in addition to the 5 mentioned. 2.Only up to 5 questions should be displayed on each page 3.• At least 2 of the questions should be conditional, meaning they will only be displayed dependent upon the responses to a previous question 4.When the survey ends, the user should receive a page or notification of this fact and direct them to another page. JavaScript elementso global variableso window.alert() method using onclick attributeo document.write methodo Conditional statement (if, case, etc)o Specifying 1 or more event handlers with the addEventListener() methodgetElementByID or getElementByTagName or getElementsByNameo…
Here are what to display on your Pokémon's show page: The pokemon's name The image of the pokemon An unordered list of the Pokemon's types (eg. water, poison, etc). The pokemon's stats for HP, ATTACK, and DEFENSE. Routes Your app should use RESTful routes: Index GET /pokemon Show GET /pokemon/:id New GET /pokemon/new Edit GET /pokemon/:id/edit Create POST /pokemon Update PUT /pokemon/:id Destroy DELETE /pokemon/:id This is the module.js file module.exports = [ { id: "001", name: "Bulbasaur", img: "http://img.pokemondb.net/artwork/bulbasaur.jpg", type: [ "Grass", "Poison" ], stats: { hp: "45", attack: "49", defense: "49", spattack: "65", spdefense: "65", speed: "45" }, moves: { level: [{ learnedat: "", name: "tackle", gen: "V" }, { learnedat: "3", name: "growl", gen: "V" }, { learnedat: "7", name: "leech seed", gen: "V" }, {…
For displaying your idea and thoughts for a presentation which view you will use in MS PowerPointSelect one:a. Slide Sorter Viewb. Slide sorter Viewc. Normal Viewd. Outline View