Database implementation and system prototype

Reference no: EM131458993

Independent Learning and Research

The system may involve the use of some web technologies and techniques that you had not learned (or not covered in detailed) in previous semesters. You are thus required to conduct INDEPENDENT LEARNING AND RESEARCH on these technologies. Some of the recommended technologies that you should consider to learn and implement are:

- AJAX (jQuery, etc)
- Client-side UI enhancement (jQuery UI, HTML5 Drag-and-Drop, etc)
- Data reporting (Google Chart Tools, Microsoft Client-Side Reporting Tool, etc)
- Location maps (Google Maps, HTML5 Geolocation, etc)
- Media streaming (YouTube, HTML5 Audio and Video, etc)
- Real-time chat and communication (ASP.NET SignalR, etc)
- Electronic payment (PayPal, etc)
- SMS and email notification
- Webcam integration

- QR-code encoding and decoding
- Machine-based login blocking
- Image processing and manipulation
- Other

Specifications and Requirements
Web-Based Information System

In this project, you are required to propose a SPECIFIC PROJECT TITLE, which is subjected to the approval of your supervisor, and carry out the appropriate procedures to plan, analyze, design and implement the relevant web-based information system. The MANDATORY REQUIREMENTS of the system are:

- Core Business Processes
Identify the relevant business processes (or modules) specific to your proposed project title. For example, if you propose a simple reservation system, it should include modules for the allocation of tickets, seats, rooms, time-slots, etc. Examples of other possible sub-processes are confirmation of reservations, cancellation of reservations, calculation of reservation validity period, payment of reservation fees, generation of reservation references (e.g. receipts or notes), issuing reminders, etc.

Difference project titles (or systems) involve different business processes (or modules). You should carry out the necessary study, analysis and research to identify the business processes (or modules) that best suit to your proposed project title. This also includes experiencing and learning how some of the real-life web-based systems work.

- Database and ORM Framework
Design and implement your database by following the principles of database design. Tables must be normalized (denormalization may be accepted for appropriate cases), relationships between tables must be indicated, fields and their data types must be appropriate, etc. Maintain only those data that are needed by your system. For example, it is useless to keep track of customer mailing address if you are not doing product delivery and not sending postal mail to your customers.

The use of LINQ-to-SQL to map your tables to entity classes is MANDATORY. Except for unavoidable cases, you should always program against entity classes while doing data operations, rather than making direct SQL queries.

- Security and User Accounts
Basic authentication and authorization should be implemented to grant different access privileges to AT LEAST THREE (3) different user roles (e.g. CUSTOMER, STAFF, MANAGER, etc). You should identify the different user roles your system should handle. User accounts maintenance should also be included. In addition, passwords stored in the database must be HASHED.

- Data Maintenance Modules

Depending on the nature of the selected project title, this can be bus schedules and seats maintenance (for bus ticket reservation), rooms and allocations maintenance(for hotel room reservation), consultation hours and time-slots maintenance (for consultation hour reservation), book maintenance (for book reservation), product maintenance (for online shopping), etc. You are required to identify and implement the appropriate maintenance modules and sub-modules for the system.

- Input Handlings and Validations

Use appropriate controls while handling user inputs (e.g. do not use a textbox for gender). Design your input forms to reduce the required keystroke and mouse-click, as well as to minimize the possible input errors (e.g. setting max-length for textbox).

Input validations should be integrated into all modules that involve data entry. All inputs should be COMPLETELY validated at BOTH client-side and server-side (with meaningful error messages). It is essential to ensure that all data are logically valid and data integrity are always be maintained.

- Query Handlings
The system should allow different roles of users to view their desired data and information (e.g. personal reservation history, daily reservation listing, customer listing, etc). Querying features and data presentation techniques such as FILTERING, SEARCHING, SORTING and PAGING should be incorporated to enable users to easily retrieve the data and information that they want from the system.

- Data Reporting
The system should produce AT LEAST FOUR (4) management reports. There must be at least ONE FOR EACH of the following types of management reports:

