About helpidoc

CS371 Database Design Week 5 Assignment


CS371 Database Design Week 5 Assignment Chapter 6 Questions

Chapter 6 Exercises 1 page 154: Use MySQL Workbench to construct the relational diagram for this database.
Chapter 6 Exercises 2 page 154: Use MySQL Workbench to construct the relational diagram for this database.
Chapter 6 Exercise 5 page 155: Submit responses in Word Doc format.

You may submit a single word doc with SQL queries and your models pasted in – OR – submit separate files including PDFs of your models and a word doc with your queries.

Chapter 6 Exercise 1 page 154: Use MySQL Workbench to construct the relational diagram for this database:

1.  Leslie’s Auto Sales has a relational database with which it maintains data on its salespersons, its customers, and the automobiles it  sells. Each of these three entity types has a unique attribute identifier.
The attributes that it stores are as follows:
• Salesperson Number (unique), Salesperson Name, Salesperson Telephone, Years with Company
• Customer Number (unique), Customer Name, Customer Address, Value of Last Purchase From Us
• Vehicle Identification Number (unique), Manufacturer, Model, Year, Sticker Price Leslie’s also wants to keep track of which salesperson sold
which car to which customer, including the date of the sale and the negotiated price. Construct a relational database for Leslie’s Auto Sales.

Answer:

Chapter 6 Exercise 2 page 154: Use MySQL Workbench to construct the relational diagram for this database.

2.  The State of New York certifies firefighters throughout the state and must keep track of all of them, as well as of the state’s fire departments. Each fire department has a unique department number, a name that also identifies its locale (city, county, etc.), the year it was established, and its main telephone number. Each certified firefighter has a unique firefighter number, a name, year of certification, home
telephone number, and a rank (firefighter, fire lieutenant, fire captain, etc.) The state wants to record the fire department for which each firefighter currently works and each firefighter’s supervisor. Supervisors are always higher-ranking certified firefighters.
Construct a relational database for New York’s fire departments and firefighters.

Answer:

Chapter 6 Exercise 5 page 155: Submit responses in Word Doc format.

5. In the General Hardware Corp. database of Figure 6.1, what would happen if:
a. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
b. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
c. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set to null and an attempt is made to delete the record for customer 2198 in the CUSTOMER relation?
d. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is restrict and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
e. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is cascade and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?
f. The delete rule between the CUSTOMER and CUSTOMER EMPLOYEE relations is set-to-null and an attempt is made to delete the record for employee 33779 of customer 2198 in the CUSTOMER EMPLOYEE relation?

PRICE  $25.00

    


complaint complaint






POS/410 SQL for Business Week 4


POS/410 SQL for Business Week 4

 

SQL Reports

 

Use tables from the Kudler_FF database to write the SQL statements necessary to perform the following data manipulation:
o Increase all employees salaries with the selected EEO-1 classification by 10%.
o Increase all employees salaries by 5%.
o Choose an employee from the Employee table and delete that employee.
Deliverable: Copy the SQL statements and data from both tables showing how data was affected to a Word document. Post the document to the assignment tab of the classroom.

 
Use tables from the Kudler_FF database to write SQL statements that perform the following computations:
o Calculate the average salary for all employees.
o Calculate the maximum salary for all employees.
o Calculate the maximum salary for exempt employees.
o Calculate the minimum salary for all employees.
o Calculate the minimum salary for non-exempt employees.
Deliverable: Copy the SQL statements and results to a Word document. Post the document to the assignment tab of the classroom.

 
Use tables from the Kudler_FF database to write the following queries, using the GROUP BY clause in your SQL statements:
o Count the number of employees, grouped by EEO classification.
o Count the number of employees, grouped by exemption status.
o Compute the average salary, grouped by area code and gender.
o Compute average age, grouped by exemption status o Compute the earliest hire date, grouped area code, gender, and exemption status. Deliverable: Copy the SQL statements and results to a Word document. Post the document to the assignment tab of the classroom.

 

