Ask 1 (33 marks) A video streaming company wishes to provide a boost to its recent commerce model by providing different subscription kinds to its customers. Each and each subscription sort will keep on hand movies from one or extra production houses e.g., subscription sort named A1, launched in the 300 and sixty five days 2020 lets in customers to stare movies from Normal Pictures and Paramount, and subscription sort named A2 launched in the 300 and sixty five days 2021 lets in customers to stare movies from Paramount, Frontier Pictures and Nationwide Geographic Studios. Each and each production home has a fame and nation that it’s some distance incorporated in. A customer begins by opening an story. Fable crucial aspects consist of an story quantity, the buyer name, address and a balance which is spellbinding to be topped up. After story creation, the buyer can decide subscription kinds and intervals he wishes to subscribe e.g., A1 for 30 days and A2 for 180 days. Each and each subscription is paid the usage of the story balance. The subscription rate is reckoning on the subscription sort moreover the subscription duration. There is rarely any restrict to the gathering of films a customer can movement all the device throughout the subscription length. Videos crucial aspects consist of a video code, a title, description, a video length (in minutes) and language outdated. A movie video choices a mode whereas a documentary contains the name of the producer. The application lets in customers to add feedback and to rate movies they personal got watched. Customer can additionally keep buddy requests. If a buddy request is authorized, the requester can stare his buddy’s rankings and feedback which might perhaps well be marked public. Interior most feedback and rankings can’t be considered by pals even supposing pals requests are authorized. The application tracks every video streaming similar to where a customer stops so that the buyer can resume gazing from that level. The viewing patterns of customers are additionally tracked e.g., the originate and cease aspects of a video movement, the playing trudge and the language of the subtitle if outdated. The application offers APIs for production houses to extract recordsdata for their titles to stare the viewing patterns. Intention a conceptual (ER) model from the statements of requirements to symbolize the guidelines model, showing entities, with entities name, relevant attributes and identifier (14 marks) relationships with most and minimum cardinalities and relationship name (19 marks) Express your assumption(s) for easiest recordsdata requirements which might perhaps well be no longer specified. Ticket your model as ONE design. Write My Project Hire a Genuine Essay & Project Author for finishing your Tutorial Assessments Native Singapore Writers Crew 100% Plagiarism-Free Essay Highest Pleasure Rate Free Revision On-Time Offer Ask 2 (34 marks) You is possibly given the following table: MoviePayment (movieTitle, movieDescription, yearProduced, directorName, directorNationality, directorDOB, actorName, actorNationality, actorDOB, contractFee, roleplayed) An actor can compose in one or extra movies, and a movie might perhaps require one or extra actors. An actor can play loads of roles in a movie e.g. Robin Williams performed the roles of Daniel Hillard and Mrs. Euphegenia Doubtfire in the movie Mrs. Doubtfire. In some cases, a purpose within a movie can additionally be performed by loads of actors e.g., John Travolta and Nicolas Cage performed the purpose of Sean Archer in Face/Off. Each and each actor in a movie has one contract rate for the movie, no subject whether or no longer he has a single purpose or loads of roles. An actor can play the the same purpose in loads of films e.g., Tom Holland performs Peter Parker in movies similar to A long way From Dwelling, No Manner Dwelling and Price Fresh Day. In fact, different actors can play the the same purpose in numerous movie e.g., Andrew Garfield performed Peter Parker in movie The Fabulous Spider-Man. You might perhaps perhaps possibly deem that there’s one director per movie, a movie is identified by a movie title, a director is identified by the director name, and an actor is identified by the actor name. Ask 2a Formulate and list the functional and multi-valued dependencies (MVD). Intention no longer introduce any recent columns no longer in the given table. Express your assumption(s) for easiest recordsdata requirements which might perhaps well be no longer specified. (8 marks) Ask 2b Design dependency graph and suggest candidate key(s) for the table. Ticket composite keys in brackets. (4 marks) Ask 2c (i) For every MVD on your answer to Q2(a), insist why it’s some distance subsumed or no longer subsumed. (ii) Normalise the table to Boyce Codd Same outdated Compose (BCNF) and Fourth Same outdated Compose (4NF) following the steps lined in the module. (fixed with pupil answer whether or no longer MVD is no longer subsumed, teach course of) (iii) Ticket how you teach the steps to attain at the tables, insist whether or no longer the structure of every derived table at every iteration is already in BCNF and 4NF (if appropriate). (12 marks) Ask Second Assemble your BCNF and 4NF tables and constraints clearly by giving every table and the referential integrity constraint(s), if any, in the categories described below: Tables in this keep: TABLE-NAME(col-name1, col-name2, …, col-namen) • insist (PK) in opposition to the predominant key and • insist (FK) in opposition to the international keys, if any. Referential integrity constraint(s), if any, along with the baby table in this keep: TABLE-NAMEx.col-namex1 …col-namexn need to exist in TABLE-NAMEy.col-namey1…col-nameyn (10 marks) Purchase Personalized Solution of This Overview & Elevate Your Grades Safe A Free Quote Ask 3 (33 marks) All SQL statements for this quiz (manufacture, insert and decide statements) MUST be in text format. You MUST additionally paste the screenshots of the cease consequence of executing all of your SQL statements. Ask 3a (i) Remodel the ERD in Pick Q3(a)(i) staunch into a logical model, giving every table and the referential integrity constraint(s), if any, in the categories described below: Tables in this keep: TABLE-NAME(col-name1, col-name2, …, col-namen) • insist (PK) in opposition to the predominant key and • insist (FK) in opposition to the international keys, if any. Referential integrity constraint(s), if any, along with the baby table in this keep: TABLE-NAMEx.col-namex1 …col-namexn need to exist in TABLE-NAMEy.col-namey1…col-nameyn (ii) Consult with the description of the columns for the column definition, and then write the particular SQL statements to enforce ALL tables, derived from the transformation of the ERD in Pick Q3(a)(i) in section (i). Checklist your SQL manufacture statements in the insist that they needs to be completed. Description for columns: productionId is a whole quantity starting from 1 with step increment 1 and is auto-generated. title is at most 120 persona long. style is strictly 10 characters, either science, crime, historical, nature or society. startDate and completionDate of production, both are dates and where completionDate is later than startDate. budget is less than 100 million greenbacks and is at the least 1000 greenbacks. Funds might perhaps consist of cents. runningNumber is a whole quantity. expeditureDate is datetime and has the default rate which is the recent date. amount might perhaps consist of cents, is non-zero, no-adversarial and no longer extra than 50000. description is at most 128 persona long. class code is strictly 4 characters, initiating with 2 letters adopted by 2 digits. categoryName is at most 30 characters long. mainCategory is at most 30 characters long. Constraints: Consult with Pick Q3(a)(i) for the minimum and most cardinalities. • incurs relationship – delete and replace disallowed. • isFrom relationship – delete disallowed and replace cascade. (iii) Hiss the guidelines in Pick Q3(a)(iii) to populate the tables implemented in section (ii). Checklist your SQL insert statements in the insist that they needs to be completed. Ask 3b For section (b), use the tables you personal created primarily based fully on Pick Q3(a)(i). You is possibly no longer allowed to manufacture stare, nonetheless it’s possible you’ll perhaps well clarify inline views where appropriate. Formulate SQL queries to display camouflage the given consequence objects: Details of productions about nature and with title that choices island. Details of completed production and the gathering of days to total the production. Details of productions and whether or no longer budget is exceeded or insist that project is mild ongoing. Checklist in ascending insist of the distinction between the budget and total spent. Consult with https://www.w3schools.com/sql/sql_case.asp on teach the case expression. The gathering of productions completed and ongoing for genres with productions. The gathering of completed productions every style has, the total budget and the total spent for the style, in descending insist of the gathering of productions and the total budget. Details of productions whose expenditure contains the teachings PP03 and PP04. Details of production with the supreme collection of LO03 expenditure. Embody additionally the total amount use on LO03. Intention NOT deem that there’s one row in the resultset. (23 marks) —– END OF ASSIGNMENT —– Caught with a whole lot of homework assignments and feeling wired ? Rob official academic support & Safe 100% Plagiarism free papers Safe A Free Quote
- WE OFFER THE BEST CUSTOM PAPER WRITING SERVICES. WE HAVE DONE THIS QUESTION BEFORE, WE CAN ALSO DO IT FOR YOU.
- Assignment status: Already Solved By Our Experts
- (USA, AUS, UK & CA PhD. Writers)
- CLICK HERE TO GET A PROFESSIONAL WRITER TO WORK ON THIS PAPER AND OTHER SIMILAR PAPERS, GET A NON PLAGIARIZED PAPER FROM OUR EXPERTS
QUALITY: 100% ORIGINAL PAPER – NO ChatGPT.NO PLAGIARISM – CUSTOM PAPER
Looking for unparalleled custom paper writing services? Our team of experienced professionals at AcademicWritersBay.com is here to provide you with top-notch assistance that caters to your unique needs.
We understand the importance of producing original, high-quality papers that reflect your personal voice and meet the rigorous standards of academia. That’s why we assure you that our work is completely plagiarism-free—we craft bespoke solutions tailored exclusively for you.
Why Choose AcademicWritersBay.com?
- Our papers are 100% original, custom-written from scratch.
- We’re here to support you around the clock, any day of the year.
- You’ll find our prices competitive and reasonable.
- We handle papers across all subjects, regardless of urgency or difficulty.
- Need a paper urgently? We can deliver within 6 hours!
- Relax with our on-time delivery commitment.
- We offer money-back and privacy guarantees to ensure your satisfaction and confidentiality.
- Benefit from unlimited amendments upon request to get the paper you envisioned.
- We pledge our dedication to meeting your expectations and achieving the grade you deserve.
Our Process: Getting started with us is as simple as can be. Here’s how to do it:
- Click on the “Place Your Order” tab at the top or the “Order Now” button at the bottom. You’ll be directed to our order form.
- Provide the specifics of your paper in the “PAPER DETAILS” section.
- Select your academic level, the deadline, and the required number of pages.
- Click on “CREATE ACCOUNT & SIGN IN” to provide your registration details, then “PROCEED TO CHECKOUT.”
- Follow the simple payment instructions and soon, our writers will be hard at work on your paper.
AcademicWritersBay.com is dedicated to expediting the writing process without compromising on quality. Our roster of writers boasts individuals with advanced degrees—Masters and PhDs—in a myriad of disciplines, ensuring that no matter the complexity or field of your assignment, we have the expertise to tackle it with finesse. Our quick turnover doesn’t mean rushed work; it means efficiency and priority handling, ensuring your deadlines are met with the excellence your academics demand.
