Database

Need Help in Database Assignment?
We can help you if you are having difficulty with your Database Assignment. Just email your Database Assignment at admin@assignmentcache.com.
We provide help for students all over the world in Database Assignment.

Items 1 to 10 of 34 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction
  1. Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

    Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 10 Lab 1 Administering the ECO Clothesline Database


    Lab 1: Administering the ECO Clothesline Database
    Problem: ECO Clothesline has determined a number of database administration tasks that need to be done. These include creating a template, splitting the database, creating indexes, and adding table and field properties.


    Instructions: If you are using the Microsoft Offce Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 9. Otherwise, contact your instructor for more information about accessing the required files.


    Perform the following tasks:
    1. Open the Open Orders table in Datasheet view and add the Quick Start Priority field to the table. Assign a High priority to orders for customers AM23 and JN34. Assign a Low priority to the order for TT21. All other orders have a Normal priority.
    2. The Main Menu navigation form should display automatically when a user opens the database.
    3. Open the Customer table in Design view and create custom input masks for the following fields: Customer Number, State, Postal Code, and Sales Rep Number. The Customer Number field should consist of two uppercase letters followed by two numbers. The State field should contain two uppercase letters. Both the Postal Code and Sales Rep Number fields only can contain numbers.
    4. Create an index on the Customer Name field that does not allow duplicates. Create an index on the combination of Customer Type and Customer Name. Name the index TypeName.
    5. Save the ECO Clothesline database as a template with data but not as an application part. Create a new database from the ECO Clothesline template. Name the database ECO New. Split the ECO New database.
    6. Open the front-end database and add a logo to the Customer Master Form. You can create your own logo or use one o the sample pictures included with Microsoft Access. (Hint: See the BTW on page AC 645 for assistance with this task.)
    7. Submit the revised databases in the format specified by your instructor.

    Learn More
  2. ITCO231 Unit 3 HR Database Tables

    ITCO231 Unit 3 HR Database Tables

    Regular Price: $25.00

    Special Price: $20.00

    ITCO231 Unit 3 HR Database Tables


    Create the needed tables in the SQL server environment (just tables, no relationships yet).


    Use integer (INT) data types for all ID columns.
    Use DATE data types for all date-related columns.
    Rate related columns should be DECIMAL data types.
    All other data types should be VARCHAR.
    In addition, create 3 additional tables that could be consistent in a database for a human resources (HR) application, including an appropriate table name and appropriate columns.
    Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.
    Submit a consolidated Word document with the screenshot and the DDL for all tables (text only, no screenshots).

    Learn More
  3. Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2 qryDuplicatePostalCodes

    Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2

    Regular Price: $25.00

    Special Price: $20.00

    Succeeding in Business with Microsoft Access 2013 Steps to Success Level 2


    Hudson Bay Pharmacy is ready to crearte more complex queries to analyze employee data. Kim Siemers, human resources manager for Hudson Bay, asks for your help in creating queries that extract the employee information she needs from their database. As you create and save the new queries be certain to use the "qry" perfix as a part of the naming convention. Also consult your instructor for instruction about submitting results.


    1. Start access and open Hudson.accdb database from STS folder.


    2. Kim wants to identify employees who live in the same neighborhood in Edmonton so they can create car pools and share rides to work. In Edmonton, the postal codes roughly correspond to neighborhood. Prepare a list of employees who live in the same neighborhood so that Kim can create a list of employees who can share rides to work. Name the query qryDuplicatePostalCodes.


    3. A new policy at Hudson Bay Pharmacy is that all employees must acquire and maintain certifications in adult, infant, and child CPR and in using defibrillators. Kim asks you to identify employees who have not completed any certification training. Save the query as qryNoTraining.


    4. Kim also needs to list all employees and the classes they have taken. The results should include current employees who have not attended training as well as those who have. Save the query as qryEmployeeTraining.


    5. Kim also needs to identify employees whose CPR or defibrillators certification has expired, depending on the time period she specifies. Show all employees whose Adult CPR, Child/Infant CPR, or Defibrillators Use certification has expired in any specified time period. Save the query as qryUpToDate.


    6. Mai Yan, manager of Hudson Bay Pharmacy, wants to identify the five current nonsalaried employees who are earning the highest wages per hour. These are the five employees who have been working for the pharmacy the longest or who have regularly received raises for their work. List the top five wage earners of all the current nonsalaried employees. Save the query as qryTop5HourlyRates.


    7. To prepare for employee reviews, Kim needs to calculate the minimum, maximum, and average hourly rates for each job category. Provide this information for her, saving the query as qryMaxMinAvgHourlyRate.


    8. Mai is considering offering life insurance as an employee benefit, and needs to know the current age of all employees. Provide this information for her. Be certain to provide an appropriate name for the column with the result and to show the ages in descending order. Include the job title and format the results so that they include one decimal place. Also show the first name and last name together. Save the query as qryEmployeeAge.


    9. Kim asks you to provide one other statistical analysis. Show the average age of employees by job title. Save this query as qryAvgEmployeeAge.


    10. Close the Hudson.accdb database and Access.

    Learn More
  4.  MIS562 Week 2 Homework Oracle Queries

    MIS562 Week 2 Homework Oracle Queries Database

    Regular Price: $25.00

    Special Price: $20.00

    MIS562 Week 2 Homework Oracle Queries

    Create the tables from demo.sql script as follows:
    Download and copy the demo.sql file from the Doc Sharing to the C:\temp directory. At the sql prompt enter the command @V:\temp\demo.sql.  This will create some tables and insert data into them. View the script in notepad to determine the table names that were created. Use the describe command to view the structure of the tables. Please use the instructions in the Submission Requirements to create and submit a document with your solutions. Submissions that do not meet the Requirements will be returned with a grade of zero and will be accepted and graded when corrected and re-submitted. Anyone having difficulties can obtain assistance in the TDAs.



    Write SQL statements to create result tables showing the solutions to the following requests.
    1. (4 pts) List all employee information in department 30.
    2. (4 pts) List employees name, job, and salary that is a manager and has a salary > $1,000
    3. (4 pts) Repeat exercise 2 for any employee that is not a manager or earns a salary > $1,000
    4. (4 pts) Show all employee names and salary that earn between $1,000 and $2,000.  Use the between operator.
    5. (4 pts) Select all employees that are in department 10 and 30. Use the IN operator.
    6. (4 pts) Select all employee names with an “A” in the first position of the employee name.  Use the substring function or a wild card.
    7. (4 pts) Select all employees with an “A” as the second character of their name.  Use a wildcard.
    8. (4 pts) List the employee names in alphabetical sequence.
    9. (4 pts) List the job, salary, and employee name in job order and then salary in descending order.
    10. (4 pts) Show a list of different jobs.  Eliminate repeating values.
    11. (4 pts) Show employee names, salary that has not earned a commission yet.
    12. (4 pts) Show the employee name, salary, commission, and the total of salary and commission. Be sure you evaluate null values correctly.
    13. (4 pts) Write an SQL query that retrieves data from the COURSE table for courses that cost 1195, and whose descriptions do not start with ‘Intro’, sorted by their prerequisites in descending order.
    14. (4 pts) Write an SQL query that retrieves data from the STUDENT table for students whose last names begin with “A” though “T” and who work for ‘Competrol Real Estate’, sorted by the last names.
    15. (4 pts) Determine which student does not have the first letter the last name capitalized.  Show the STUDENT_ID and LAST_NAME columns.
    16. (4 pts) Check if any of the phone numbers in the INSTRUCTOR table have not been entered in the (###)###-#### format.  Show the instructor last name and the phone number that is in the incorrect format.
    17. (4 pts) Write an SQL statement that uses the CAST function that converts a number datatype to a varchar datatype.
    18. (4 pts) Write a SQL statement that converts a date datatype to a char datatype.
    19. (4 pts) Write a SQL statement that convert a number value to a character.

    Before doing problems 20 - 25 Download and Execute the script demoaddrows.sql from the Doc Sharing to add rows into the two tables above. Write SQL statements and produce result tables to solve the following requests.
    20. (2 pts) Show a list of different jobs.  Eliminate repeating values.
    21. (2 pts) How many employees are working at each job in each department and what the sums and averages are for the salary of those employees?
    22. (2 pts) Show the employee name with the maximum salary
    23. (2 pts) Show the average salary for all employees that are not managers.
    24. (2 pts) What is the difference between the highest and lowest salary?
    25. (2 pts) Select employee number, name for all employees with salaries above the average salary. Use a subquery.

    Before doing problems 26 through 31 Create the text Student tables with the createStudent.sql script. The script and instructions are in the schemaset.zip file available in the Doc Sharing. Download and unzip the files from the Doc Sharing to a C: drive directory such as the \temp directory. At the sql prompt enter the command @V:\temp\createStudent.sql. This will create  tables exactely as they are portrayed in the text and insert data into them.
    26. (2 pts) Show the state and the number of zip codes by state. Order the result by number of zip codes in descending sequence. Use the ZIPCODES table.
    27. (2 pts) Which city has the most zip codes assigned to it? Use a TOP-N query.
    28. (2 pts) Show the state and the number of zip codes by state. Order the result by number of zip codes in descending sequence and exclude all states having less than 5 zip codes.
    29. (2 pts) Show the Student_ID, last name, and the number of enrollments for the student. Show only students with more than 2 enrollments. Use an Inline view.
    30. (2 pts) Show the number of students enrolled and zip code for New York and where the city begins with 'W'. Use a Scalar subquery.
    31. (2 pts) Display the course number and description of courses with no enrollment. Also include courses which have no section assigned.

    Learn More
  5. Assignment 9-8 Maintaining an Audit Trail of Product Table Changes

    Oracle 11g PL/SQL Joan Casteel Chapter 9 Hands-On Assignments Part 9-5 to 9-8

    Regular Price: $30.00

    Special Price: $25.00

    Oracle 11g PL/SQL Joan Casteel Chapter 9 Hands-On Assignments Part 9-5 to 9-8

    Assignment 9-5: Processing Discount
    Brewbean's is offering a new discount for return shoppers. Every fifth completed order gets a 10% discount. The count of orders for a shopper is placed in a packaged variable named pv_disc_num during the ordering process. The count needs to be tested at checkout to determine whether a discount should be applied. Create a trigger named BB_DISCOUNT_TRG so that when an order is confirmed (the ORDERPLACED value is changed from 0 to 1), the pv_disc_num packaged variable is checked. If it's equal to 5, set a second variable named pv_disc_txt to Y. This variable is used in calculating the order summary so that a discount is applied, if necessary.
    create a package specification named DISC_PKG containing the necessary packaged variables. Use an anonymous block to initialize the packaged variables to use for testing the trigger. Test the trigger with the following UPDATE statement:
    UPDATE bb_basket
    SET orderplaced = 1
    WHERE idBasket = 13;
    If you need to test the trigger multiple times, simply reset the ORDERPLACED column to 0 for basket 13 and then run the UPDATE again. Also, disable this trigger when you're finished so that it doesn't affect other assignments.


    Assignment 9-6: Use Triggers to Maintain Referential Integrity
    At times, Brewbean's has changed the ID numbers for existing products. In the past, developers had to add a new product row with the new id to the BB_PRODUCT table, modify all the corresponding BB_BASKETITEM and BB_PRODUCTOPTION table rows, and then delete the original product row. Can a trigger be developed to avoid all these steps and handle the update of the BB_BASKETITEM and BB_PRODUCTOPTION table rows automatically for a given change in product ID? If so, create the trigger and test by issuing an update statement, which changes the IDPRODUCT of 7 to 22. Do a rollback to return the data back to its original state. Also, disable the new trigger after you have completed the assignment.


    Assignment 9-7: Updating Summary Data Tables
    The Brewbean's owner uses several summary sales data tables every day to monitor business activity. The BB_SALES_SUM table holds the product ID, total sales in dollars, and total quantity sold for each product. A trigger is needed so that every time an order is confirmed or the ORDERPLACED column is updated to 1, the BB_SALES_SUM table is updated accordingly. Create a trigger named BB_SALESUM_TRG that perform this task. Before testing, reset the ORDERPLACED column to 0 for basket 3, as shown in the following code, and use this basket to test the trigger.
    UPDATE bb_basket
    SET orderplaced = 0
    WHERE idBasket = 3;
    Notice that the BB_SALES_SUM table already contains some data. Test the trigger with the following UPDATE statement, and confirm that the trigger is working correctly:
    UPDATE bb_basket
    SET orderplaced = 1
    WHERE idBasket = 3;
    Do a rollback and disable the trigger when you're finished so it doesn't affect the other assignments.


    Assignment 9-8: Maintaining an Audit Trail of Product Table Changes
    The accuracy of product table data is critical and the Brewbean's. owner wants to have an audit file that containing information on all DML activity on the BB_PRODUCT table. This information should indicate the ID of the user performing a DML action, the date, the original values of the changed row, and the new values. This audit table needs to track specific columns of concern, including PRODUCTNAME, PRICE, SALESTART, SALEEND, and SALEPRICE. Create a table named BB_PRODCHG_AUDIT that can hold the relevant data. Then create a trigger named BB_AUDIT_TRG that fires an update to this table whenever one of the specified columns in the BB_PRODUCT table is changed.
    Be sure to issue the following command. If you created the SALES_DATE_TRG trigger in the chapter, it conflicts with this assignment.
    ALTER TRIGGER SALES_DATE_TRG DISABLE;
    Use the following update statement to test your trigger:
    UPDATE bb_product
    SET salestart = '05-MAY-03', saleend = '12-MAY-03', saleprice = 9
    WHERE idproduct = 10;
    When you have finished, do a rollback and disable the trigger so that it does not affect other assignments.

    Learn More
  6. IM300 Week 5 Hotel Database Part 4 Cover Sheet

    IM300 Week 5 Optimizing the Database Hotel Database Part 4

    Regular Price: $25.00

    Special Price: $20.00

    IM300 Week 5 Optimizing the Database Hotel Database Part 4


    Resources: SR-bi-003 – Hotel Database, the results from SR-bi-003 – Hotel Database Part 3, and Oracle® Database Express® Virtual Desktop


    Complete the service request by implementing referential integrity and constraints in your database:
    Create an AFTER trigger on the Hotel table that deletes any records from the Rooms table that match (:old.HOTEL_ID).
    Apply at least six constraints within the database.
    Create a newly generated DDL script.


    Create a fax cover sheet addressed to the project manager for the referential integrity and constraints work you have completed and include a newly generated DDL script to show your progress on the project.

    Learn More
  7. Access 2010 Chapter 6 Business Analyst Master List Report AC 380

    Microsoft Access 2010 Chapter 6 Advanced Report Techniques Camashaly Design database AC 338 - AC 416

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 6 Advanced Report Techniques Camashaly Design database AC 338 - AC 416


    Read and work through project 6 pp. AC 338- AC 416.
    Business Analyst Master List Report, p. AC 380
    Discount Report, p. AC 401


    Project — Multitable FormsProject — Advanced Report Techniques
    The owners of Camashaly Design want a master list of business analysts. This list should be available as an Access report. For each business analyst, the report is to include full details for all the clients assigned to the business analyst. In addition, Camashaly offers a range of educational courses designed to help clients understand the various marketing tools available to them. For clients who are taking courses, the report should list the specific courses being offered to the client. The actual report is shown in Figure 6 – 1a. The report is organized by business analyst, with the data for each analyst beginning on a new page. For each business analyst, the report lists the number, fi rst name, and last name. Following the business analyst number and name, the report lists data for each client served by that business analyst. The client data includes the number, name, street, city, state, postal code, client type, services needed, amount paid, current due, and total amount. For each course the client is taking, the report lists the course number, description, total hours the course requires, hours already spent, and hours remaining.


    Many organizations offer discounts as a way of rewarding current clients and attracting new clients. The owners of Camashaly are considering offering a discount on
    the current due amount to its current clients. The exact amount of the discount depends on how much the client already has paid. If the amount paid is more than $4,000, the discount will be 4% of the current due amount. If the amount paid is $4,000 or less, then the discount will be 2% of the current due amount. To assist in determining the discount, Camashaly needs a report like the one shown in Figure 6 – 1b on page AC 340. The report groups clients by business analyst. It includes subtotals of both the Amount Paid and Current Due fields. Also, although not visible in the fi gure, it includes grand totals of both fields at the end of the report. Finally, it shows the discount amount, which is calculated by multiplying the current due amount by .04 (4%) for those clients for whom the amount paid is more than $4,000 and by .02 (2%) for all others.


    Overview
    As you read through this chapter, you will learn how to create the reports by
    performing these general tasks:
    • Create and relate additional tables.
    • Create queries for a report.
    • Create a report, specify grouping and sorting, and add fields and text boxes to the report.
    • Add a subreport to the report.
    • Add a title, page number, and date to the report.
    • Print and publish a report.
    • Create a second report, specify grouping and sorting, and add fields and text boxes to the report.
    • Add totals and subtotals to the report, and add a text box that uses a function.

    Learn More
  8. MS Access 2010 Chapter 9 Lab 1 Navigation Form for the ECO Clothesline Database

    Microsoft Access 2010 Chapter 9 Lab 1 Creating Macros a Navigation Form and a PivotTable for the ECO Clothesline Database

    Regular Price: $25.00

    Special Price: $20.00

    Microsoft Access 2010 Chapter 9 Lab 1 Creating Macros a Navigation Form and a PivotTable for the ECO Clothesline Database


    Lab 1: Creating Macros, a Navigation Form, and a PivotTable for the ECO Clothesline Database
    Problem: ECO Clothesline would like an easy way to access the various tables, forms, and reports included in the database. This would make the database much easier to maintain and update.


    Instructions: If you are using Microsoft Access 2010 Comprehensive text, open the ECO Clothesline database that you used in Chapter 8. Otherwise, contact your instructor for more information about accessing the required files.


    Perform the following tasks:
    1. Create a macro named Forms and Reports that will include submacros to perform the following tasks:
    a. Open the Sales Rep Order Data form in read-only mode.
    b. Open the Sales Rep Master Form.
    c. Open Customer Master Form.
    d. Preview the Sales Rep Master List.
    e. Preview the Customer Balance Report.
    f. Preview the Customer Discount Report.
    g. Export the Sales Rep Master List in the PDF format.
    h. Export the Customer Balance Report in the PDF format.
    i. Export the Customer Discount Report in the PDF format.


    2. Create the menu form shown in Figure 9-80. The command buttons should use the macros you created in Step 1 to open the Customer Master Form, the Sales Rep Master Form, and the Sales Rep Order Data form.


    3. Create the menu form shown in Figure 9-81. The option group should use the macros you created in Step 1 to preview and export the three reports.


    4. Create a datasheet form for the Customer table and name the form Customer. Create a UI macro for the Customer form. When a user clicks a customer number on a row in the datasheet, the Customer Master Form should appear in a pop-up form.


    5. Create a datasheet form for the Sales Rep table and name the form Sales Rep. Create a UI macro for the Sales Rep form. When a user clicks a sales rep number on a row in the datasheet, the Sales Rep Master Form should appear in a pop-up form.


    6. Create the navigation form shown in Figure 9-82 for the ECO Clothesline database. Use the same design for your navigation form as the one illustrated in this chapter. For example, the Customer tab should display the Customer form you created in Step 4, and the Sales Rep tab should display the Sales Rep form you create in Step 5. The Forms tab should display the Form List form you created in Step 3, and the Reports tab should display the Reports List form you created in Step 3.


    7. Submit the revised database in the format specified by your instructor.

    Learn More
  9. CS371 Database Design Executive Summary

    CS371 Database Design Executive Summary

    Regular Price: $25.00

    Special Price: $20.00

    CS371 Database Design Executive Summary


    Write a proposal for the new database design to include:
    An executive summary for the database project


    Develop main project details
    Explain the issues that exist with maintaining the data in its current form.
    Explain the process of migrating the data in its current form to a well formed data model by highlighting the following in detail:
    Identify required attributes that need to be tracked
    Identify functional dependencies
    Show the redesign in 1NF, 2NF, and 3NF (similar to figures 7.29, 7.31, 7.33)


    Explain the project benefits of the data in its new form.


    Create the E-R diagram of your relational tables using MySQL Workbench and include in proposal.


    Propose some additional data items, which you believe may be beneficial to the University if tracked in your database (i.e. Descriptions, more info about the instructors and students, departments, etc). Describe the steps required to implement these additions.


    Identify project risks


    In addition to the proposal, in a separate file submit:
    Provide the SQL statement required to create at least one of your tables.
    Provide the SQL statement required to delete at least one of your tables.
    Provide the SQL statement required to create a view which includes Course #, Course Name, Time, and Days only.
    Identify at least one index, which you believe would improve performance. Explain your choice.
    If you add a course description attribute to your course table, there may be some performance impacts imposed by the addition of this "text" field.

    Learn More
  10. MIS582 Week 4 Course Project ABC Company Order Inventory System Database

    MIS582 Week 4 Course Project ABC Company Order Inventory System Database

    Regular Price: $25.00

    Special Price: $20.00

    MIS582 Week 4 Course Project ABC Company Order Inventory System Database


    PROJECT 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 as Lastname_Task2.vsd. Create and save your database model in your Visio file. When you are done, submit your document to the Week 4: Course Project Task 2 Dropbox.


    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 adjectives that describe those nouns are the attributes of that entity. The verbs in the paragraph will help you determine the relationships between the entities.


    ABC Company Order Inventory System
    Database Requirements
    The ABC company has many stores in many locations that are divided in regions. The company supplies products to these stores. For the purposes of this database you may think that it is an American company in terms of regions such as Midwest.
    Each store is their customer/client. The company recognizes these stores by their store ID. They also keep track of the store name, address, and contact name.
    Stores may place orders online, or by phone/fax. Each order must be uniquely identified by an order number. Each order has a date on which the order was made, a date when the order was shipped, an employee who took the order (or it could be an online order), and the mode of payment.
    To make sure that the stores get their order on time, the stores are assigned to different warehouses in different regions. Currently, there is one warehouse for every region. Each warehouse is identified by its warehouse number. The company also tracks the address of the warehouse as well as a contact phone number.
    There are five regions: West, Midwest, Southwest, Southeast, and Northwest. Each region is identified by its unique name and unique number.
    Each warehouse holds many products for this company. A product may be found in many warehouses. The company keeps track of this inventory. At any point in time, the company must be able to find which warehouses carry this item, the quantity in stock, reorder point and whether this item is out of stock.
    Each product has a unique id, a description, a price. Each product could be on many orders, and an order may have multiple products on it. The company needs to track what quantity was ordered for each product and the total price for those products.
    Phone/Fax orders are processed by the employees of the company. The company keeps track of the employee’s id, first and last names, position, hire date, department they work for, their supervisor, and their salary.


    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 the name Lastname_Task2.vsd. 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 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 Week 4: Course Project Week 4 Task 2 Dropbox. Your file should have the following filename format: Lastname_Task2.vsd.
    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.


    Rubrics
    Points for will be awarded according to the following rubrics.
    • 10 Points: Visio drawing: E-R model is provided as a Visio diagram.
    • 10 Points: Entities: A minimum of six entities are present.
    • 10 Points: Attributes: There are more than two attributes per entity; in most cases there should be several.
    • 10 Points: Relationships: A minimum of six correct relationships are present.
    • 10 Points: Correct cardinality is specified on each relationship with crow's foot notation.


    Tutorials to Consult With
    DBP-e13-Appendix-F.pdf in the folder titled Visio Instructions Documents in Doc Sharing for how to use Visio 2013.
    kroenke_dbp12e_appendix_f.pdf in the folder titled Visio Instructions Documents in Doc Sharing for how to use Visio 2010.

    Learn More

Items 1 to 10 of 34 total

per page
Page:
  1. 1
  2. 2
  3. 3
  4. 4

Grid  List 

Set Ascending Direction