PRICE  $19.99

    


complaint complaint






Create a complete ERD in Crow’s Foot notation that can be implemented in the relational


Create a complete ERD in Crow’s Foot notation that can be implemented in the relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not carry any stock. A few spas are set up in a simple warehouse so customers can see some of the models available, but any products sold must be ordered at the time of the sale.

• HW can get spas from several different manufacturers.
• Each manufacturer produces one or more different brands of spas.
• Each and every brand is produced by only one manufacturer.
• Every brand has one or more models.
• Every model is produced as part of a brand. For example, Iguana Bay Spas is a manufacturer that produces Big Blue Iguana spas, a premium-level brand, and Lazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers several models, including the BBI-6, an 81-jet spa with two 6-hp motors, and the BBI-10, a 102-jet spa with three 6-hp motors.
• Every manufacturer is identified by a manufacturer code. The company name, address, area code, phone number, and account number are kept in the system for every manufacturer.
• For each brand, the brand name and brand level (premium, mid-level, or entry-level) are kept in the system.
• For each model, the model number, number of jets, number of motors, number of horsepower per motor, suggested retail price, HW retail price, dry weight, water capacity, and seating capacity must be kept in the system.

In addition, for this problem, use Excel to make a “Components of the ERM” table similar to table 4.4 on page 134.

 

PRICE  $19.99

    


complaint complaint






MIS582 iLab 4 Forms and Reports


MIS582 iLab 4 Forms and Reports

i L A B O V E R V I E W
Scenario and Summary
In this assignment, you will learn to create and save forms and reports in a provided Access database. To complete this assignment, you will need to be able to run Access 2010.

Deliverables
Name your Access database file using Lab4_, your first initial, and your last name (e.g., Lab4_JSmith.accdb). Create and save your Access database file. When you are done, submit your database to the Course Project Dropbox.

i L A B S T E P S
STEP 1
• Download the Lab4_FormsReports.accdb database from Doc Sharing.
• Rename the Lab4_FormsReports.accdb database with a name containing Lab4_, your first initial, and your last name as the file name (e.g., Lab4_JSmith.accdb).

STEP 2:
• Run Access 2010, either via Citrix or from Visio 2010 installed on your workstation.
• Open the database you renamed in Step 1.

STEP 3:
Reports
Create a report for each of the following requirements. Reports may be created using the wizard or an SQL query. Reports should follow the formatting guidelines given in the next step. Reports should be named as indicated below (e.g., Report1, Report2, etc.).
1. Report1: Show Instructor information (Instructor_ID, First_Name, Last_Name) grouped by Approved Course_No.
2. Report2: Show student information (Student_ID, First_Name, Last_Name, Status, Zip) grouped by Major.
3. Report3: Show student information (Student_ID, First_Name, Last_Name, Major) grouped by Zip code. Zip codes should be in increasing order.
4. Report4: Show student information (First_Name, Last_Name) grouped by Course Number and Course Name. Course Number should be in in increasing order.
5. Report5: Show student information (Student_ID, First_Name, Last_Name, Address, Zip) grouped by Status. Students should be in alphabetical order by Last_Name and;then First_Name.

STEP 4:
Report Format
• Reports should display two or more child rows for each parent row. For example, Report1 should display each Course_No with instructors who are approved to teach the course grouped under it. In this case, the parent row would be the Approved Course_No with Instructor listed as child rows underneath each parent row
• There should be at least two child rows of data for each parent row. Add data to the tables in order to have reports show at least two child rows per parent.

STEP 5:
Form1: Create a form based on an SQL query.
• Create and run an SQL query that displays Student Information (Student_ID, First_Name, Last_Name, Address, Zip).
• Save the query in the database named Form1Query.
• Create a form based on Form1Query. While Form1Query is selected, go to the Create menu and select Form to build the basic form.
• Select the form and switch between the views (Forms, Layout, and Design) to change the properties or the form’s appearance as desired.
• Save the form in the database named Form1Query.

