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 158 total

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

Grid  List 

Set Ascending Direction
  1. DBM405A Lab 1 SQL Review Report

    DBM 405A Lab 1 SQL Review

    Regular Price: $15.00

    Special Price: $12.00

    DBM 405A Lab 1 SQL Review


    I. OBJECTIVES
    a. Get access to a MySQL environment.
    b. Familiarize yourself with the environment.


    II. PARTS LIST
    1. EDUPE Omnymbus Environment (https://devry.edupe.net:8300); and/or
    2. MySQL (dev.mysql.com/downloads).


    III. PROCEDURE
    You may do the labs in this class on your own computer equipped with MySQL or you may use the MySQL environment hosted by the vendor Omnymbus. You may even use both.


    Using MySQL on your own computer means downloading a version from dev.mysql.com/downloads and installing the database engine on your computer. This can be done easily and there are a number of resources on the web to help you with this process.


    You may also use the MySQL environment hosted by Omnymbus by logging in with your credentials to https://devry.edupe.net:8300.


    Using the first approach will give you experience writing programs on a desktop computer and accessing a database. Using the second approach will give you experience writing applications that access a database in a cloud environment.


    You are encouraged to use both approaches.


    Desktop MySQL Environment
    1. Download the MySQL Community Server from the http://dev.mysql.com/downloads/ website.
    2. Install MySQL on your computer.
    3. Open the MySQL Environment on your computer.


    Omnymbus Environment
    1. Login to the MySQL Omnymbus Environment by following the instruction located in Doc Sharing (document titled “Login MySQL Omnymbus Environment”).


    Lab Procedure Continued (common to both environments)
    1. Create a database named “Baseball”.


    2. Create a table named “Teams” and add the following fields:
    a. TeamCode (character 5)
    b. TName (character 20)
    c. TAddress (character 30)
    d. TCity (character 20)
    e. TState (character 2)
    f. TZip (character 9)
    g. Wins (integer)
    h. Losses (integer)


    3. Populate the table with 8 teams.


    4. Create a table named “Players” and add the following fields:
    a. FirstName (character 20)
    b. LastName (character 30)
    c. MidInit (character 1)
    d. PAddress (character 30)
    e. PCity (character 20)
    f. PState (character 2)
    g. PZip (character 9)
    h. Phone (character 11)
    i. Team (character 5)


    5. Populate the table with 80 players (10 on each team). For the team, use the TeamCode from the first table to identify the Team the player is on.
    6. Display or list the data from both table to the screen or printer.

    Learn More
  2. DBM 405A Lab 2 SQL Review Part 6 Script

    DBM 405A Lab 2 SQL Review

    Regular Price: $15.00

    Special Price: $12.00

    DBM 405A Lab 2 SQL Review


    I. OBJECTIVES
    1. Get access to a MySQL environment.
    2. Familiarize yourself with the environment.


    II. PARTS LIST
    3. EDUPE Omnymbus Environment (https://devry.edupe.net:8300); and/or
    4. MySQL (dev.mysql.com/downloads).


    III. PROCEDURE
    You may do the labs in this class on your own computer equipped with MySQL or you may use the MySQL environment hosted by the vendor Omnymbus. You may even use both.


    Using MySQL on your own computer means downloading a version from dev.mysql.com/downloads and installing the database engine on your computer. This can be done easily and there are a number of resources on the web to help you with this process.


    You may also use the MySQL environment hosted by Omnymbus by logging in with your credentials to https://devry.edupe.net:8300


    Using the first approach will give you experience writing programs on a desktop computer and accessing a database. Using the second approach will give you experience writing applications that access a database in a cloud environment.


    You are encouraged to use both approaches.


    In the previous lab (Week 1), you have established a database environment (either MySQL Community Server or the Omnymbus environment). You may continue to use that environment or you my return to Week 1 to set up the alternate environment.


    Lab Procedure Continued (common to both environments)
    1. Use the database named “Baseball” created in last week’s lab.
    2. Use the table named “Teams” which consists of the following fields:
    a. TeamCode (character 5)
    b. TName (character 20)
    c. TAddress (character 30)
    d. TCity (character 20)
    e. TState (character 2)
    f. TZip (character 9)
    g. Wins (integer)
    h. Losses (integer)
    3. You should have a table with 8 teams.
    4. Use the table named “Players”, which consists of the following fields:
    a. FirstName (character 20)
    b. LastName (character 30)
    c. MidInit (character 1)
    d. PAddress (character 30)
    e. PCity (character 20)
    f. PState (character 2)
    g. PZip (character 9)
    h. Phone (character 11)
    i. Team (character 5)
    5. You should have a table with 80 players (10 on each team). Players are identified by the Team field which matches the TeamCode in the Teams table.
    6. Demonstrate the use of the WHERE clause by selecting and displaying only the players from one team.
    7. Demonstrate the use of the COUNT function by determining how many players are on each team and displaying the results.
    8. For each City, find the number of players who list their home in that city.
    9. Demonstrate the ORDER BY clause by listing all the players in alphabetical order by last name within Team.

    Learn More
  3. DBM405A Lab 3 Database Creation and Table Manipulation Report

    DBM 405A Lab 3 Database Creation and Table Manipulation

    Regular Price: $15.00

    Special Price: $12.00

    DBM 405A Lab 3 Database Creation and Table Manipulation


    I. OBJECTIVES
    1. Understand and become familiar with Table Manipulation.


    II. PARTS LIST
    1. EDUPE Omnymbus Environment (https://devry.edupe.net:8300); and/or
    2. MySQL (dev.mysql.com/downloads).


    III. PROCEDURE
    By now you have set up either the Omnymbus environment or the MySQL Server Community environment, or both. You may do the labs in this class on your own computer equipped with MySQL or you may use the MySQL environment hosted by the vendor Omnymbus. You may even use both.


    Lab Procedure Continued (common to both environments)
    1. Add a table named "Season" to your Baseball database, which consists of the following fields:
    a. Season (Integer)
    b. PlayDate (date)
    c. HomeTeam (character 5)
    d. HomeTeamScore (Integer)
    e. AwayTeam (character 5)
    f. AwayTeamScore (Integer)
    2. Populate the table with 56 unique games where each plays the other 7 twice (once as the home team and once as the away team). Make the season equal to this year. Leave the scores blank and use any date for the PlayDate.
    3. Create another table called "PastSeasons" by copying the structure of the table "Season" and copying all the data from "Season" into the new table.
    4. Replace the Season field in the table Season with next year for all records.
    5. Unload the Season table data to a comma-delimited file.
    6. Load the comma-delimited file to PastSeasons table, appending the data to the data that is already there.

    Learn More
  4. MIS582 iLab 1 SQL Queries Using MySQL Select Statements

    MIS582 iLab 1 SQL Queries Using MySQL

    Regular Price: $15.00

    Special Price: $12.00

    MIS582 iLab 1 SQL Queries Using MySQL


    iLab Overview
    Scenario/Summary
    The purpose of this iLab is to prepare for the first phase of the Course Project. This week, you will learn to create and run SQL SELECT queries from a script in the MySQL database. You will need to create a database in MySQL via Omnymbus, run a SQL script to create tables and insert data, create and execute a script containg SQL SELECT queries using the STUDENT table.
    Please ensure that you can connect to MySQL/Omnymbus via the account your Professor has emailed to you. Please consult with the document titled MySQLOmnymbusSupport.docx located in the Doc-Sharing folder titled Omnymbus Tutorial Files for instructions on how to get help for any issues that you are having with the MySQL/Omnymbus Environment.
    Due Midnight Mountain Time attached to the Week 1 DropBox. OR let me know if you are going to be delayed!
    SQL file named Lab1_Query.sql containing SELECT statements
    Text document named Lab1_Output.txt containing labeled output
    Upload files to the Week 1 iLab Dropbox.
    Please do not zip the files


    Required Software
    Omnymbus – MySQL at the edupe database server.
    Access the software at https://devry.edupe.net:8300
    If you have any problems, connection, password, technical, etc ONLY your instructor can assist. Using any other Help facility will delay the resolution of the problem as the request is forwarded in all cases to the instructor.


    STEP 1: Logging in to Omnymbus
    Look at your email account to obtain the MySQL/Omnymbus account and password that your Professor has emailed to you.
    To help you log into MySQL Omnymbus environment, download the tutorial Login MySQL Omnymbus Environment in the Doc-Sharing folder titled "Omnymbus Tutorial Files".


    STEP 2: Create a Database and modify your script to reference your Database
    Create a MySQL database:
    Download the tutorial Creating a Database in MySQL Omnymbus Environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow the steps to create a database in MySQL, especially paying attention to the database naming conventions specified in the tutorial.
    Download the Wk1LoadDatabaseScript.sql file from Doc Sharing in the folder titled iLab Documents.


    STEP 3: Running script file in MySQL, create SQL
    Download the tutorial Running SQL Scripts in MySQL Omnymbus environment from the folder in Doc-Sharing titled Omnymbus Tutorial Files. Follow those steps and execute the Wk1LoadDatabaseScript.sql file to create the tables and to insert data into them; and then download and run the script file with the queries iLab1QueryScript.sql. This script has the first few queries and it is intended that you should finish it. A demonstration in the Week 1 Live Lecture will be provided.


    Create SQL SELECT Queries:
    ALWAYS and only use a plain text editor such as Notepad! All word processors will insert hidden tags that confuse database processors.
    Using the data in the Student table in the database, expand the supplied starter SQL script file named iLab1QueryScript.sql, containing queries to execute each of the tasks below.
    To reference, learn and apply MySQL's own dialect of the SQL language to this iLab, browse through the file M10C_KROE8352_13_SE_WC10C.pdf in the Doc-Sharing folder titled My SQL Documents.
    Save the completed results by copying and pasting to a file named iLab1_Results.txt
    An incomplete example is provided in the Doc Sharing.


    Query1
    Write a SQL statement to display Student’s First and Last Name.


    Query2
    Write a SQL statement to display the Major of students with no duplications. Do not display student names.


    Query3
    Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622


    Query4
    Write a SQL statement to display the First and Last Name of students who live in the Zip code 97912 and have the major of CS.


    Query5
    Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622 or 37311. Do not use IN.


    Query6
    Write a SQL statement to display the First and Last Name of students who have the major of Business or Math. Use IN.


    Query7
    Write a SQL statement to display the First and Last Name of students who have the Class greater than 1 and less than 10. Use the SQL command BETWEEN.


    Query8
    Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.


    Query9
    Write a SQL statement to display the First and Last Name of students having an a in the second position of their first names.


    Query10
    Write a SQL expression to display each Status and the number of occurrences of each status using the Count(*) function; display the result of the Count(*) function as CountStatus. Group by Status and display the results in descending order of CountStatus.
    Note: there are examples very similar to these in the Kroenke text


    Rubric
    Queries that are correct will be awarded the number of points shown below:
    4 points: Query 1
    5 points: Query 2 – 9
    6 points: Query 10
    The following rubrics will be used for incorrect queries:
    0 points: Query was not turned in with the assignment.
    -4 points: Query will not run.
    -3 points: Query runs but is incorrect because query required a WHERE clause to meet requirements which was not included.
    -2 points: Query runs but is incorrect because WHERE clause contained errors, gives popup for user input, or only meets partial requirements.


    Please Make sure all requirements are met!

    Learn More
  5. MIS582 Course Project Week 2 SQL Queries Using MySQL Select Statements.jpg

    MIS582 Course Project Week 2 SQL Queries Using MySQL

    Regular Price: $15.00

    Special Price: $12.00

    MIS582 Course Project Week 2 SQL Queries Using MySQL


    The Course Project will consist of three tasks, each worth 50 points due in Weeks 2, 4, and 6. Successful completion of the iLabs will help you in completing the project tasks.


    Week 2: Task1: SQL Queries Using MySQL (50 Points)
    Using the same tables that you created by running the script file provided in Doc Sharing for iLab1, write
    the following 10 queries each worth 5 points.


    Name Task
    Query1: Write a SQL statement to display the course numbers of classes taught by Hammett Glenn.
    Query2: Write a SQL statement to display the course names of the courses taught by an instructor whose id is 415.
    Query3: Write a query to display the name and office number of all instructors who teach Psy101.(USE NATURAL JOIN)
    Query4: Write a query to display the semester and the number of courses offered in that semester. Display only the semesters that offer more than five courses.
    Query5: Write a SQL statement to display the name of each campus and the total number of rooms in that campus.
    Query6: Write a SQL statement to display the list of instructors who are approved as well as those who are not approved. (OUTER JOIN)
    Query7: Write a SQL statement to display the start date and start time of all classes taught by instructor Hammett Glenn.
    Query8: Write a SQL statement to display the number of students in each major with a status of failing.
    Query9: Write a SQL statement to display the credit hours of all courses that Hammett Glenn is approved to teach.
    Query10: Get the campus name and phone number of all rooms with numbers greater than 25.


    Deliverables
    Create and save your SQL queries and script in a text file named Lastname_Task1_SQL_Script.sql.
    Capture the output and paste it into Word Document. Save it as Lastname_Task1_SQL_Result.txt.
    When you are done, submit your documents zipped together in a single file to the Week 2: Course Project Week 2 Task 1 Dropbox.


    Rubrics
    Queries that are correct will be awarded the number of points shown below:
    4 points: Query 1
    5 points: Query 2–9
    6 points: Query 10
    The following rubrics will be used for incorrect queries.
    0 points: Query was not turned in with the assignment.
    -4 points: Query will not run.
    -3 points: Query runs but is incorrect because query required a WHERE clause to meet requirements which was not included.
    -2 points: Query runs but is incorrect because the WHERE clause contained errors, gives popup for user input, or only meets partial requirements.
    Tutorials to Consult With M10C_KROE8352_13_SE_WC10C.pdf in the folder titled My SQL Documents in Doc Sharing for all things to do with MySQL including example SQL.
    Login MySQL Omnymbus Environment.docx in the folder titled Omnymbus Tutorial Files in Doc Sharing for how to log into the Omnymbus Environment.
    Creating a Database in MySQL Omnymbus Environment.docx in the folder titled Omnymbus Tutorial Files in Doc Sharing for how to create a Database in the Omnymbus Environment. Remember, all work must be done under a database you first create.
    Running SQL Scripts in MySQL Omnymbus Environment.docx in the folder titled Omnymbus Tutorial Files in Doc Sharing for how to create and run your SQL Scripts.

    Learn More
  6. DBM380 Week 4 Normalization of the Smith Consulting Visio ERD

    DBM/380 Week 4 Normalization of the Smith Consulting ERD

    Regular Price: $15.00

    Special Price: $12.00

    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.

    Learn More
  7. CMIS420 Project 2 Star Schema for OVS Database Spool File

    CMIS420 Project 2 Star Schema for OVS Database

    Regular Price: $15.00

    Special Price: $12.00

    CMIS420 Project 2 Star Schema for OVS Database


    In this assignment you will complete the creation and population of the Star Schema tables for the OVS, Inc. data warehouse database. In the Authentic Assessment (i.e. Final Project) you will be performing a number of decision support queries against this database.
    1) Complete Homework #5 by ensuring that the FINANCING_PLANS, DEALERSHIPS, VEHICLES, and TIME (or TIMES if you desire) dimension tables are created and populated.


    2) Create the SALES_FACTS fact table via SQL. Ensure that you have declared foreign keys of Sale_Day, Vehicle_Code, Plan_Code, and Dealer_ID to reference your TIME(S), VEHICLES, FINANCING_PLANS, and DEALERSHIPS tables, respectfully. Ensure that you have a primary key for the SALES_FACTS table that is a composite of the Sale_Day, Vehicle_Code, Plan_Code, and Dealer_ID columns. Do a DESC (i.e. DESCRIBE) of your SALES_FACTS table after it’s created.


    3) Using PL/SQL populate the SALES_FACTS table. One way to do this is to use a cursor to go through all of your SALES table rows, joined with other tables as necessary, to determine each combination of Sale_Day, Vehicle_Code, Plan_Code, and Dealer_ID. Then for that combination of the four columns, calculate the total Vehicles_Sold and the Gross_Sales_Amount. If these values are zero then don’t INSERT a row into the SALES_FACT table. Only insert rows for combinations of the four foreign key columns where there were some vehicles sold. After populating your SALES_FACTS table execute the query “SELECT COUNT(*) FROM sales_facts;” to show the row count. Also execute the query “SELECT SUM(vehicles_sold) FROM sales_facts;” to ensure that you have included all of your 500 or more sales.


    All SQL and PL/SQL should be executed via one or more SQL script files. The best approach is to have separate SQL script files for each step and then an SQL script file that calls all of them in sequence. Submit SQL*Plus SPOOL files produced by your SQL and PL/SQL showing all your SQL and PL/SQL code and the results, or if using iSQL*Plus or other GUI (e.g. SQL Developer), a single Word or PDF file of screen snapshots showing both your SQL and PL/SQL and the results. Do NOT submit your SQL script file.

    Learn More
  8. ITSE 2309 LAB 1 Database and SQL Queries

    ITSE 2309 LAB 1 Database and SQL Queries

    Regular Price: $12.00

    Special Price: $10.00

    ITSE 2309 LAB 1 Database and SQL Queries


    Submit: Query Statements Query Output
    Chapters 2,3,4,5 11g SQL book
    Objectives: Be able to access ORACLE/SQL Plus Be able to do simple SQL operations


    Steps:
    - Log onto the sample Oracle 11g database created.
    - See Chapter 7 in "Database Systems" for information on coding, saving, and executing your queries.
    - Save the output of the queries by using the SPOOL option ( see chpt 14 in 11g SQL in lab resources tab)
    - Save both the queries code and the output of the queries as "Lab1_LastName.txt and submit via Blackboard—using the - Attach file – Upload function


    Do the following queries:
    1. List all columns and rows in the stock table.
    2. List the last name, first name, and company of all customers (List the columns in that order). Place the list in alphabetical order by company name.
    3. List the company names for all customers from Sunnyvale, Redwood City, or San Francisco.
    4. List all orders that were placed between the dates 12/31/1999 and 01/03/2000. List order number, order date, customer number, ship date, and paid date. (Hint: Specify year in single quotes 'DD-MMM-YYYY')
    5. List the order number, order date, and shipping charges for all orders that are not on backlog and for which the shipping charge is over $15.00.
    6. List all stock items which are baseball items which have a unit price greater than $200.00 and a manufacturer code which starts with 'H'. (Hint: use LIKE)
    7. List the company name for all customers who have orders. Don not list a company more than once.
    8. List the customer number and the description (from the stock table) of all items ordered by customers with customer numbers 104-108. Order the output by customer number and description. (There should be no duplicate rows in your output).
    9. List the number of (distinct) customers having an order. Label the column "Total_Customers_with_Orders".
    10. For each customer having an order, list the customer number, the number of orders that customer has, the total quantity of items on those orders, and the total price for the items. Order the output by customer number. (Hint: You must use a GROUP BY clause in this query).

    Learn More
  9. ITSE 2309 LAB 2 More SQL Queries and Modification

    ITSE 2309 LAB 2 More SQL Queries and Modification

    Regular Price: $12.00

    Special Price: $10.00

    ITSE 2309 LAB 2 More SQL Queries and Modification


    Oracle 11g SQL–Chapters- 3,6,8,9,11,12,
    You will continuing using items created in Lab 1


    Lab 2a -- Problems 1–4,
    1. For each customer, list each stock item ordered,
    1) the manufacturer,
    2) the quantity ordered, and
    3) the total price paid.
    Include the following columns in the order given below:
    - From Customer Table: Company
    - From Stock Table: Description
    - From the Manufact Table: Manu_Name
    - From the Items Table: Quantity, Total Price
    Order the output by Company and Description.
    Submit/hand in Output from SQL query


    2. List all orders with a shipping date between December 25, 1999 and January 5, 2000
    Include
    1) the Order Number,
    2) Order Date,
    3) Customer company name, and
    4) Shipping Date.
    Order by
    Customer Company Name and Order Number.
    Submit/hand in Output from SQL query


    3. Count the number of customers who do not have any orders placed.
    Submit/hand in Output from SQL query


    4. List all customers –
    I) Who are ordering equipment whose description begins with 'tennis' or 'volleyball'.
    II )Include
    1) Customer number,
    2) Stock number, and
    3) Description.
    Submit/hand in Output from SQL query
    Do not repeat any rows.


    Lab 2b Problems 5, 6, 7 and 8
    5. Use the following SQL CREATE commands to CREATE the following tables in your
    CREATE TABLE Professor
    (Prof_ID NUMBER(3) Constraint pk_Professor Primary Key,
    Prof_Lname VARCHAR2(15) NOT NULL,
    Prof_Hiredate DATE,
    Prof_Sal NUMBER(8,2),
    Prof_Dept CHAR(6),
    );
    CREATE TABLE Student
    (Stu_ID NUMBER(4) Constraint pk_Student Primary Key,
    Stu_Lname VARCHAR2(15) NOT NULL,
    Stu_Major CHAR(6),
    Stu_CredHrs NUMBER(4),
    Stu_GradePts NUMBER(5),
    Prof_ID NUMBER(3),
    CONSTRAINT fk_Student_Prof_ID FOREIGN KEY(Prof_ID)
    REFERENCES Professor
    );
    Submit/Hand in: Print out of the Create commands, the system response and a DESCRIBE of the tables created.


    6. Insert the following data into the tables created above using SQL INSERT commands.
    Professor Table:
    Prof_ID Prof_Lname Prof_Hiredate Prof_Sal Prof_Dept
    123 Hilbert 20-MAY-1992 58000.00 MATH
    243 Newell 15-JUL-1997 65500.00 CMPSCI
    389 Lessing 04-APR-1988 40250.00 ENG
    Student Table:
    Stu_ID Stu_Lname Stu_Major Stu_CredHrs Stu_GradePts Prof_ID
    2001 Parker CMPSCI 52 160 243
    2166 Smith ENG 30 75 389
    3200 Garcia MATH 62 248 123
    4520 Smith CMPSCI 45 157 NULL
    BE SURE TO ISSUE A COMMIT AFTER TABLE MODIFICATION COMMANDS HAVE BEEN RUN SUCCESSFULLY.
    Submit a
    Listing of each INSERT command,
    The systems response and the resulting tables after the INSERTS are completed
    (Example: SELECT * FROM Student;).


    7. Perform the following SQL DELETE statements. Be sure to do them in order.
    Issue a COMMIT command after all DELETEs have run.
    a. Try to delete Professor 389. What message do you get? ___________________________
    b. Delete Student 2166.
    c. Now Delete Professor 389. Explain why the first attempt in a. was unsuccessful, and this time the DELETE was successful.
    Submit/hand in : A listing of the DELETE statements.
    The answers to questions a. b. and c.
    A listing of the two tables after the deletes have run.


    8. Perform the following UPDATE commands.
    Issue a COMMIT command after all UPDATEs have run.
    a. Replace the value of the Prof_ID for Student 4520 with 243.
    b. Add 10% to the salary for each professor
    Submit/hand in : A listing of the UPDATE statements
    A listing of the two tables after the UPDATEs have run.

    Learn More
  10. DBM 502 Week 1 Individual Assignment Small Database and Paper

    DBM 502 Week 1 Individual Assignment Small Database and Paper

    Regular Price: $15.00

    Special Price: $12.00

    Build a small, simple database for your personal use. Some suggestions might be an address book, tax deduction tracking, or automotive history.

    You must use a relational database management system (RDBMS). You may use any RDBMS you wish (e.g. Access, SQL Server, Oracle, DB2, MySQL, etc.), although if you’re unfamiliar with any product, then you will probably find Access to be the easiest to use.

    Your database must have at least 2 related tables. All of your tables should be fully normalized, such that redundant data is removed. You must show how your tables were created (i.e. Design Views or SQL). You must include all applicable integrity constraints (i.e. primary keys, foreign keys, required/NOT NULL, unique, and validation rules/CHECK constraints).

    Submit for grading a single Word or .pdf file with screen snapshots showing all steps in the creation of your database, the creation of your tables, the population of your tables with at least 3 rows of data each, and at least 3 queries of your data. Do not submit your actual database.

    Include at the end of your Word or .pdf file a 200- to 350-word write-up to respond to the following:
    • As you built your database, what challenges did you encounter? What tips do you have for your fellow students? Learn More

Items 1 to 10 of 158 total

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

Grid  List 

Set Ascending Direction