Category | Assignment | Subject | Computer Science |
---|---|---|---|
University | Dublin Business School | Module Title | Database Design and Cloud Technologies |
Assessment Type | Report |
---|---|
Academic Year | 2024-25 |
You are tasked with developing and designing a new database system for the list below or a company/business of your choosing. The implementation of your system must be carried out using MS SQL Server.
Library Management System
Online Ordering System for a Restaurant
Student Enrolment System
Event Management System
Inventory Management System
Hotel Booking System
Online Learning Platform
Medical Appointment System
E-commerce Product Catalogue
Movie Rental System
The report must include the following:
(Total: 35 marks)
Achieve Higher Grades with B7IS109 Assignment Solutions
Order Non-Plagiarized AssignmentConsider the ERD created.
1. Create the relevant tables with appropriate relationships in MS SQL Server using the CREATE TABLE statement. (6 Marks)
2. Ensure appropriate Data types are used. (5 Marks)
3. Populate the tables with a minimum of 5 records using INSERT INTO SQL Statements. (5 Marks)
4. Create the following parametric stored procedures:
5. Create 4 Views that would be beneficial for the business. Views should consist of:
6. Scripts for your SQL server database for structure and data. (4 marks)
(Total: 65 marks)
You are required to:
Note: Your SQL server database must be available in your SQL Server Account until you receive your results for this module.
Criteria/Mark | < 40 | 40 – 49 | 50 – 59 | 60 – 69 | 70 + |
---|---|---|---|---|---|
Report | Insufficient or incomplete report with poor or incomplete data model, no/poor normalisation, poor explanation, etc. | Some, but insufficient and poorly written report with a poorly developed data model; some normalisation and explanation are not enough to meet the requirements | Sufficient explanation with data model with normalised schema that solves the problem, but lacks attention to good report writing skills | Well-structured and well-written report with good specifications and data model with normalised schema | Excellent solution to problem proving originality, creativity and evidence of research – very well written with excellent data model and normalised schema to 3NF |
Database System with MS SQL Server | Less than four tables not properly structured, queries without the required features that do not meet business requirements, no/poor implementation of stored procedures. | Four substantial tables demonstrating some structure of data, queries with some required features that meet some business requirements, some implementation of stored procedures. | Four substantial tables with some structure, queries with most required features that meet most business requirements, implementation of stored procedures, but not as appropriate as required. | Four substantial and structured tables with appropriate record queries with all required features that meet the business requirements, good implementation of stored procedures. | Excellent database system that meets all the business requirements, required features, etc. |
Take Our academic assistance & Get 100% Plagiarism-free papers
Buy Today,Contact UsStuck on your B7IS109 Database Design and Cloud Technologies? Don't worry! Our Computer Science Assignment Help service is the best for you. If you need help with assignments, our expert PhD writers will provide you with original content. And yes, you will also get free assignment samples which will give you a perfect idea of how to write a top-quality assignment. Don't worry about the deadline as we guarantee on-time delivery. Contact us now for high-quality and plagiarism-free work and boost your grades!
If you want to see the related solution of this brief then click here:- Database Design
Let's Book Your Work with Our Expert and Get High-Quality Content