STEP 6:
Form2: Create a form using the Form Wizard.
• Invoke the Form Wizard as shown in the tutorials above.
• Using the Form Wizard, create a form showing instructor information (Instructor_ID, First_Name, Last_Name, Office_No).
• Switch between the views (Forms, Layout, and Design) to change the properties or the form’s appearance as desired.
• Save the form in the database named Form2Wizard.

STEP 7:
Form3: Create a form using a master detail relationship. A master detail relationship is simply a 1:N relationship between two tables. Use subforms to format the form in a split data entry form as shown in Figure 1-9. You may use SQL queries or the wizard or both to create your form and subform.
• Create a master form showing student information (Student_ID, First_Name, Last_Name, Address, Zip, Major, Status).
• Create a detail Subform showing Student_ID, Class_ID, and Student_Grade.
• For each student displayed, the student’s classes and grades should be displayed in the detail form.
• Switch between the views (Forms, Layout, and Design) to change the properties or the form’s appearance.
• Save the form in the database named Form3MaterDetail.

STEP 8:
When you are done, save the file on your local hard drive and upload it to the Course Project Dropbox. Your file should have the following filename format: Lab4_FirstInitialLastName.accdb.

 

PRICE  $19.99

    


complaint complaint






MIS582 iLab 3


MIS582 iLab 3: Database Construction Using Access

iLAB OVERVIEW
Scenario and Summary
In this assignment, you will learn to create an Access database from a given ERD. To complete this assignment, you will need to be able to run Access 2010, either through Citrix or installed on your workstation or laptop.

Deliverables
Name your Access database file using Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). Create and save your Access database file. When you are done, submit your database to the Course Project Dropbox.

iLAB STEPS

STEP 1:
Review the ERD below to understand the entities, attributes, primary keys, and relationships that you will create in your Access database.

 

STEP 2:
• Run Access 2010, either via Citrix or from Visio 2010 installed on your workstation.
• Select the blank database icon in the main window.
• Save the file with a name containing Lab3_, your first initial, and your last name (e.g., Lab3_JSmith.accdb). In Citrix, you will need to click the computer icon in the Save As window to see the different drives. Be sure to save the file to a local drive so it will be on your workstation.
See the tutorials above for instructions on how to perform the following steps in Access 2010.

 

STEP 3:
Add tables to the Access database.
• Add a table for each entity listed in the provided ERD diagram.
• Add a column for each attribute listed in the provided ERD diagram.
• Select a primary key for each table as indicated in the provided ERD diagram.

STEP 4:
For every column in every table, update the data type as needed to enforce the domain constraints of the data.
• Dates should have a date data type.
• Surrogate keys should be autonumbered.
• Numeric data should have a numeric data type.
• Character data should have a character data type.

STEP 5:
Draw relationships between your entities.
• Selection Relationships under Database Tools. Move all your tables into the Relationship window by dragging them in or by using the Show Tables pop-up window.
• Second item
o Add the relationship between the tables in your database.
o Enable referential integrity on the relationship.
o Enable cascade updates on the relationship.

STEP 6:
Add at least two rows of data to each table in your database. Use any values you like for each of the columns. Remember that you must add data to parent tables before adding data to child tables, because referential integrity is enabled.

STEP 7:
Set the following column constraints in your database.
• Student first and last name cannot be a null value.
• Course credit hours must be between one and four.
• Course name must be unique and cannot be a null value.
• Instructor first and last name cannot be a null value.
• Grade must be one of these values: A, B, C, D, F, I, W, or E. W signifies withdrawn and E signifies enrolled.

