Search results for 'CIS355A FINAL PROJECT GUI APPLICATION'

Create ER Diagram with the following information:

Gamer -user name, password, email, first name and last name; User name is unique; Can create multiple characters
Character -name is unique. Needs to show current level, exp points, health points, magic points, strength, intelligence, dexterity, belong ONLY ONE class. 3 classes: warrior, mage, ranger
Items (for character)- name, type, value, status (0 to 100, 100 is new and 0 is broken), 3 Items (weapon, armor, accessory) Many Character can have the same item of same name, but not same individual item
Weapon - type, speed, damage
Armor - defense value, type
Accessory - type, special effect
Character Skill - name, Magic Point cost of skill, level requirement, description (multiple characters can have same skill and can have multiple skills) (Some skills have prereqs)
Player vs Player - each match has: score of each character, list of match history (only 2 players in match)
Guild - name of guild, time created, current status, list of characters in guild

CS362 Structured Query Language for Data Management Week 3 IP Select Statements:

Provide select statements to satisfy the following data requests:
1. List all active male students assigned to Advisors 1 or 3 (Fred Stone or Jack Simpson). (Where Clause - Filtering 3 different things: Active, Male Students, Adivsors)
2. Provide a list of all students without a biography. (focusing Null Biography)
3. What classes are in the English department? (Where Clause)
4. Create a list of all students and their advisors. Sort by the advisor’s name and then the student’s name. Include the student’s birth date, gender, and GPA. (join's statement combine the two tables students and class tables: Order by clause like birthday, gpa,etc)
5. How many students were born in the 1980s? (Aggregate using count expression)
6. Write a query to show the average GPA by gender. (Aggregate using count expression)
7. Provide a list of all advisors and the number of active students assigned to each. Filter out any advisors with more than 1 student. (Combine lines 4-6)

Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. Include an explanation as to how and where these queries or others like them can be used in your final system. Upload your document to the Submitted Tasks.

Unit 4 Individual Project: Database SQL Server

Deliverable Length:
1 Database Diagram; DDL for 7 Tables

Details:
The following is the same database diagram from Unit 3:

Using this diagram, address the following:
Establish the relationships between the tables in the SQL server environment.
Ensure that all primary keys are properly created and that the foreign key columns are defined correctly.
Make sure that the 3 additional tables you added in Unit 3 are also shown and have established primary and foreign keys to appropriate tables.
Update the database diagram, and generate the data definition language (DDL) for the new tables.
 Describe what changed in the DDL for each table.
 Describe any changes that were needed from the original model to create the relationships.
Submit a consolidated Word document with all screenshots and the DDL.

Unit 5 Individual Project Database SQL Server

Deliverable Length: 7 SELECT statements; 3 SQL JOIN statements

At this point, you will add data to your database and validate that they loaded properly. In tabular format, include 3 rows for each table, making sure that the primary-key and foreign-key relationships are properly applied.

Next, you will insert the 30 rows of data that you identified (using the concepts you worked on identifying the primary and foreign keys), then perform queries using JOIN syntax of the database.

Task 1: Create 3 rows of data for each table ensuring that the referential integrity is valid.
Task 2: Add the 30 rows of data to the appropriate table in your database (using any appropriate method available).
Task 3: SELECT all columns and all rows of the 10 tables. Create a screenshot of each query and output data, and submit them.
Task 4: Write SELECT statements for the following (include a screenshot of the SQL and its execution, including the resulting data):
Display the employee id, first_name, last_name, and department_name for all employees.
Rows returned
Display the employee id, first_name, last_name, and job title_name for all employees.
Rows returned
Display the employee id, first_name, last_name, department_name, and job title_name for all employees.
Rows returned

Combine all of the SQL statements (text only) and screenshots into a single Word document, and submit it for grading

Final Project Part IV: Using MS Access

1. Based on the design created in Week 2, create the physical design of the database using MS Access.
 Create tables that represent the entity that you created in Week 2.
 Create the required columns with the appropriate data types.
 Specify an appropriate primary key for the table.
 Specify constraints for columns wherever applicable

2. Enter at least ten records in the database.

3. Query the database.
Create queries to filter records based on various conditions that you can think of. Some queries you can create include:
 If your table has an Age column, then create a query to view the records of students of the same age.
 If your table has an Address column, then create a query to view the records of students living in the same area.

4. Check if there is a need to redesign the database.

5.Create entry forms for the database.
 Create a form that helps you enter records in the table you created.
 Ensure that the constraints you applied in the table are also checked  in the form.
 Suggest a strategy to ensure that the primary key values are not repeated.

6.Create a report that displays records of all students.

Design the database, enter data, run the queries, create the forms, create the reports and submit your database to the Dropbox. In a Word document, share your experience about this design and implementation process and discuss the need and scope for redesigning the database.

DBM/380 Week 3 ERD Smith Consulting in Access

Individual Database Creation Project

The following assignment is based on the database environment chosen and discussed in the Week Two Individual Assignment.

Create a Microsoft® Visio® diagram to create a detailed Entity Relationship Diagram(ERD) using the data specifications noted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty’s feedback.

Create a Microsoft® Access® database to create the preliminary database tables, columns with data types, primary keys, and relationships.

DBM/380 Week 4 Normalization of the Smith Consulting ERD

The following assignment is based on the database environment chosen and created in the Week Three Individual Assignment.
Your database project must meet the following assessment requirements:

Design and develop a database using professional principles and standards.
Provide a logical and physical design of the database.
Use relational database software application to develop database.   
Provide an entity relationship diagram.
Normalize the database.
Generate and provide test data.

Use a Microsoft® Visio® diagram to normalize the ERD to third normal form (3NF).

Use the Microsoft® Access® database created in Week Three to create a minimum of 10 rows of test data in each table. Also, create at least one query that joins two tables and returns values from both tables.

Note. Only the Microsoft® Visio® diagram must be normalized to the 3NF. The 3NF is not required for a Microsoft® Access® database.

Submit the ERD and final database to the appropriate Assignment link.

ITCO630 Unit 3 Individual Project SQL Script

Deliverable Length: SQL Script

Unzip, and attach the sample database ITCO630_A. The sample database represents an educational institution with students and different schools. Each student goes to just one school. The students have various roles in different assignments and may work on more than one assignment at a time.
The following are the tables and data in the ITCO630_A database:

Using the sample database, write the scripts in a file called ITCO630_P3.SQL to create the following views. Remember to include a USES clause at the top of the script file to use the ITCO630_A database. Also include code that checks if the view already exists. If it does, it should be dropped and recreated.

1. Create a view named v_worker showing the student number, assignment number, and start date where the role is "worker."
2. Create a view called v_no_points with all the columns of the assignment table except the points column.
3. Create a view called v_count that shows the number of students working on each assignment. The view should have columns for the assignment number and the count.

INF322 DATABASE MANAGEMENT Week 5 Final Project Customer Service Database

The Final Project consists of building a customer service database to be submitted by the final day of the course.

Focus of the Project
1. Use the Access database you created in Week 3: Customer Service Database

2. Output 3 queries using SQL code and not the standard access view:
A query on all contacts in the customers table showing first name, last name, address, e-mail address and three additional fields from the table.
An update query that changes one or more customer records but not all records.
A delete query that removes one or more customer records but not all records.

3. Using SQL commands, add a new field called Birthday to the Customers table. Populate some of the fields with data.

4. Report on Customers in Database showing Names, State, and Phone Numbers.

5. Create a report showing contact name and birthdays. Do not show records without a birthday.

6. Analyze the data populated in the Database to show referential integrity. This includes a statement showing what the affected tables in each dataset are and how they are impacted in the case of an addition of data or a deletion of data.

7. All data and screen shots should be included in a Word document with a brief explanation of the actions you performed.