Small Adjustments for my final project

I am attaching the work that has been completed through today including the rough draft. I am also attaching a sample of that the project could look like. the original requirements are as follows:This final course project is to develop an individual project plan that focuses on the database aspects of the project development lifecycle. All design, research, and work by each student will be original work in the design and creation of a new database. Students will become familiar with data management, database modeling and design, and skills to develop a final project plan. A minimum of 3 resources should be used. These requirements include the following:Requirements Analysis –BackgroundPurposeBusiness goals and rulesUser requirementsData requirementsReporting requirementsProject schedule and project costsData model – In physical design format original student designData dictionary for all tables in data modelSQL statements:CREATE TABLE statements (for entities (tables defined in model)Minimum of two SELECT statementsAt least one insert, update, or delete statement.Identify the database management system (DBMS) that will be used for the database designCreate a basic database back-up and recovery planPlease adjust the final project to accomidate the professors comments. The professors comments are as follows:Customer entity: ** CustomerName: If you are storing first and last name, I would double the size of that attribute ** CustomerAddress: Increase size ** CustomerPhoneNumber, CustomerSex: char datatypeProduct entity: ** ProductName: Increase sizeEmployee entity: ** EmployeeName: If you are storing first and last name, I would double the size of the attribute **EmployeeID: integer datatype ** EmployeeAddress: Increase sizeManager entity: ** ManagerName: If you are storing first and last name, I would double the size of the entity ** ManagerPhoneNumber: char datatype ** ManagerAge: I would change to ManagerBirthDate and store as a date field. ** ManagerAddress: Increase sizeDepartment entity: ** Need managerID as foreign key????????????. ** Descriptions need to be updated for Department entityOrders entity: ** Relationship needs to be drawn to the Employee entity
database_training_and_managment_final_project_rough_draft_2.docx

week_2_entities_attributes_and_relationships.doc

Don't use plagiarized sources. Get Your Custom Essay on
Small Adjustments for my final project
Just from $13/Page
Order Essay

week_5_project_physical_model.docx

Unformatted Attachment Preview

Database Training and Management (rough draft)
Database Training and Management
Renee Randall
Wilmington University
11/8/17
Database Training and Management (rough draft)
Training and Management of Database
Background
Employee training is an important aspect for any organization that chooses to hire new
employees. New employees should feel a sense of belonging to the company or business and
they should know their way around the company. In a correctional facility training set up, there
exists a database management system where information about tracked cadet names, address,
contact information and instructors is stored. New officers therefore need to be equipped with
sufficient information to handle the technical issues surrounding this system.
Purpose
The purpose of database training is to equip new officers with sufficient knowledge that will aid
them in navigation around database systems in Delaware Department of Correction. They need
to be able to perform data entry for example enter name of cadets in the system, map each cadet
to instructors plus be able to interpret data modeling diagrams such as Entity Relationship
diagrams, Use case diagrams and their Logical and Physical interpretations.
Business Goals and Rules
While automating data entry and storage in every business setting, all aspects need to be
considered during the process. The rules are: specification business rules, recognition rules, and
management and implementation rules.
Therefore there is need for scrutiny, detection, categorization, modeling, and certification of
business rules. Apart from rules that influence business processes we have data application rules.
Relational database systems not only provide mechanism for storing information but also offer
Database Training and Management (rough draft)
data application control mechanism. These rules are implemented through: triggers, constraints,
and procedures stored. Constraints columns of a table that ensure only a given value of data are
contained with the sole purpose to preserve the reliability of databases. This integrity of database
model is both structural and behavioral. These procedural code modules (stored procedures) are
in databases and screening to execute a second time is not required of them. A trigger is a unique
procedure stored not invoked clearly but is automatically triggered upon detection of a particular
condition.
User Requirements
Before creating a database management system there is need to solicit user requirements in
order to find out the functional requirements that need to be achieved by the system. In the
case of a Delaware Department of Correction system the user requirements include:
•
The ability to be able to sort data in terms of customer, product, employee and
department.
•
Ability to map a department to manager.
•
Ability to produce End diagrams so as to establish relationships between entities.
•
Ability to print reports that show a summary of data entered in the database system.
Data requirements
It’s important that data to be entered into the system fulfill the requirements needed i.e.
The data should be of the right data type, you cannot make an integer entry in a field
prescribed for variable characters.
Database Training and Management (rough draft)
The data should be of the right lengths, a field that is designed to host 50 characters cannot
hold 51 characters and above.
Reporting requirements
Reporting requirements for this project is SAP Crystal Reports. The utility will be able to
produce reports based on user requirements on click of a button.
Project schedule and project costs
Project Schedule
WEEK
1
2
3
4
ACTIVITY
PROJECT
January
PROPOSAL
10 to 15
FEASIBILTY STUDY
February
16 to
21
REQUIREMENT
March
ANALYSIS
to 6
SYSTEM DESIGN
April
8 to 14
5
6
7
8
Database Training and Management (rough draft)
USER
INTERFACE
May
DESIGN
15 to
20
CODING
June
22
to
27
IMPLEMENTATION
July
AND TRAINING
1 to
6
DOCUMENTATION
August
8 to
20
PROJECT BUDGET
ITEM
ESTIMATED COST ($)
Laptop(intel core i3, 2.2Ghz, 4.0GB RAM,
4500
500GB Hard Disk, with a CD_ROM)
Database Training and Management (rough draft)
Documenting the project proposal and Paper
1 000
MsSql Server
500
Crystal Report
4 000
Total estimate
51 000
Data Model
Customer table
KEY
FIELD NAME
FIELD TYPE
VALUE
NULLABLE
Primary
CustomerName
VARCHAR
25
NOT
CustomerID
INT
CustomerAddress
VARCHAR
30
CustomerPhoneNumber
VARCHAR
10
Customer Sex
VARCHAR
1
CustomerPurchaseNumber
INT
NOT
NOT
Product table
KEY
FIELD NAME
FIELD TYPE
VALUE
NULLABLE
primary
ProductName
VARCHAR
25
NOT
ProductPrice
DECIMAL
NOT
ProductID
INT
NOT
Database Training and Management (rough draft)
ProductManufactureDate DATE
ProductBatchNumber
VARCHAR
NOT
15
Employee table
KEY
FIELD NAME
FIELD TYPE
VALUE
NULLABLE
primary
EmployeeName
VARCHAR
25
NOT
EmployeeID
DECIMAL
EmployeeAddress
VARCHAR
30
NOT
EmployeeDepartment VARCHAR
25
NOT
NOT
EmployeeDOB
DATE
EmployeeSalary
DECIMAL
KEY
FIELD NAME
FIELD TYPE
VALUES
NULLABLE
primary
DepartmentName
VARCHAR
25
NOT
DepartmentID
INT
NOT
DepartmentNumber
INT
NOT
DepartmentRole
VARCHAR
Department table
200
Manager table
KEY
FIELD NAME
FIELD TYPE
VALUES
NULLABLE
Database Training and Management (rough draft)
Primary
ManagerName
VARCHAR
ManagerID
INT
ManagerPhoneNumber VARCHAR
ManagerAge
INT
ManagerAddress
VARCHAR
ManagerSalary
DECIMAL
25
NOT
NOT
10
Sql Statement
Create table
Create table Customer(CustomerName, CustomerID, CustomerAddress,
CustomerPhoneNumber, Customer Sex, CustomerPurchaseNumber(20))
NOT
NOT
Database Training and Management (rough draft)
Create table Product(ProductName, ProductPrice, ProductID, ProductManufactureDate,
ProductBatchNumber)
Create table Employee(EmployeeName, EmployeeID, EmployeeAddress, EmployeeDepartment,
EmployeeDOB, EmployeeSalary)
Create table Department(DepartmentName, DepartmentID, DepartmentNumber,
DepartmentRole)
Create table Manager(ManagerName, ManagerID, ManagerPhoneNumber, ManagerAge,
ManagerAddress, ManagerSalary)
Select Statements
Select *from Departmentr where id=28145536
Select *from Employee where Address=’Calofornia’
Database Management System
The database management system to be used in this project is the Microsoft SqlServer. This will
be accompanied by Microsoft Sql Server management studio. This database will provide a
mechanism for data entry, querying of tables and generation of Entity relationship diagrams.
This database is a relational database and it contains tables which in turn have fields or columns.
This fields hold data arranged in rows called records. This data upholds data integrity hence data
entered follows all constrains described during table creation. The DBMS will provide a
centralized view of data as well as allow multiple users at a go. Each user will have his view
point and abstract the database at his own angle as prescribed by his goals in the business
organization. The DBMS provides physical and logical independence hence protecting the users
Database Training and Management (rough draft)
from details of knowing how and where the data is stored. Among many others, the following
will be the advantages of using Microsoft Sql Server Data Management System:
? Security of data
? Independence and concept of data
? Integrity of data capabilities
? A locking mechanism for concurrent access
? Auditing and sorting activities
? The capability of recovering from errors and crashes and errors as quickly as posible,
apart from recoverability and revive ability.
? Data administration procedures
? Uncomplicated access using a standard application programming interface (API)
Data backup should be done at least daily. Data should be backed up in an online facility
such as a cloud because it guarantees security of the data hence less risks of data loss. Once
there is data backup it can be recovered easily in case of loss of data and restored back into
the Database Management System using the tools provided by Microsoft Sql Server
Management Studio.
Database Training and Management (rough draft)
Work Cited
Santa Barbara,2014. Object-Oriented construction Software
J.A. Zachman, 2013-, http://searchsqlserver.techtarget.com/definition/database-managementsystem
http://www.w3schools.com/sql/sql_create_table.asp
Data Management Individual Project Outline –
Entities, Attributes, and Relationships:
Student Name: ___Renee Randall__________________________________________
Project Name/Title:_____ Relation Modeling ________________________________
Entities and Attributes:
Entity Name: customer
Attribute: customer Name
Attribute: customer Id
Attribute: customer Address
Attribute: customer phone number
Attribute: customer sex
Attribute: customer purchase number
Entity Name: product
Attribute: product Name
Attribute: product price
Attribute: product Id
Attribute: product manufacture date
Attribute: product batch number
Entity Name: Employee
Attribute: Employee Name
Attribute: Employee id
Attribute: Employee Address
Attribute: Employee department
Attribute: Employee date of birth
Attribute: Employee salary
Entity Name: manager
Attribute: Manager name
Attribute: Manager id
Attribute: Manager phone number
Attribute: Manager Address
Attribute: Manager Age
Attribute: Manager Salary
Entity Name: Department
Attribute: Department Name
Attribute: Department Id
Attribute: Department number
Attribute: Department role
Attribute: Department
Relationship Definitions:
Relationship: one employee works for at least one department
Relationship: one department holds many employees
Relationship: one manager supervises many employees
Relationship: one manager heads one or more department
Relationship: one customer can buy one or many products
Relationship: Many customers can buy a similar type of product
Running head: Physical Data Model
Physical data model
Renee Randall
Wilmington University
11/15/17
The Final Physical Data Model is as follows

Purchase answer to see full
attachment

Order a unique copy of this paper
(550 words)

Approximate price: $22

Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency

Order your essay today and save 15% with the discount code ESSAYHELP