STEP 8:
When you are done, save the file on your local hard drive and upload it to the Course Project Dropbox. Your file should have the following filename format: Lab3_FirstInitialLastName.accdb.
For instructions on how to copy files between the Citrix server and your local machine, watch the iLab tutorial, Copying Files from Citrix, located in the iLab menu tab under Course Home.
Note!
Submit your assignment to the Dropbox located on the silver tab at the top of this page.

 

PRICE  $19.99

    


complaint complaint






MIS582 iLab 2


MIS582 iLab 2: Data Modeling Using Visio

iLAB OVERVIEW
Scenario and Summary

In this assignment, you will learn to create a physical database model in Visio from business requirements. To complete this assignment, you will need to be able to run Visio 2010, either through Citrix or installed on your workstation or laptop.

Deliverables
Name your Visio file using Lab2_, your first initial, and your last name (e.g., Lab2_JSmith.vsd). Create and save your database model in your Visio file.

iLAB STEPS

STEP 1:
Read the following business requirements closely to determine the entities and relationships needed to fulfill the requirements. The nouns in the paragraph will tell you the entities that will be needed. The verbs in the paragraph will help you determine the relationships between the entities.
Muscles Health Club Database Requirements:
The Muscles Health Club needs a database to keep track of its members, their personal trainers, and the fitness classes they are taking. Employees can act as personal trainers for members. However, only certified employees can act as personal trainers. A member can work with only one personal trainer at a time. Members can take multiple fitness classes. Fitness classes are taught by employees who can teach multiple classes. Fitness classes are taught in one of the classrooms at one of Muscles Health Club’s several locations. Each fitness classroom is designed for a different type of class (e.g., spinning, aerobics, water aerobics, weight training, etc.). It is necessary to track what fitness classes are being held in each of the different Muscles Health Club locations.

STEP 2:
• Run Visio 2010 either via Citrix or on your workstation.
• Click on the Software and Database Template group in the main window.
• Double-click on the Database Model Diagram Template to open a new file.
• Save the file with a name containing Lab2_, your first initial, and your last name as the file name (e.g., Lab2_JSmith.accdb). You will need to click the computer icon in the Save As window to see the different drives. Be sure to save the file to a local drive so it will be on your workstation.

STEP 3:
Add an entity for each entity you identified in the requirements.
• Drag the entity icon onto the drawing area in Visio.
• In the Database Properties window, add a physical name to identify it.

STEP 4:
For each entity, create a list of attributes you think would be useful to describe the entity.
• Select an entity in the drawing area of Visio.
• In the Database Properties window, select the Columns category.
• Use the table to add your attributes to the selected entities.
• Select one of the attributes to be the primary key (PK).

STEP 5:
Set the diagram to use crow’s feet notation.
• On the Database tab, in the Manage group, click Display Options.
• In the Database Document Option dialog, select the Relationship tab.
• Select the Crow’s Feet check box, and then click OK.

STEP 6:
Draw relationships between your entities.
• Drag the relationship icon onto a blank part of the drawing area.
• Connect the two ends to each of the two entities in the relationship. The parent entity must have a PK defined. The entity will be outlined in bold red lines when it connects to one end of the relationship.

STEP 7:
Set the cardinality of your relationships.
• Select a relationship line in the drawing area that is connecting two entities.
• In the Database Properties window, select the miscellaneous category.
• Select the cardinality for the selected relationship.

STEP 8:
When you are done, save the file on your local hard drive and upload it to the Course Project Drop box. Your file should have the following filename format: Lab2_FirstInitialLastName.vsd.
Submit your assignment to the Drop box located on the silver tab at the top of this page.

 

PRICE  $19.99

    


complaint complaint






CIS 355 Term Project Part I


CIS 355 Term Project Part I

 

For your term project, you are expected to design and implement a relational database to meet the requirements described in the PCI Warranty Call Center Case.

Deliverables

Part I – Project Design Document

This document should have the following components:

