1st-sit Coursework Question Paper Year Long 2024/2025
Module Code: CC6012NI Module Title: Data and Web Development Module Leader: Mr. Lekhnath Katuwal (Islington College) |
---|
Coursework Type: Individual Coursework Weight: This coursework accounts for 40% of the overall module
grades. Submission Dates: First milestone: Thursday, 26 December 2024 Second milestone: Friday, 3 January 2025 Third milestone: Thursday, 6 March 2025 Fourth milestone: Sunday, 16 March 2025 Final Deadline: Wednesday, 26 March 2025 19th December 2024 Coursework given out: Submit the following to Islington College’s MST portal Submission before 01:00 PM on the due date: Instructions: ● A report (document) in .pdf format in the MST portal or through any medium which the module leader specifies. Warning: London Metropolitan University and Islington College take plagiarism very seriously. Offenders will be dealt with sternly. |
---|
© London Metropolitan University
PLAGIARISM
You are reminded that there exist regulations concerning plagiarism. Extracts from these regulations are printed overleaf. Please sign below to say that you have read and understand these extracts:
Extracts from University Regulations on Cheating, Plagiarism and Collusion
Section 2.3: “The following broad types of offence can be identified and are provided as indicative examples ….
(i) Cheating: including taking unauthorised material into an examination; consulting unauthorised material outside the examination hall during the examination; obtaining an unseen examination paper in advance of the examination; copying from another examinee; using an unauthorised calculator during the examination or storing unauthorised material in the memory of a programmable calculator which is taken into the examination; copying coursework.
(ii) Falsifying data in experimental results.
(iii) Personation, where a substitute takes an examination or test on behalf of the candidate. Both candidate and substitute may be guilty of an offence under these Regulations.
(iv) Bribery or attempted bribery of a person thought to have some influence on the candidate’s assessment.
(v) Collusion to present joint work as the work solely of one individual. (vi) Plagiarism, where the work or ideas of another are presented as the candidate’s own. (vii) Other conduct calculated to secure an advantage on assessment. (viii) Assisting in any of the above.
Some notes on what this means for students:
1. Copying another student’s work is an offence, whether from a copy on paper or from a computer file, and in whatever form the intellectual property being copied takes, including text, mathematical notation, and computer programs.
2. Taking extracts from published sources without attribution is an offence. To quote ideas, sometimes using extracts, is generally to be encouraged. Quoting ideas is achieved by stating an author’s argument and attributing it, perhaps by quoting, immediately in the text, his or her name and year of publication, e.g. “e = mc2(Einstein 1905)”. A reference section at the end of your work should then list all such references in alphabetical order of authors’ surnames. (There are variations on this referencing system which your tutors may prefer you to use.) If you wish to quote a paragraph or so from published work then indent the quotation on both left and right margins, using an italic font where practicable, and introduce the quotation with an attribution.
School of Computing, FLSC
1
CONTRACT CHEATING
Contract cheating (also known as assessment outsourcing, commissioning, or ghost writing) is when someone seeks out another party, or AI generator service, to produce work or buy an essay or assignment, either already written or specifically written for them or the assignment to submit as their own piece of work.
Contract cheating undermines the integrity of the academic process and devalues the qualifications awarded by the university. Students are reminded that academic integrity is a fundamental principle of our institution. Engaging in contract cheating not only impacts the individual’s academic record but also the reputation of the university.
Students are encouraged to seek support if they are struggling with their coursework. The university offers a range of resources, including academic counselling, tutoring services, and workshops on study skills and time management. Utilizing these resources can help students achieve their academic goals without resorting to dishonest practices.
Penalty:
● Failure in the Module: The student must re-register for the same module, and the re-registered module will be capped at a bare pass.
● Ineligibility to Continue on the Course: Where re-registration of the same module, or a suitable alternative, is not permissible, the student will not be able to continue the course. Additionally, the following penalty will be applied to the student’s final award:
o Undergraduate Honors: The student’s final classification will be reduced by one level.
o Unclassified Bachelors: Downgraded to Diploma in Higher Education. o Foundation Degree: Distinction downgraded to Merit; Merit downgraded to Pass; Pass downgraded to Certificate in Higher Education.
o Masters: Distinction downgraded to Merit; Merit downgraded to Pass; Pass downgraded to Postgraduate Diploma.
Reporting and Consequences:
Instances of contract cheating will be thoroughly investigated, and students found guilty will face the penalties outlined above. It is the responsibility of every student to ensure that their work is their own and to avoid situations that could lead to accusations of academic misconduct.
By adhering to these standards, students contribute to a fair and equitable academic environment, ensuring the value and recognition of their qualifications are maintained.
2
Coursework Details
The coursework assignment is an individual assessment weighted 40% of the marks for the module. It is designed mainly to assess students’ practical problem-solving skills and critical thinking/evaluation on the design and development of database systems. It requires the student to analyse, design, and implement a web-based database application based on a given business case study. You are asked to provide a software solution as well as appropriate documentation detailing the design and implementation of the system.
1. Case Study
LS Corporation, a mid-sized technology firm, struggled with managing multiple projects due to fragmented systems, leading to inefficiencies, poor communication, and difficulty tracking progress. To address these issues, the company decided to implement a robust project management system to centralize data, streamline task assignments, and improve project visibility
In that corporation, A User can be part of multiple Projects which will have many tasks. A User can be assigned to multiple Tasks and there will be multiple user (developer, designer, project manager etc) associated in a single task. Each task can have multiple subtasks but each subtask is linked to a single task. User will comment on task which might be multiple for better communication. A task can require multiple resource. For easiness of the project completion, each project is breakdown into multiple milestone (E.g.: – Prototype completion, beta release etc) with due date.
Your prototype of the system will be developed using Oracle SQL Developer Data Modeler and ASP.NET with C#
Fig 1. Example of task tracking details
User ID: U-01 User Name: Sam Smith User Email: Smith@gmail.com User contact: +9779859697989 |
---|
Project ID |
Project Name |
Project Start Date |
Project Due Date |
Projec t Status |
Tas k ID |
Task Name |
Start Date |
Due Date |
Status |
---|---|---|---|---|---|---|---|---|---|
P-01 |
Enrolment System |
2024-01- 01 |
2024-10- 23 |
On going |
T-01 |
Student Registratio n |
2024 -01- 01 |
2024 -02- 20 |
Complete d |
P-01 |
Enrolment System |
2024-01- 01 |
2024-10- 23 |
On going |
T-02 |
Student Counsellin g Form |
2024 -01- 05 |
2024 -06- 15 |
On going |
P-02 |
Attendanc e System |
2024-03- 01 |
2024-12- 12 |
On going |
T-03 |
Biometric Registratio n |
2024 -03- 10 |
2024 -03- 20 |
Complete d |
3
2. Requirements of the Coursework
Marks are awarded for producing a working and properly documented system that meets the requirements specified below as deliverables:
2.1 Contents Page
A list of sections/subsections of the document, including page numbers.
2.2 Normalisation
[15 Marks]
Produce a set of fully normalised tables for the system:
● You may also add additional attributes where appropriate.
● Show clearly all the steps of normalisation, up to the 3rd normal form. ● Normalisation is done showing the correct transition between UNF to 3NF.
● Proper identification of Primary/Foreign Key, Repeating Groups, Partial Dependency, and Transitive Dependency
2.3 E-R Model
[10 Marks]
Use Oracle SQL Developer Data Modeler to produce an Entity Relationship Diagram. The final ERD should be consistent with the outcome of your normalisation. Submit a copy of the ERD:
● Proper ERD of the textual description with proper entities and correct cardinality (entities must show all primary keys and foreign keys involved).
● Explanation of assumptions made to make the ERD (must show the process to remove the duplication of entities(relations) from Relational Model, Normalization)
2.4 Data Dictionary
[5 Marks]
Use Oracle SQL Developer Data Modeler to produce a list of attributes for each entity. Submit a print-out copy of these lists:
● Data Dictionary must contain well-defined Name of Tables, Attributes, Appropriate Data Type and Size of Attributes, Constraints of Each attribute, Reference Tables and Attributes along with Example Data
4
2.5 Generation of Database
[3 Marks+ 4 Marks+ 3 Marks]
∙ Use Oracle SQL Developer Data Modeler to convert the E-R diagram into a set of database tables. Provide a print-out of the DDL script for generating the tables (relevant ‘CREATE statements only).
∙ Use Oracle SQL Developer to populate these tables with suitable data values (using ‘INSERT’ statements), at least 15 rows for SETUPS, and 30 rows for CONFIGURATION and TRANSACTION tables with proper screenshot.
∙ Provide a print-out of contents for all the tables (using ‘SELECT’ statements) with a proper screenshot.
2.6 Implementation of Web-based Database Application
❑ Implementation of a web-based database application which includes the following webforms (web pages) using ASP.NET with C#:
● Basic Webforms:
[15 Marks]
⮚ User Details
⮚ Project Details
⮚ Task Details
⮚ Subtask Details
⮚ Milestone Details
All these forms should facilitate input, update, and delete of information.
● Complex Webforms:
(Provide SQL Queries and Complex forms)
[6+14 Marks]
● User Project (for any user, show details of the user and the details of all the projects that he/she has been working or has worked on.)
● Project Milestone (For any Project, show the detail of the project with all the milestone of the project)
● Top Performer (for any project, show the details of top 3 user who has done the most task).
NOTE: Any pending task won’t be counted as task done.
❑ Implementation of a homepage website that includes an options menu with an Attractive Graphical Dashboard.
[5 Marks]
5
.
2.7 Documentation of the system (as implemented in 2.6)
FOR EACH FORM
Implementation document
● Provide a set of screen dumps for all the web pages (webforms) you have produced.
● Basic Forms to show CRUD operation (form view and list view screens with Template Fields for Foreign Keys))
● Complex Forms (Proper Filter Demonstration using List Box/Grid and Template Field (foreign keys))
Testing Document
[10 Marks]
∙ Provide a copy of the initial data (table contents) in your system. ● For each form implemented, list the individual tests that have been carried out together with their results.
● Proper test cases with Before and After Screenshots of data
● At least 2 failure cases with proper correction measures
FOR THE APPLICATION
The URL address for the uploaded website (connected with the Oracle database)
User Manual (up to 5 pages)
[5 Marks]
∙ The User Manual should have a contents page and separate sections for each form provided.
∙ The User Manual should contain clear instructions on how to use the system and how to run each of the forms available to it.
● Easy to read user manual with Arrows and Graphics to explain the process
2.8Further Discussion
[5 Marks]
Your discussion should summarise your experience in undertaking this coursework with the mention of 5 tools/techniques learned during coursework.
6
Milestone 1 (Thursday, 26 December 2024)
– Normalization
o Create an ERD from the case study with proper identification of relation and cardinality.
o Normalize the given table with proper key identification and show all the steps for identification of dependency.
Milestone 2 (Friday, 3 January 2025)
– Final ERD
o From the result set acquired from case study ERD and normalized table. Combine all the entities and create final ERD using Data Modeler.
o Create table in Oracle using the script generated from Data Modeler and insert data as required by coursework.
Milestone 3 (Thursday, 6 March 2025)
– Web Forms
o Create basic and complex web from required by coursework using ASP.NET.
Milestone 4 (Sunday, 16 March 2025)
– Report
o Almost all the component required for the coursework has been covered from Milestone 1 to milestone 3. Create a final Report.
———————————-End of the Coursework————————————
7
перепродажа аккаунтов безопасная сделка аккаунтов
услуги по продаже аккаунтов гарантия при продаже аккаунтов
биржа аккаунтов магазин аккаунтов
гарантия при продаже аккаунтов купить аккаунт с прокачкой
магазин аккаунтов социальных сетей аккаунты с балансом
купить аккаунт маркетплейс аккаунтов
магазин аккаунтов социальных сетей https://birzha-accauntov.ru/
площадка для продажи аккаунтов маркетплейс аккаунтов
маркетплейс аккаунтов гарантия при продаже аккаунтов
аккаунты с балансом продажа аккаунтов
магазин аккаунтов маркетплейс для реселлеров
услуги по продаже аккаунтов https://ploshadka-prodazha-akkauntov.ru
маркетплейс аккаунтов гарантия при продаже аккаунтов
платформа для покупки аккаунтов безопасная сделка аккаунтов
биржа аккаунтов магазин аккаунтов
Sell accounts Buy accounts
Account Buying Platform Buy accounts
Account Buying Service Verified Accounts for Sale
Accounts for Sale Account market
Account Selling Platform Account trading platform
Account market Account Buying Platform
Account Sale Profitable Account Sales
Accounts market Buy and Sell Accounts
Account Selling Platform Database of Accounts for Sale
Social media account marketplace https://socialmediaaccountsale.com
guaranteed accounts https://cheapaccountsmarket.com
secure account purchasing platform marketplace for ready-made accounts
account marketplace sell pre-made account
account marketplace account marketplace
account marketplace website for buying accounts
sell accounts accounts market
account store accounts marketplace
account catalog account market
account purchase guaranteed accounts
sell accounts account marketplace
account market sell pre-made account
ready-made accounts for sale accounts market
find accounts for sale https://accounts-buy.org
account trading platform marketplace for ready-made accounts
account trading sell pre-made account
account exchange sell pre-made account
marketplace for ready-made accounts account acquisition
buy account account catalog
account store account acquisition
buy account accounts for sale
website for selling accounts buy pre-made account
accounts marketplace accounts marketplace
account buying platform account trading service
account buying platform discount-accounts.org
account purchase sell account
account exchange https://shop-social-accounts.org/
website for selling accounts profitable account sales
marketplace for ready-made accounts account marketplace
account store https://accounts-offer.org
gaming account marketplace https://accounts-marketplace.xyz/
account selling platform https://buy-best-accounts.org/
account trading platform https://social-accounts-marketplaces.live
account selling platform accounts-marketplace.live
account market https://social-accounts-marketplace.xyz/
accounts market https://buy-accounts.space/
account purchase https://buy-accounts-shop.pro
guaranteed accounts account market
secure account purchasing platform https://social-accounts-marketplace.live
verified accounts for sale https://buy-accounts.live
accounts market https://accounts-marketplace.online
find accounts for sale https://accounts-marketplace-best.pro
маркетплейс аккаунтов akkaunty-na-prodazhu.pro
магазин аккаунтов https://rynok-akkauntov.top
купить аккаунт kupit-akkaunt.xyz
площадка для продажи аккаунтов akkaunt-magazin.online
продать аккаунт https://akkaunty-market.live/
покупка аккаунтов kupit-akkaunty-market.xyz
маркетплейс аккаунтов akkaunty-optom.live
продажа аккаунтов магазины аккаунтов
магазин аккаунтов akkaunty-dlya-prodazhi.pro
магазин аккаунтов kupit-akkaunt.online
buy facebook ads accounts buy old facebook account for ads
buy facebook account https://buy-ad-accounts.click/
buy fb ads account buy-ad-account.top
buy facebook ad account buy facebook old accounts
buy ad account facebook https://ad-account-buy.top/
buy facebook accounts for advertising https://buy-ads-account.work
buying facebook account https://ad-account-for-sale.top
buy aged fb account buying facebook accounts
facebook accounts for sale https://ad-accounts-for-sale.work
buy google ad threshold account https://buy-ads-account.top
sell google ads account https://buy-ads-accounts.click/
buy fb ads account https://buy-accounts.click
buy google ads threshold accounts buy google ads invoice account
google ads account for sale https://ads-account-buy.work
buy old google ads account buy google ads agency account
buy google ads verified account buy account google ads
buy adwords account buy google ad threshold account
google ads accounts for sale buy google adwords account
unlimited bm facebook https://buy-business-manager.org
google ads accounts buy google ads invoice account
google ads accounts https://buy-verified-ads-account.work
buy verified facebook buy-business-manager-acc.org
facebook business manager account buy buy verified business manager
buy business manager buy-verified-business-manager-account.org
facebook business manager account buy buy verified facebook
facebook bm for sale https://business-manager-for-sale.org/
buy verified facebook business manager account buy-business-manager-verified.org
unlimited bm facebook https://buy-bm.org/
facebook bm for sale https://verified-business-manager-for-sale.org
facebook business manager account buy buy-business-manager-accounts.org
buy tiktok ads account https://buy-tiktok-ads-account.org
tiktok ads agency account https://tiktok-ads-account-buy.org
buy tiktok ads account buy tiktok ads account
buy tiktok ad account https://tiktok-agency-account-for-sale.org
tiktok ad accounts https://buy-tiktok-ad-account.org
tiktok ad accounts https://buy-tiktok-ads-accounts.org
tiktok agency account for sale https://buy-tiktok-business-account.org
tiktok ad accounts https://buy-tiktok-ads.org
tiktok ads agency account https://tiktok-ads-agency-account.org