o Detail/transaction report (with control break)
o Summary report
o Exception report

The management reports produced must be USEFUL and MEANINGFUL to the users for decision making. For example, a report that lists all the customer details is not useful as compared to a report that lists the customers who made the most orders for the last quarter. So, decide the management reports that you wish to produce carefully.

For implementation, you can produce onscreen and/or printed reports, in tabular and/or chart formats. Do the necessary RESEARCH on Google Chart Tools, Microsoft Client-Side Reporting Tool, etc for programming the necessary features.

- Other appropriate modules, functionalities, features, outputs, etc.PROJECT (PART 1): System Analysis and Design

TASK 1: Functional Requirements

You are required to describe IN DETAIL the functionalities and features of all modules that are to be implemented in the system. Each main module should be logically broken down into relevant sub-modules (or features). Use tables, diagrams, pictures, sketches, etc to clearly illustrate your ideas whenever appropriate. You should state how the modules are distributed among each team member.

TASK 2: Data Flow Diagram

You are required to construct the DFD (using standard notations as recommended by your supervisor) that models the proposed system, which should include:

- Context Diagram
- Diagram 0 DFD
- Diagram 1 DFD: For any TWO (2) MAIN processes in Diagram 0 DFD, as being recommended by your supervisor.

TASK 3: Entity Relationship Diagram

Construct the ERD (using standard notations as recommended by your supervisor) that shows the relevant relationships and cardinalities between each database entity. Data Fields, primary keys and foreign keys should be shown clearly. You are REQUIRED TO RESOLVE any many-to-many relationship in the diagram (i.e. use intermediate tables so that there is no many-to-many relationship in your ERD).

TASK 4: Table Design

Based on the ERD, you are required to design the related database tables with relevant fields. Information such as table name, field name, data type, field size, format, primary key field, foreign key field, null or not null field, etc should be identified clearly. All tables should be presented in 3NF or higher form.

TASK 5: Report Design

You are required to design and produce FOUR (4) well-formatted (with header, title, sub-title, date time, etc) and USEFUL management reports. There must be at least ONE FOR EACH of the following type of management reports:

- Detail/Transaction Report (with control breakpoint)
- Summary Report
- Exception Report

For each report, explain who would use the report and explain how the report would be useful to the users in making business decision.

TASK 6: Database Implementation and System Prototype

- Database Implementation: You should implement the database in SQL Server Express based on your database design. Include some REAL-LIFE SAMPLE DATA for each and every table in your database. Whenever appropriate, implement database views that will simplify data access in your system later. You should also generate the necessary ENTITY CLASSES that map to your database.

- System Prototype: The GUI of the system should be ready by now. All the input and output forms should already be designed and built (you may ignore the functionalities at this point). The prototype should also include the necessary menus, buttons, links, etc so that the general navigation and program flow can be examined. Although the system is not expected to be fully functional at this point of time, it is good if some of the modules have been implemented. This allows the supervisor to give you valuable feedbacks for improvements.

TASK 7: System Testing and Demonstration

The system should be 100% COMPLETED by now. Both of the MANDATORY and ADDITIONAL functionalities should be correctly implemented. All of the suggested improvements and enhancements from your supervisor (as given in the previous session) should be incorporated into your system. Remember to test and debug your system THOROUGHTLY to ensure that no bugs or errors will be detected during the system demonstration session. You should also ensure that the database contains enough sample records for demonstrating each and every features of the system.

As on the system demonstration session, the final system (i.e. ASP.NET project), together with the database implementation and related software resources, should be submitted to your supervisor in the form of CD/DVD. Attach a README file to tell how setup and run your system (e.g. give a list of preset username and password for accessing your system with different user roles).

You may be given a chance for the SECOND system testing and demonstration if your works are below expectation. However, your marks for this component will be CAPPED AT HALF of the allocation marks (provided the necessary improvements have been made). Those who are still underperformed during the SECOND system testing and demonstration will eventually FAIL this component.