1. A conceptual ER model/diagram of PCI’s data requirements. The diagram should include all relevant entities, attributes and relationships. For each entity, specify the identifier (primary key). Specify relationship names and cardinality constraints. Indicate which attributes are required, composite, multi- valued, and/or derived (Note: by default, an attribute is assumed to be optional, simple, single-valued and not derived). Indicate which entities are associative. Follow consistent naming conventions for entities and attributes. Use modeling/diagramming software to create the ER Diagram.

2. A list of the normalized relations (the logical model) and their attributes. For each relation, primary and foreign keys should be clearly indicated. Note: Use the format that we will be discussing in class for presenting your logical model.

3. A list of assumptions (if any) made about the information requirements presented in the case. Note: the assumptions should be reasonable and should not contradict the facts of the case.

4. A data dictionary that defines the metadata for the logical model. The data dictionary should include: the definition of each relation and attribute; the primary and foreign keys in each relation; attribute data types and lengths; and whether attributes are optional or required. Organize the data dictionary alphabetically by relation name.

Assessment

Part I deliverables will be evaluated based on the completeness and correctness/accuracy of the conceptual and logical data models, and of the supporting documentation (i.e., data dictionary, assumptions (if any)).

If any of the deliverables are hand-drawn/written, your submission will not be graded. Submit the deliverables as one or more files. Include your name and title of the project on every page of the documents you submit.

 

PRICE  $19.99

    


complaint complaint






CTS2437 South Community College ERD and SQL script


CTS2437 South Community College ERD and SQL script

 

South Community College (SCC) is structured like a typical community college. They have 3 semesters and a multitude of courses. Each course may have any number of sections in a given semester. For example, CTS2437 (SQL Server) may have one or more sections being taught in any given semester. SCC has 3 semesters (fall, spring, summer) which they refer to as A, B, and C. They refer to semesters by the year and the semester code. For example, fall 2011 would be referred to as 2011A. They need to keep track of students, courses, schedules, instructors, and grades earned in each course taken. They need a database to maintain these information.
The student information would include the student name, address, phone#, and email. Students may have taken or are taking any number of courses. The grade earned for each course must also be maintained. The course information would include the course title and number of credits. Keep in mind that a given course may have many sections in any particular semester. SCC needs to maintain the instructor for each section in addition to the students and the grade they earned. The instructor information would include the instructor name, phone#, office#, and email address. South needs to maintain all courses that the instructor has taught or is currently teaching.

Some of the requirements that SCC has requested in the database system include:
• Student cannot register for the same section more than once.
• A roaster of students can be produced for any given section.
• GPA (Grade Point Average) can be generated for a student for any given semester, year, or entire school career.
• GPA is calculated by adding up all of the grades earned (A=4, B=3, C=2, D=1, F=0) and dividing by the number of credits associated with the courses taken.
• A transcript can be produced for a given student showing all courses taken and grades earned.

 

PRICE  $19.99

    


complaint complaint






CTS2437 – Final Exam


CTS2437  Final Exam 
Provide the SQL statements required to accomplish the following tasks.
#1 (10 points)
Create a database named FINAL_EXAM that you will then use for all remaining problems.

#2 (20 points)
Create the tables and appropriate constraints based on the following ER diagram. Use appropriate data types. Note that the size column should only accept S, M, or L. In addition the price column should have values greater than zero. All columns in both tables are required.

Catgeory Product

C

#3 (5 points)
Insert 3 rows in the Category table. The db is for a small shoe store, so use appropriate data for the description ( “Men”, “Women”, “Children”)
#4 (5 points)
Insert 3 Product records for each category in the product table. Use whatever data you see as appropriate.

#5 (5 points)
Use one statement to increase the price of all products in the Men category by 25%.

#6 (5 points)
Use one statement to delete all products for the Children category.

#7 (10 points)
Create and execute a view named EXAM_VIEW that shows all columns from both tables. Use an inner join.

#8 (10 points)
Create a database trigger named EXAM_TRIGGER that prevents a user from deleting a Product record on Tuesdays. Display an appropriate error message. Make sure to show that the trigger is working properly.

