Reference no: EM131258336
Project: Database Development
ACIS 5504 -- Development Project Requirements
This project involves creating a fully functioning, fully realized database from scratch. For this project, you will document the full life cycle of database realization from business situation to requirements to design to implementation.
Business Situation for Project
The business situation for the project is that of Global Computer Solutions (GCS). The detailed description of the business situation is presented on page 185-189 (# 10) of the textbook. The assignment activities that you must complete are presented below.
(Note: Ignore the last paragraph on page 189 beginning "Your assignment is.... And forms", your assignment is the one below).
Project Requirements
Complete the following activities:
• Construct an ER model for this business situation.
• Create a relational model from your ER model. All keys should be clearly identified.
• Demonstrate that your database is in at least 3rd Normal Form.
• Write the DDL to create the tables for your design.
• Implement this model in Access or other DBMS product. You are also welcome to web-enable your database (but you must find your own server space).
• Add records to each table sufficient to demonstrate your interfaces and reports.
• Your application should allow the user to generate a report that shows the progress on a project similar to Table P5.10c of the description.
• Your application should allow the user to generate at least 4 other reports needed by GCS management. Each of these reports should use at least two of the tables in your database.
• Implement one user interface that allows recording of the hours worked for an employee on a project for a time period.
• Database should have a main interface screen (automatically opening form) with command buttons for the user to navigate the system (move to different forms) and perform data entry and generate report.
Submission Requirements
There are two submission requirements:
• Project Report -- The project report (in MS Word) must minimally consist of:
1. A description of the application suitable for users/managers to understand (at least 1-2 pages)
2. An ER model
3. A Relational model
4. A brief (paragraph) description of the normalization process (i.e. - why is this relational model in the normal form you claim)
5. DDL that implements the design
6. A description of the data entered into the tables and why it is adequate for demonstrating the sufficiency of the design.
Please upload your report into the Development Project folder in the Assignments folder. The file naming convention should be: "Last Name_First Name_Development Project Report.docx"
• Database - The actual database in MS Access or other DBMS application of your choosing that includes the populated tables and working reports and queries.
Please upload your database into the Development Project folder in the Assignments folder. Please use a document naming convention that allows the DLI to determine your name. EXAMPLE: "LastName_FirstName_DevelopmentProjectDB.mdb/accdb".
https://www.dropbox.com/s/irgyk3awx30rwjb/Project_1_book.pdf?dl=0
|
Demonstrate a critical knowledge and understanding
: Demonstrate a systematic understanding and critical appreciation of the process of creativity and innovation drawing on contemporary theories to support your evaluation and synthesis.
|
|
What is recommended site for eagle electronics new facility
: Using the factor-rating method, what is the recommended site for Eagle Electronics's new facility? - For what range of values for the weight does the site given as the answer to part (a) remain a recommended site?
|
|
Find the minimum and maximum number of nurses allocated
: Nurse staff scheduling (Khan and Lewis [1987]). To provide adequate medical service to its constituents at a reasonable cost, hospital administrators must constantly seek ways to hold staff levels as low as possible while maintaining sufficient st..
|
|
Applying the principle of justice resources
: As you have learned in your studies for Unit 2, there are many aspects of the ethical principle of justice that must be recognized and successfully dealt with in health care management. You saw examples and perspectives on applying the principle o..
|
|
Create a relational model from your er model
: Create a relational model from your ER model. All keys should be clearly identified. Demonstrate that your database is in at least 3rd Normal Form. Write the DDL to create the tables for your design.
|
|
What is meant by globalization
: What is meant by Globalization? Explain the impact of globalization on Saudi economy, its advantages and disadvantages.
|
|
The eu has made changes in airline regulation
: After further investigation, Miller decides that an existing set of hangar facilities for repairs is not nearly as important as earlier thought. If he lowers the weight of that factor to 30, does the ranking change?
|
|
Prepare a mission statement for an insurance company
: Question No.1: If you have to prepare a mission statement for an insurance company. How would you prepare it? What is the important part of your mission statement?
|
|
Is the theoretical framework related to previous research
: Does the research deal with significant and meaningful problem that lends itself to a substantial research effort? Is there a justification that demonstrates why the problem is worth studying? Is it clear who or what will be aided by research finding..
|