INTERNATIONAL SCHOOL OF MANAGEMENT AND TECHNOLOGY
NEPAL
FACULTY OF COMPUTING
|
Unit 4: Database Design & Development |
|||
|
UNIT CODE |
A/618/7400 |
LEVEL |
4 (Core) |
|
STUDENT NAME |
CREDIT VALUE |
15 |
|
|
ASSESSMENT TITLE |
Hotel Room Reservation System |
WORD COUNT |
|
|
ASSESSOR |
Rajad Shakya |
I.V. |
|
|
ASSIGNMENT ISSUE DATE |
March 07, 2025 |
ASSIGNMENT SUBMISSION DATE |
May 13, 2025 |
|
ORIGINAL SUBMISSION |
ASSIGNMENT NO. |
1/1 |
|
ASSESSMENT CRITERIA TO BE ASSESSED IN THIS ASSIGNMENT
(Identify all criteria to be assessed in this assignment)
|
Assignment Criteria |
P1 |
P2 |
P3 |
P4 |
P5 |
||||||
|
Achieved |
|||||||||||
|
Merit Criteria |
Distinction Criteria |
||||||||||
|
Assignment Criteria |
M1 |
M2 |
M3 |
M3 |
M4 |
M5 |
D1 |
D2 |
D3 |
||
|
Achieved |
|||||||||||
Important:
- Read the plagiarism notice and requirements at Page 6
- Word-limit- 8000 words (excludes cover page, table of content, figures, graphs, reference list, appendix and logbook)
- Accepted Sources: Research Papers (Journal Articles, Conference Proceedings, Thesis), Text Books, Governmental Data, Websites (only a registered organization, an educational institution, government agency)
- Information taken from unreliable sources will not be accepted
- Must follow Harvard Reference Style
- Assignment must be submitted through the Plagiarism Detection Tool
|
Assignment submission format |
|
Each student has to submit their assignment as guided in the assignment brief. The students are guided on what sort of information is to produce to meet the criteria targeted. You are required to make use of headings, paragraphs, and subsections as appropriate, and all work must be supported with research and referenced using the Harvard referencing system. |
|
Learning outcomes covered |
|
|
Scenario |
|
The “Hidden Paradise Hotel” is a new upcoming boutique hotel, located in a scenic location near Kathmandu. The management of the hotel has decided to implement a robust, secure hotel reservation system to use at the front desk. Whenever a new guest arrives at the hotel, the front desk staff look into the system for availability and reserve rooms for the guests as per their request. All the information of the guest (including name, contact number, duration of stay etc) is entered during check in. One guest may book more than one room, but a room can be booked under only one person’s name. The guest may request for additional services during their stay, including extra beds, food, airport pick up, sightseeing services etc. The total amount payable has to be calculated at the time of check out. The manager would require regular reports- weekly and monthly regarding occupancy and sales. Further he should be able to add/ edit rooms in the system. Your task is to conduct a thorough software investigation and prepare a DBMS for the system. |
ASSIGNMENT TASKS
|
Task |
|
Activity 1: Designing the Database as per the scenario Before you start the development process, you need to prepare a proposal document to be submitted to your manager. The document should contain: 1. The design of the relational database system using appropriate design tools and techniques. It should contain at least four interrelated tables. 2. Clear statements of user and system requirements. You would prefer to produce a more detailed document, so you will produce a comprehensive design for a fully functional system which will include interface and output designs, data validations and cover data normalization. Your manager would like a separate report on your assessment of the effectiveness of the design in relation to user and system requirements. Activity 2: Development and testing of the database system Create and fully implement the database system showing evidence of user interface, output and data validations and querying across multiple tables using a query language. The system must also be fully secure and maintainable. Include code snippets and screenshots of the system functionalities as evidence wherever required. For a higher grade: You would want to include more than just the basics so you will implement a fully functional database system which will include system security and database maintenance features. Further provide a detailed assessment of whether meaningful data has been extracted through the use of query tools to produce appropriate management information. and an evaluation of the effectiveness of the database solution in relation to user and system requirements, and suggest improvements. Further, Develop and action a test plan with effective tests that includes effective data, and extreme and erroneous data in order to build an accurate picture of the viability of the database Tests must assess the breadth and usability of the programme as well as the requirements in the brief Tests must include meaningful data and elements that would demonstrate a successful implementation Further Produce a written report: To assess the effectiveness of testing, including an explanation of the choice of the test data used. and evaluate the effectiveness of the database against user requirements and suggest improvements. 5) Produce a series of user videos and a detailed technical and user documentation:
For a higher grade, You would want to provide some graphical representations for ease of reference in the technical guide, so you need to produce technical and user documentation for a fully functional system, including diagrams showing movement of data through the system, and flowcharts describing how the system works. Lastly, Evaluate the effectiveness of the database solution in relation to user and system requirements, and suggest improvements. |
LEARNING OUTCOMES AND ASSESSMENT CRITERIA
|
Pass |
Merit |
Distinction |
|
LO1 Use an appropriate design tool to design a relational database system for a substantial problem |
LO1 D1 Evaluate the effectiveness of the design in relation to user and system requirements. |
|
|
P1 Design a relational database system using appropriate design tools and techniques, containing at least four interrelated tables, with clear statements of user and system requirements. |
M1 Produce a comprehensive design for a fully-functional system, which includes interface and output designs, data validations and data normalisation |
|
|
LO2 Develop a fully-functional relational database system, based on an existing system design |
LO2 & LO3 D2 Evaluate the effectiveness of the database solution in relation to user and system requirements and suggest improvements. |
|
|
P2 Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables. P3 Implement a query language into the relational database system. |
M2 Implement a fully functional database system, which includes system security and database maintenance. M3 Assess whether meaningful data has been extracted through the use of query tools to produce appropriate management information. |
|
|
LO3 Test the system against user and system requirements |
||
|
P4 Test the system against user and system requirements. |
M4 Assess the effectiveness of the testing, including an explanation of the choice of test data used. |
|
|
LO4 Produce technical and user documentation |
LO4 D3 Evaluate the database in terms of improvements needed to ensure the continued effectiveness of the system |
|
|
P5 Produce technical and user documentation. |
M5 Produce technical and user documentation for a fully-functional system, including data flow diagrams and flowcharts, describing how the system works. |
|
Plagiarism Notice
You are reminded that there exists Academic Misconduct Policy and Regulation concerning Cheating and Plagiarism.
Extracts from the Policy:
Section 3.4.1: Allowing others to do assignments / Copying others assignment is an offence
Section 3.4.2: Plagiarism, using the views, opinion or insights / paraphrasing of another person’s original phraseology without acknowledgement
Requirements
- It should be the student’s own work – Plagiarism is unacceptable.
- Clarity of expression and structure are important features.
- Your work should be submitted as a well presented, word-processed document with headers and footers, and headings and subheadings.
- You are expected to undertake research on this subject using books from the Library, and resources available on the Internet.
- Any sources of information should be listed as references at the end of your document and these sources should be referenced within the text of your document using Harvard Referencing style
- Your report should be illustrated with screen-prints, images, tables, charts and/or graphics.
- All assignments must be typed in Times New Roman, font size 12, 1.5 spacing.
- The center policy is that you must submit your work within due date to achieve “Merit” and “Distinction”. Late submission automatically eliminates your chance of achieving “Merit and Distinction”. Also, 80% attendance is required to validate this assignment.
|
Assignment Prepared By Sheela Paudyal |
Signature
|
Date February 27, 2025 |
|
Brief Checked By Dhruba Babu Joshi |
Signature
|
Date March 02, 2025 |
Топ онлайн казино 2025: детальное исследование лучших игровых платформ
Онлайн азартные игры стремительно расширяют свою аудиторию в России, привлекая всё больше игроков из-за своей функциональности. Однако для комфортного гейминга критически важно выбирать только проверенные площадки, которые гарантируют честность алгоритмов. В этом материале мы рассмотрим ключевые параметры оценки, составим список лучших казино 2025 года и предоставим практические инструкции для максимально эффективной игры.
Основные признаки безопасности онлайн-казино
Чтобы защититься от мошенников, необходимо учитывать следующие характеристики:
Лицензионная чистота
Проверяйте наличие международных лицензий: Мальты.
Убедитесь, что игровые автоматы прошли сертификацию от авторитетных организаций (eCOGRA).
Система случайных чисел (RNG)
Казино должно использовать сертифицированный генератор случайных чисел, что обеспечивает прозрачность процессов.
Скорость транзакций
Надёжные казино предлагают мгновенные выплаты через современные системы: банковские карты (Мир), электронные кошельки (Neteller) и криптовалюты (Ethereum).
Бонусная политика
Хорошие казино предоставляют впечатляющие бонусы: стартовые предложения, фриспины и VIP-клубы. Обратите внимание на вейджер.
Мобильная оптимизация
Современные казино оптимизированы для мобильных устройств (Android) с быстрой загрузкой. Это позволяет играть в любом месте без ограничений.
Клиентская поддержка
Отзывчивая служба поддержки работает круглосуточно и помогает решать вопросы через чат.
Рейтинг лучших онлайн-казино 2025 года
1. Cat Casino
Преимущества: мгновенные выводы средств (до 1 минуты), лицензия Curacao, уникальные предложения.
Бонусы: бездепозитный бонус — 100 фриспинов в Gates of Olympus.
Особенности: розыгрыши путешествий.
2. Kometa Casino
Преимущества: лучшее live-казино, кэшбэк до 30 000?.
Бонусы: стартовый комплект — 255% + 500 бесплатных вращений.
Особенности: VIP-клуб с эксклюзивными привилегиями.
3. R7 Casino
Преимущества: приватный вход по email, поддержка цифровых активов (USDT) с бесплатными транзакциями.
Бонусы: фриспины за подписку на канал.
Особенности: двухфакторная аутентификация для безопасности аккаунта.
4. Arkada Casino
Преимущества: мгновенные переводы на карты РФ (Сбербанк), регулярные розыгрыши.
Бонусы: кэшбэк до 15%, 100% бонус на первый депозит.
Особенности: проверенные автоматы от Microgaming.
5. Kent Casino
Преимущества: поддержка криптовалют, турниры с призовым фондом 1 млн рублей.
Бонусы: возможность бесплатной игры.
Особенности: широкий выбор слотов с максимальной отдачей.
Особенности мобильных казино
Мобильные казино становятся все более популярными благодаря удобству использования. Их преимущества:
Адаптивный дизайн: интерфейс адаптирован для сенсорных экранов.
Быстрый доступ: нет необходимости скачивать дополнительное ПО.
Поддержка платежей: можно вести транзакции и получать выигрыши через специальные сервисы.
Низкое потребление трафика: современные казино работают быстро даже на медленном интернете.
Как выбрать лучшее казино?
При выборе онлайн-казино учитывайте следующие аспекты:
Лицензия и безопасность
Убедитесь, что казино имеет глобальное разрешение и использует шифрование данных (SSL).
Ассортимент игр
Лучшие казино предлагают обширный ассортимент слотов, настольных игр (покер) и живые игры.
Скорость выплат
Изучите отзывы игроков о времени вывода средств.
Бонусные программы
Обратите внимание на условия акций, требования по использованию бонусов и наличие других предложений.
Качество поддержки
Проверьте, насколько оперативно сотрудники помогают пользователям.
Мобильная версия
Убедитесь, что казино имеет адаптированную версию для смартфонов.
Заключение
Онлайн-казино могут стать отличным способом развлечения, если подходить к их выбору серьёзно. Придерживайтесь наших подсказок, играйте только на надёжных платформах и помните о важности самоконтроля. Азартные игры — это прежде всего развлечение, а не финансовая стратегия.
Если вы ищете качественное заведение с щедрыми бонусами, обратите внимание на топовые площадки, такие как Kometa Casino. Они отлично зарекомендовали себя среди игроков и продолжают радовать своими предложениями.
https://t.me/s/topcasinos_ru
For high-quality gaming, download 888Starz Casino and play slots, poker, and more.
The production technology morson.org allows for the possibility of creating inscriptions on double-sided tape to place stickers on the inside of the glass
Buckwheat crops are planted on poor housebru.com soils to increase the content of phosphorus and potassium.
Зеркало Нев Ретро Казино [url=www.newretromirror.ru/]www.newretromirror.ru/[/url] .
Kasyna online to dziś coś więcej niż tylko gry. To pełne emocji miejsca, gdzie możesz się zrelaksować, sprawdzić szczęście i przy okazji zgarnąć niezłe nagrody — bez wychodzenia z domu. Właśnie dlatego stworzyliśmy Ybets kasyno, nowoczesne i uczciwe kasyno dla graczy, którzy cenią sobie swobodę, jakość i dobrą zabawę. Działamy z myślą o użytkownikach z Polski — w pełni lokalnie i bez zbędnych komplikacji. Hey there! This post could not be written any better! Mostbet promo code Mostbet promo code free spins are also included in this promotional package, providing players with additional chances to win on selected slot games without risking their own funds. Strona kasyna GGBet Polska prezentuje się całkiem fajnie. Jest czarna, schludna. Kolorystyka jest naprawdę okej. Podoba mi się to połączenie czarnego i pomarańczowego. Wszystko naprawdę dobrze się komponuje i cieszy oko. Może jedynie przydałaby się wersja light motywu.
https://denmyl.com/?p=18575
This is important for security purposes, as it helps prevent fraud and money laundering. It may take only a few mins to complete typically the registration process. The app also provides a variety of deposit plus withdrawal methods. You can top upward your account with Visa or Mastercard mostbetz.in, or you can use e-wallets just like Skrill or Neteller. Kabaddi betting is still not generally available at Indian sportsbooks, and we all are always glad to see a gambling site that does offer odds on different kabaddi events. Rabona Casino to dostawca gier online, który oferuje wiele opcji zakładów, w tym zakłady sportowe. Gracze mogą stawiać zakłady na szeroką gamę sportów, od tradycyjnych rynków, takich jak piłka nożna i tenis, po wyjątkowe oferty, takie jak sporty wirtualne i e-sport. Strona Rabona zawiera również wiele dodatkowych zakładów dla każdego sportu, co ułatwia graczom postawienie zakładu.
The industry of online gambling is growing rapidly, and he has worked with some really good players over the years. He played in cities in Illinois, you are the manager and therefore. While CryptoLogic has made serious waves in the online slots vertical, it is important to be informed on the daily conditions of the players. For instance, PSG Talon lifted the regional trophy and secured a spot at the MSI 2023. There are other cryptocurrencies available but Bitcoin occupies the top spot and is the common preference of professional and amateur gamblers alike, the NetEnt slots were the first games available at this online casino. Hence the slick and modern website design, and there seem to be more coming out every year. When putting features under the microscope, it has to be said the multiplier system is similar to the one used in Sweet Bonanza. However, introducing multipliers via wild symbols makes a change from the standard progressive system following cascades that might intrigue Megaways connoisseurs. There are pros of cons to using this method, of course. It is great when several wilds appear throughout a spin cycle, though it can mean an absence of multipliers if wilds don’t hit, even if you’re powering through cascades like there’s no tomorrow.
https://finxina.com/2025/07/15/mines-game-fun-mode-perfect-for-casual-play/
Even though Megaways provides a shed load more ways to win, symbol values have actually increased as well. Starting on the lower side of the paytable, we find 10 to A card icons spinning amidst moose, wolves, cougars, eagles, and buffalo. All are North American staples, topping out with a line of buffalos worth 20 times your stake. The game also includes a wild symbol that appears on reels 2, 3, or 4 to replace any standard pay symbols. Basic Game Info Even though Megaways provides a shed load more ways to win, symbol values have actually increased as well. Starting on the lower side of the paytable, we find 10 to A card icons spinning amidst moose, wolves, cougars, eagles, and buffalo. All are North American staples, topping out with a line of buffalos worth 20 times your stake. The game also includes a wild symbol that appears on reels 2, 3, or 4 to replace any standard pay symbols.
Cbet a un tout nouveau jeu à nous proposer, et le moins que l’on puisse dire c’est qu’il a quelques atouts dans sa manche. Nous avons testé JetX pour vous et voici notre avis. Nous avons recensé 43 fournisseurs de jeux en ligne sur Cbet. Ce nombre est tout à fait acceptable pour un site de cette envergure. Les providers présents font, pour la plupart d’entre eux, partie des meilleurs créateurs du marché. Nos experts ont souligné la présence de fournisseurs méconnus du grand public, que l’on ne retrouve pas sur les établissements de jeu concurrents. Nous pensons notamment à Mancala Gaming, Habanero ou encore Atmosphera. Certains providers incontournables manquent à l’appel, comme Push Gaming, Relax Gaming, NetEnt et Red Tiger. Toutefois, les principaux acteurs de cette industrie sont à retrouver sur ce catalogue de jeux :
https://yoomark.com/node/add/pin?media=~qwerty~s%3A//buffalokingmegaways.tn/wp-content/uploads/2025/06/cropped-logo.png&url=~qwerty~%3A//buffalokingmegaways.tn/&title=Buffalo%20King%20Megaways%20gratuit%20Tunisia%20%F0%9F%8E%AE%20jouer%20buffalo%20king%20megaways%20demo&is_video=false&description=
Prêt pour incarner un pilote et miser avant le crash ? Découvrez dès maintenant les différents jeux d’argent d’avion. Les plus populaires sont, à ce jour, les jeux Aviator, JetX ou encore Cash or crash Live et Cappadocia, mais il en existe bien d’autres. En voici un aperçu : Avez-vous déjà entendu parler de JetX ? L’opérateur de l’iGaming, CBet Casino, a sorti ce nouveau jeu qui permet de gagner de grosses sommes en peu de temps. Les gains montent vite et vous avez beaucoup de chances de décrocher le jackpot. Il existe plusieurs conseils pour augmenter vos chances de gagner à la machine à sous JetX: utilisez la méthode JetX à faible risque et à risque modéré comme principale, placez des paris automatiques en plus des paris manuels, étudiez les règles, collectez des statistiques et testez les stratégies en mode démo. Jouer de manière responsable ! Les chances defaire d’argent à JetX sont très élevées ! Utilisez différents trucs, comparez d’autres jeux de casino, mais surtout, choisissez votre façon de jouer. Doubler la mise après que vous êtes sûr. Vous avez également la possibilité d’obtenir un bonus et d’obtenir encore plus avec JetX bet.
Teen Patti Gold, a popular household card game of Indian origin, is one of the highest grossing games in India with over 6 million monthly active players globally. You’ll need both strategy and luck to win at this highly compelling game! Delivering At Your Doorstep All Over Lebanon Within 1-2 Days. Clean (it’s extremely likely that this software program is clean) Engaging Gameplay: Teen Patti Gold brings the classic Teen Patti card game to your mobile device, allowing you to enjoy the thrill of the table anytime, anywhere. Play with friends or challenge players from around the world in exciting multiplayer matches. ‘ + loadname + ‘ As per the teen patti winning rules, a player needs to have the strongest three-card hand in order to win that round. the strongest teen patti hand is a trail and that too of Aces.
https://dados.iff.edu.br/user/apjupelga1988
No geral, a trilha sonora e a animação do Big Bass Splash criam uma atmosfera alegre de férias de pesca. Tudo sobre combinações vencedoras no Big bass splash. O Crown Casino é o maior cassino da Austrália e tem uma grande sala de poker com mais de 50 mesas, 6 ou 8 baralhos de cartas. Os jogadores podem fazer depósitos e retiradas em uma dessas moedas criptográficas populares, embora não seja tão comum quanto cartões de débito e transferências bancárias. Não é atoa que a série Big Bass se tornou um verdadeiro estandarte da cultura iGaming. Big Bass Bonanza, o jogo originário da série, é um jogo do pescador com bons gráficos, rodadas grátis empolgantes com a funcionalidade de multiplicadores e de jogabilidade simples.
Your mission is to safely guide your chicken across multiple lanes, avoiding oncoming traffic. Each successful crossing increases your multiplier, meaning your winnings grow with every lane you conquer. However, one collision ends your round, so timing and strategy are key. You can email the site owner to let them know you were blocked. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page. New online casino games emerge daily—some good, some bad, some downright ugly. Amid these new releases, 1Win Jetpack has become one of the most popular crash-style games in the universe. But if you’re not familiar with crash games, you might not have bumped into this in-damand game, and that’s where we come in! Easy to…
https://careers.gita.org/profiles/6903501-yolanda-hall
Download the BC Game APK to access a wide range of games and enjoy an immersive gaming experience on your mobile device. Download the BC Game APK to access a wide range of games and enjoy an immersive gaming experience on your mobile device. En Yajuego, te ofrecemos las mejores cuotas y promociones para que maximices tus ganancias. Además, contamos con un equipo de expertos en fútbol sala que te brindarán consejos y análisis para ayudarte a tomar decisiones informadas al momento de apostar. Nuestra plataforma es fácil de usar y te permite realizar tus apuestas de forma rápida y segura. Download the indibet apk and take your gaming experience mobile, with sports betting and casino games available at your fingertips. Download the indibet apk and take your gaming experience mobile, with sports betting and casino games available at your fingertips.