#9 (10 points)
Create a stored procedure named SP_EXAM that will be used to insert records into the Product table. Make sure to show that the procedure is working properly.

#10 (5 points)
Remove the EXAM_VIEW object from the database.

#11 (5 points)
Remove the SP_EXAM stored procedure from the database.

#12 (5 points)
Remove the EXAM_TRIGER database trigger from the database.

#13 (5 points)
Remove the FINAL_EXAM database.

 

PRICE  $19.99

    


complaint complaint






DBM 261 Week 3 Query Building Exercise


DBM 261 Week 3 Query Building Exercise

 

Build queries through SQL along with the query-building tool with sales databases built in Week Two for Riordan Manufacturing.

Create a separate table for query information. Include the query name and query description.

Enter data into the fields, naming and describing as many queries as you can, and then write two thirds of the queries using the query-building tool.

Write the remaining queries in SQL.

Create a new query without the tools and enter the SQL into its view.

Test your queries to verify that they return the data you described.

 

PRICE  $25.00

    


complaint complaint






DBM 261 Week 2 Database Creation Riordan Manufacturing


DBM 261 Week 2 Database Creation Riordan Manufacturing

 

Create a Microsoft Access database using Riordan Manufacturing’s 2005 sales figures.

Normalize the tables to the third normal form.

Create relationships among tables using the relationship tool. These relationships must include settings for referential integrity and cardinality.

Create an extended ERD of your newly created database, using
Microsoft Word, PowerPoint, or Visio.

Include primary keys, foreign keys, fields, relationships, and cardinality in the ERD.

 

PRICE  $25.00

    


complaint complaint






DBM 380 Week 4 Normalization of ERD


DBM 380 Week 4 Normalization of ERD

 

Individual Normalization of the 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.

 

PRICE  $19.99

    


complaint complaint






DBM/380 Week 3 ERD Art Museum in Access


DBM/380 Week 3 ERD Art Museum in Access

 

Develop an Art Museum ERD for DBM/380 Week 3

List the data specifications (must include a minimum of three entities with attributes)

Has to be on An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum If you Don’t have Visio then Do a ERD in Access. Need this last week. Make sure the Database flows.

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

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

 

PRICE  $19.99

    


complaint complaint






DBM 380 Week 2 Database Design


DBM 380 Week 2 Database Design

 

Individual Database Environment Paper

Write a 750- to 1,050-word paper in which you complete the following:

· Choose a database environment from the following:

o An appropriate database environment within your workplace (must be approved by your instructor)
o An Art Museum that needs to track the artwork, artists, and locations where the art is displayed or stored within the museum
o Smith Consulting (Virtual Organization) – needs a database to track their consulting staff, each staff member’s skill sets, and what projects they are working on

· Analyze the database environment.
· Describe the problems and constraints.
· Describe the objectives of the database environment.
· Describe the scope and boundaries.
· List the data specifications (must include a minimum of three entities with attributes).

Include 3 to 5 references.

Format your paper consistent with APA guidelines.

· Note. The database environment chosen will be used in the Weeks Three and Four Individual Assignments.

 

PRICE  $19.99

    


complaint complaint






DBM 381 Week 4 Database Management in Health Care


DBM 381 Week 4 Database Management in Health Care

 

Individual Data Collection Standards Memo and Form/Report/Queries

Write a 700- to 1,050-word memo to Taylor Ambulance explaining data collection standards used in the health care industry(7 pts)

Create two forms within the Microsoft® Access® database used in Week Three to capture data(4 pts). Please use the most relevant/important tables in the design. One of the forms should include an incorporated sub form.

Create two reports within the Microsoft® Access® database used in Week Three that shows information that management at Taylor Ambulance might want to see as they manage their business. One of the reports should include an incorporated sub report. (4 pts).
Submit your memo and Microsoft® Access® database file to your facilitator

 

