Analyze the database environment

Assignment Help Database Management System
Reference no: EM13752279

First, you must choose a database environment from the following choices:

A college that needs to track courses, course sections, and professors teach the sections in order to publish a course schedule

A retail business that needs to track store locations, shifts, and the employees assigned to each shift

An appropriate database environment within your workplace (must be approved by your instructor - send me a one-paragraph email describing the environment and its purpose)

You may NOT use examples involving:

An art museum that needs to track artists, artwork, and locations
A consulting organization that needs to track staff, skill sets, and projects

Once you have chosen your database environment, write a 750- to 1,050-word paper in which you address these elements:

Analyze the database environment, including its objectives (why will it be built?), its boundaries (what is in and out of scope?), its constraints (what rules must it follow?), and any challenges that will accompany its construction.

Describe at least 3 entities (which will eventually become tables in a database)

List attributes for each of these entities.

Reference no: EM13752279

Make presentation for the database migrationtool

Make powerpoint Presentation for Database migrationtool..PowerPoint should consists of Atleast 18 pages. Database Migration tool code and execution steps should be in zip file

Create a physical inventory document for warehouse stock

Create a new Purchase Requisition for 50 Child Deluxe Bikes, to be delivered to Plant MI00, Storage location TG00, in 1 month from today and Create a quotation with reference

What are the ten functions of a dbms

What are the ten functions of a DBMS? Define the term "referential integrity constraint" and give an example. What is the difference between a database, a DBMS, and a database

Developing a use case diagram

Developing activity diagrams. (Please note that for the use case, "Buy Items", there are two scenarios, namely, "General public customer buys items" and "Contractor cus

Relational algebra expressions for names of salespeople

Illustrate relational algebra expressions for names of all salespeople, names of all salespeople having ORDER row and names of salespeople not having ORDER row.

What must a user guarantee with respect to a transaction and

What must a user guarantee with respect to a transaction and database consis-tency? What should a DBMS guarantee with respect toconcurrent execution of several transactions an

Provide an entity relationship model

Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements.Note:The graphically depicted solution is not included in th

Create an e-r diagram relating table of your database schema

Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative s

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd