COM4015 Introduction to Databases COM4015 Evaluation Transient Module title: Introduction to Databases Module code: COM4015 Project title: Database Construct & Development Project structure: Characterize/Database Observe/closing date: 3000 words linked File kind Docx/pdf file (zip files is per chance no longer licensed) Percentage of final grade This task is worth 100% of your final grade for this module. Submission minimize-off date Ogle module iLearn internet page for date of submission Grade open You’ll be in a position to in overall receive your provisional grade and suggestions within 20 working days of the submission minimize-off date Studying Outcomes By ending this evaluate, you should per chance well non-public shown and be assessed on all four of the educational outcomes:
- Present off a knowledge and thought of databases and files management programs.
- Perceive key principles of relational database construct
- Apply files and thought of database pattern to construct and put in power, a relational database resolution.
- Discipline Abilities: Files and thought of chosen field. Possess a unfold of talents to way within this sector, non-public a interesting consciousness of unique inclinations in working put collectively being well positioned to answer to change
Assignment Summary You’ve got been assigned as a database developer to compose a database construct for the loans machine at Lantern Library. You’ve got also been tasked to place in power the Lantern events reservation Database.
Assignment 1: Propose the construct of a relational database for Lantern loans machine Assignment 2: Enforce the database for Lantern events reserving machine. Assignment 3: Take a look at the implementation of the Lantern events reserving database. Please be obvious to make enlighten of your college-distributed database myth to answer the questions of Assignment 2 and 3, otherwise, your task work is no longer going to receive any marks for the responsibilities.
Present execution screenshots in the portray evidencing every step of your work, in addition to text-primarily based completely completely copies of any SQL. Also, be sure that your username is incorporated in all the screenshots of the database execution proof to study it is your work.
Assignment 1: Lantern Loan System Database Construct Lantern library is a mid-sized library that provides a in fact perfect quantity of products and companies to the native group of workers. Clients can loan books, journals, magazines, DVD’s and Vinyl data. The library works with assorted libraries to present inter library loans
A member wants in enlighten to make a loan for any preference of issues at one time. To make a loan contributors rob items to a crew member who checks the items proper into a loans database. The library would adore the database to be accessible via a internet application and would adore any items to be categorised. The library would also desire to retain data of publishers who they aquire books from. Participants will be charged fines for books that rush previous their due date which needs to be recorded.
To pork up their library operations the head librarian would adore you construct a database which is interesting to streamline the loans machine at Lantern.
a. Logical Model
In maintaining with the scenario, compose a logical model for the database the usage of a crow’s foot kind Entity-Relationship Intention (e.g., Barker/UML, attain NOT enlighten the Chen diagramming kind).
Manufacture obvious to normalise the guidelines to 3NF, adding keys and identifier columns as acceptable. Annotations for the normalisation job are required to present that all the entities are in 3NF. Manufacture obvious to show any assumptions made along with their causes.
b. Bodily Model
Using your logical model as a basis, compose a bodily model Entity-Relationship draw the usage of crow’s foot notation for the Lantern loans relational database. Manufacture obvious to make enlighten of acceptable naming conventions and to identify files kinds, keys, and constraints. Present off any assumptions made or extra changes to the pattern beyond those in the logical model.
Assignment 1: (900 Phrases linked) (30 Marks) (LOs: 2,4)
Assignment 2: Create The Lantern Events Reserving Relational Database Lantern library is rolling out a machine to control events reserving in the library premises. The machine tracks the kind of match, rooms, match bookings, and funds. To abet budgeting and evaluation, every match is labeled and costed.
The head librarian has as of late licensed the construct of the events reserving System, which is given as the bodily model Entity Relationship draw in the resolve 1. To pork up the management of events reserving, the head librarian would adore you to compose this relational database and present its performance.
a. In maintaining with Figure 1. Lantern events reserving machine bodily model entityrelationship draw, compose the database the usage of acceptable SQL in the database myth offered by Arden College.
Figure 1. Lantern Events Reserving System bodily model entity-relationship draw
b. Insert 12 Events in the Events desk the usage of the sample files in Desk 1 below.
Match kind descriptions from desk 1 needs to be ragged in the EventType desk and the international key linked encourage to the Match desk. Insert 6 contributors, 6 rooms, 6 room funds, 6 suggestions, 6 match bookings and 6 crew. Please encompass indispensable data for all tables. The given preference of data are the minimum requirements for the database, you should per chance well per chance be allowed so that you can add extra files as required. Increased portions of linked and lawful files will receive better marks. Please consult marking matrix for extra tiny print on preference of data and sorts of files. The reserving enviornment in the EventBooking desk need to soundless non-public the values Confirmed, Cancelled and Waitlisted. Ratings for the member suggestions needs to be between 1 and 5. Match Identify Match Form Ticket Price Creator Talk: Ancient Fiction Talk £6 Kids’s Storytime Studying Session £10 Native Ancient previous Lecture Talk £4 Poetry Open Mic Evening Performance £2.50 Digital Literacy Workshop Workshop £5 Teen Manga Club Club £2 Inventive Writing Bootcamp Workshop £15 E book Originate: “Voices of the North” Talk £4 Household Studying Picnic Community Match £15 Coding for Newcomers Workshop £6 Movie Screening: Classic British Cinema
Screening £10 Adult E book Club: Crime Fiction Club £5 Resume & Job Search Aid Tumble-in Session £2 Native Creator Showcase Exhibition £3 Mindfulness & Meditation Hour Wellness Session £4 Library Anniversary Derive collectively Community Match £10 Sci-fi Original Dialogue Team Club £5 Environmental Consciousness Talk Seminar £4 Language Exchange Meetup Community Match £4 Art work in the Library: Native Artists Exhibition £8 Desk 1: Lantern Events Desk
c. Present off all the tables with the plenty of inserted files.
Assignment 2: (1200 words linked) (40 marks) (LOs: 3,4)
Assignment 3: Take a look at Implementation Of Lantern Events Reserving Database Using the Lantern events reserving database from Assignment 2, provide solutions to the next four misfortune conditions in the create of SQL code and a transient rationalization of your reasoning. Contain screenshots of SQL queries execution and its outcomes along along with your schema, evidencing this in every of the conditions talked about below. Manufacture certain your schema or username is incorporated in every screenshot to study it is your code.
Case 1
List the rooms booked for every practising match exhibiting the room title, the match title and the match date.
Case 2
To uncover the effectivity of browsing to the head librarian, compose searches per the criteria talked about below.
a. Web all the events in the database sorted by match kind. Present off the match title, match date and match kind description.
b. Web events per cost. For instance, events with designate cost no longer up to £5.
Case 3
The events that Lantern Library provides non-public modified. Write the queries to mediate these changes in inventory. Please present screenshots of database data sooner than and after to present changes in the tell of the database.
a. The Household Studying Picnic has been renamed Community Studying Picnic and the designate mark has been modified to 20 pounds. Update the database accordingly.
b. The Native Ancient previous Lecture will no longer be working. Rob away the Native Ancient previous Lecture account to mediate this.
Case 4
Write queries to compose the next operations.
a. Web the preference of bookings for every match kind exhibiting the most traditional to least standard. Present off the match kind description and the preference of bookings.
b. Web the volume of cash made for every match from bookings made. Present off the match title and quantity of cash product of bookings. Present off the earnings in descending enlighten. Earnings will most effective be on bookings that had been confirmed.
c. Web the general quantity of doable earnings for every of the rooms which had been booked. Present off the room title and the volume of doable earnings for that room.
Assignment 3: (900 words linked) (30 marks) (LOs: 1,4)
- 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.