PRICE  $22.00

    


complaint complaint






DBM 381 Week 3 Normalization Memo and Relationships


DBM 381 Week 3 Normalization Memo and Relationships

 

Individual Memo and Relationships

Update the detailed ERD created during Week Two to normalize it to the third normal form.

Write a 300- to 350-word memo to your client that explains the level of normalization and explain why that level is sufficient for this system.

Update the Microsoft® Access® database created during Week Two. Assign appropriate keys and relationships among tables established using the Relationships Tool. Once the database has been created, add relevant data to each table, at least 10 records for each.
Submit the ERD, memo, and Microsoft® Access® database file to your facilitator.

 

PRICE  $22.00

    


complaint complaint






DBM 381 Week 1 Database Architecture in Health Care Paper


DBM 381 Week 1 Database Architecture in Health Care Paper

 

Individual Database Paper
Write a 700- to 1,050-word paper in which you do the following:
· Define health care database systems. Describe how databases are used across the health care industry.
· Explain the different database architectures including the relational architecture.
Describe the needs of database users across the health care continuum.
Format your paper consistent with APA standards.

 

PRICE  $19.99

    


complaint complaint






CIS210 Lab 3 SQL Fundamentals


CIS210 Lab 3 SQL Fundamentals

 

Chapter 5
Add a new food to the l_foods table with a new supplier by completing questions 1 and 2:
1. First you will need to create and run an INSERT statement to add the new supplier to the l_suppliers table. The supplier’s id is CFF, and the name of this supplier is Cathy’s Fresh Fish. You first need to add the row to the l_suppliers table because there is a rule that says, “When a new row is added to the l_foods table, the supplier_id must already exist in the l_suppliers table”.
Hint: If you have trouble with the apostrophe, see section 3-17 in the 3rd edition of the book.
Paste your SQL statement below here:

 

2. Then you will create and run an INSERT statement to add a new food to the l_foods table from the new supplier using the following information: add Fresh Salmon as menu item 11 with a supplier_id of CFF, a product_code that is SA, a price of $8.25, and no price_increase value.
Paste your SQL statement below here:

 

3. Now, create and run two DELETE statements to delete the two rows you have inserted. List the two statements in the order you ran them.
Note: be very careful to only delete the rows you have entered. If you compromise your database contents by deleting additional rows, you will need to start with a new sample database download (Access) or creation (Oracle).
Paste your SQL statements below here:

 

4. Explain why the DELETE statements need to be run in that order.

 

Chapter 6
1. Create and run a CREATE TABLE statement to build a table of your favorite songs named favorite_songs. Include these columns as the first four columns: song_ID, name for the name of the song, performer for the artist (or band), and duration for the length of the song in minutes. You may include other columns if you wish.
Paste your SQL statement below here:

 

2. Create and run INSERT statements to load data for a least five of your favorite songs into the table you created in exercise 6-1.
Note: if you don’t have favorite songs, use songs from the top 100 found here: http://www.songlyrics.com/news/top-songs/all-time/
Paste your SQL statements below here:

 

3. Create and run an ALTER TABLE statement to add a primary key for your table of favorite_songs.
Paste your SQL statement below here:

 

4. Create and run an ALTER TABLE statement to add a new column, album_name, to the table of favorite_songs.
Paste your SQL statement below here:

 

5. Create and run two UPDATE statements to add the album_name to two of the rows in your table of favorite_songs.
Note: if you aren’t up on music and used the top 100 list, make up album names.
Paste your SQL statements below here:

 

6. Create and run an INSERT statement to add a new row to your table of favorite_songs that puts values in all of the columns.
Paste your SQL statement below here:

 

PRICE  $25.00

    


complaint complaint






CIS210 Lab 2 SQL Fundamentals


CIS210 Lab 2 SQL Fundamentals

 

