Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with my Database homework.... I need to create a database in SQL developer about a timeclock system below is everything I need.

I need help with my Database homework.... I need to create a database in SQL developer about a timeclock system below is everything I need.

Perform a logical design on the proposed database environment without going through the full normalization process.  Include the identification of all entities and attributes associated with the environment. 

Use a 2-page memo to document your logical design including the process you went through. 

Discuss the process you went through to select the appropriate data types, primary and foreign keys, and other constraints that are necessary to maintain the integrity of the database.

Your database project must meet the following assessment requirements:

  • Design a database using professional principles and standards.
  • Provide a logical design of the database. As a part of the design, normalize the database to the 3NF
  • Use Microsoft Visio or another tool to create this diagram to normalize the ERD to third normal form (3NF).

Your database project must meet the following requirements:

  • Create a database using professional principles and standards.
  • Use a relational database software application to develop a database implementing the logical design into a physical design.
  • Use an Oracle® database to create the normalized physical database including tables, columns with data types, primary keys, constraints, etc.
  • Create a minimum of ten rows of test data in each table.

Design and develop the below queries using professional principles and standards:

  • A set of SQL Statements that returns all rows and all data for each table in your database.
  • Two SQL Statements that return a subset of columns and a subset of rows using the WHERE clause.
  • Two SQL Statements that join two or more tables in one query. Look for primary and foreign keys to help you determine join points. Use the JOIN clause as a part of your queries.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

I can help you with the logical design and provide guidance on the steps you need to follow To start with the logical design of the timeclock system d... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Decision Making and Performance Management

Authors: Ray Proctor

4th edition

273764489, 978-0273764489

More Books

Students also viewed these Databases questions

Question

Solve this system of equations -3x-y 5 -3x - 4y 83 || y = 1 11

Answered: 1 week ago