Attachment:- Project Specification.rar

Reference no: EM131458993

Questions Cloud

How does the exponential smoothing technique forecast sales : How does the exponential smoothing technique forecast sales? Exponential smoothing weighs each year's sales data, giving greater weight to results from the most

Write the equation of the estimated regression line : Write the equation of the estimated regression line. What price would this model predict for a car with 80,000 miles and a condition level 3?

Describe what abnormal and normal behavior is : PSY-100 :Explain three treatment strategies for each scenario that you chose. You must include three to four in-text citations in the body of the power point.

Determine where you will test your product : Working alone or with a partner, choose a new-product idea, or a variation on an existing product, that you think would appeal to your classmates.

Database implementation and system prototype : AACS3154 WEB-BASED SYSTEMS DEVELOPMENT Project Specification - construct the DFD (using standard notations as recommended by your supervisor) that models the proposed system.

List some other ways in which you think observation method : Interpretative research offers marketing researchers many possibilities, including the opportunity to improve product features such as packaging for food.

Describe one of paul and elders ideas for improving studies : Describe the two ways that students normally study in a typical college course. Why do these techniques fail to promote deep learning?

Companies can get real creative promoting products : What are some ways you can control your company's image and brand while using the internet and social media platforms?

Implement a reverse polish calculator in marie : I want you to implement a reverse polish calculator in MARIE. This calculator must be implemented with or support the following requirements

Reviews

len1458993

4/11/2017 8:39:58 AM

NOTE 4: The component “Entities and relationship to DFD” refers to that every data store found in the DFD must be mapped to exactly one or many entities in the ERD. NOTE 5: The component “Fields, primary keys and foreign keys” refers to every relationship (between entities) found in the ERD is mapped through the use of appropriate primary key and foreign key pair between the related tables (i.e. entities). In any one-to-many relationship, the foreign key is always at the many-side.

4/11/2017 8:38:42 AM

NOTE 1: The component “Format and presentation” refers to the ability of the students to present ideas clearly in written form or diagrams. The written ideas should be logically developed (easy to read and understand) and presented in appropriate sequences. Sub- sections and sub-titles should be used whenever appropriate. NOTE 2: The component “Understanding and justification” refers to the ability of the students to response to the questions asked by the supervisor for the purpose of solving the ambiguities found. Students are also required to justify their works or solutions when being requested. The supervisor will ask questions to the students as a method to detect non-original works. NOTE 3: The component “Validity and correctness” refers to the ability of the students to draw the DFD correctly and avoid common DFD errors such as “miracle” (process without input), “black hole” (process without output), “gray hole” (process on which the input is insufficient to produce the output), data store without input, data store without output, etc.

4/11/2017 8:38:08 AM

You are required to present and submit the following documentations or deliverables on the date as specified. You are required to REDO (i.e. the make-good opportunity) your works if your initial works are poor or as instructed by the supervisor. However, your marks for that particular task will be CAPPED AT HALF of the allocated marks. LATE SUBMISSION WILL BE PENALIZED. Although programming related tasks are scheduled on WEEK 5 TO WEEK 7, you are advised to start the development process AS EARLY AS POSSIBLE.

4/11/2017 8:37:52 AM

You are to work in a team of TWO (2) students. The project must be segmented into two equal portions such that each student is able to demonstrate his or her ability to carry out ALL the activities required, which includes the analysis, design, programming and testing of the system. It is your SOLE RESPONSIBILITY to form your own project team. If you are unable to get a team member, you will have to WORK INDIVIDUALY. The supervisor does not hold any responsibility in the teaming process. Exceptional case is ONLY applied to tutorial groups with ODD NUMBER OF STUDENTS. With approval from the supervisor and agreement from other students, a team of THREE (3) students may be formed. However, there should be ONLY ONE of such team per tutorial group. As the team size has increased, the supervisor may request the team to extend the project scope.

Write a Review

Required(*) Message

User Account

All Pages