Chapter 3
1. Modify the following SQL code so that the not applies directly to the simple conditions in the where clause. In other words, bring the and or or outside the scope of the not.
Perform the exercise using the following beginning code:
SELECT *
FROM l_employees
WHERE NOT
(dept_code = ‘SAL’ )
OR NOT( manager_id = 202);

 

2. Modify the following SQL code to replace the hard-coded values with columns from a table of constants.
SELECT employee_id,
first_name,
last_name,
‘citywide uniforms’ AS company
FROM l_employees
WHERE NOT (dept_code = ‘SAL’)
OR NOT (manager_id = 202);

 

Table of constants (ex0302a table)
Company = ‘citywide uniforms’
Excluded_dept = ‘SAL’
Excluded_manager = 202

 

3. From the l_suppliers table, list the row for Jim Parker’s Shop.

 

4. From the l_lunch_item table list the rows having a supplier_id of CBC and product_code of GS (these are the grilled steaks). Sort the rows by the lunch_id.

 
Chapter 4
1. Create a new table containing the following columns from the l_foods table: menu_item, description, and price. Change the name of the description column to food. Include all the foods that cost less than $5.00. Call the table ex0401b.

 

2. Create a view similar to the table you created in exercise 1. Save the view as ex0402b.

 

3. Use the table you created in exercise 1 to list the food and price columns. Sort the list alphabetically on the name of the food.

 

4. a) First do the following query. Create a table containing the following columns: employee_id, first_name, last_name, and dept_code, in that order from the l_employees table. Change the name of the dept_code column to department_code. Include all the employees working in the sales and marketing departments. Name the table ex0401a.
b) Second, create a view similar to the table you just created. Name the view ex0402a.
c) Add yourself to the l_employees table. Put yourself in the sales department as employee_id 950, with manager_id 201. Make up data for the other columns.
d) Describe the effect on the l_employees table, ex0401a table, and ex0402a view.

 

5. a) Change yourself from the sales department to the marketing department.
b) Describe the effect of this change on the l_employees table, ex0401a table, and ex0402a view.

 

PRICE  $25.00

    


complaint complaint






CMIS420 Advanced Relational Database Final Programming Project


CMIS420 Advanced Relational Database Final Programming Project

 

In this project, you will design a secure database with several tables using good relational database design techniques.

 

Project Objectives:
After completing this Project, you should be able to:
Explain the purposes of advanced database objects including indexes, clusters, sequences, and views
Develop and implement functions, triggers, and stored procedures/packages

 

Project Requirements:
1. Using the Oracle database engine, design and develop a relational database to store user information to support a large online shipping company. Information that needs to be stored includes user name, detailed mailing address, and shipping information including number of packages, weight, cost, destination, origin, and tracking information allowing users to determine where a package is, and when and who signed for the package once it arrives. Other business data should be present showing how much the shipment costs and invoicing capability to send bills to customers. Your design should be normalized and well-designed for scalability for additional customers and shipment locations.

 

2. Your design should allow for inserting, updating, selecting and deleting information

 

3. A trigger should be used to generate invoices once a customer reaches $200 in shipping costs.

 

4. An instead-of trigger should be employed to update and/or populate multi-table views.

 

5. You should include packages, indexes, views and other helpful database components that will assist you in your design.

 

6. Your scripts should work perfectly allowing the creation of all of the tables, triggers, views and other database components and provide test scripts that demonstrate the use of the system.

 

7. You do not need a GUI component but your scripts should demonstrate all of the functionality of the system.

 

Deliverables:
All sql scripts and run scripts and instructions for successfully building your database and testing your database.
An ERD diagram of your database design showing primary keys, foreign keys and other constraints.
3. Well-written word document describing:
a. The database design
b. How to set up and test your database
c. The test data and results you used for your database,
d. Your approach, lessons learned, design strengths, limitations and suggestions for future improvement and alternative approaches, the most challenging aspects of developing this application.

 

PRICE  $19.99

    


complaint complaint