country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!

ASS Database Design And Development

tag 0 Download3 Pages / 730 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

Question:

Discuss about the ASS Database Design and Development.
 
 

Answer:

Normalization

The sample solution of ASS database is used for mapping the ERD into a set of relations into 3 NF.

The table Employee

EmployeeID PK

Full Name

Street

City

State

postCode

Phone

EmployeeType

For making it in 3 NF the following new table is created

Employee (EmployeeID PK, Full Name, Address (Street, City, State, postCode), Phone, Type, Noof ExperienceYears, Certificate Level)

ClientID PK

Full Name

Street

City

State

postCode

Phone

IsSenior

The client table in already generalized and thus no changes are made in the client table

Client (ClientID PK, Full Name, Address (Street, City, State), Phone, Seniority Level)

The car table given in the example is

RegnNbr PK

Make

Model

Colour

Produced Year

Price

Warranty Due date

Purchasedfrom ASS

To make it in 3NF the following table is created

Car (RegNo PK, Make, Model, Colour, Manufacturing Year, Price, WarrantyDue Date, PurchasedFromASS)

The service table given in the example is

JobNbr PK

JobDescription

ServiceDate

TotalCost

The service table after normalization

Service (JobNbr PK, JobDescription, Service Date, TotalCost, StartTime, FinishTime, LabourCost)

Parts table before normalization

PartID PK

PartDescription

PricePerUnit

The parts table after normalization

PartUsed (PartID PK, JobNbr FK, QuantityUsed, PartCost)

The car and the client is selected from the relation and the functional dependency that exist with the relation are given below:

Client (ClientID PK, Full Name, Address (Street, City, State), Phone, Seniority Level)

Client has the following functional dependency and is given below

ClientID

FullName, Address, Phone, Level

For the client table the client ID is the primary key and the transitive dependency are removed for normalizing the table into 3NF. The removal of the transitive dependency does not affect the database and still it can be joined to get the information about the client using the client ID. The risk of redundancy during the insertion of data in the table is removed my making the table into third normal form and removal of the dependency.

Car (RegNo PK, Make, Model, Colour, Manufacturing Year, Price, WarrantyDue Date, PurchasedFromASS)

The car table is created and the functional dependency of the car table is demonstrated below:

RegNo

Model, Maker, Color, ProducedYear, CarPrice, WarrantyPeriod

The table contains the registration number of the car and the model, manufactured year, car price, WarrantyDue, PurchasedFromASS. The transitive dependency is removed from the table and normalized into 3NF for reduction of the redundancy of data and resolve the duplicate entry issues raised during the entry of data into the tables. The car table can be joined using the registration number and all the data required can be fetched by joining the tables.

Implementation of Relational Database

Microsoft Access is used for the development of the relational database of the system.

Short Implementation report

  1. The two interesting things or procedures that were learnt during the advancement of the assignment is the preparation of the report and the removal of the transitive dependency between the tables. It is important to remove the transitive dependency between the tables for making the table in third normal form.
  2. The complexity faced during the development of the database is generalization of the table into 3NF but the previous solution was deeply analyzed for the preparation of the preparation of the database. The dateAdd and the Date methods was studied for the getting different outcomes from the database and the use of now() function is also studied for getting an effective result of the querry and fetch the date and time from the computer.

The most complex task in the assignment

The complexity of the assignment lies during the setting of the constraints in the car table i.e. the registration number and linking it with the other table i.e the customer to get the appropriate outcome of the querry. The complexity of the report was resolved by taking an input mask that is new and a lot of time is spend for the implementation.

 

Bibliography

Coronel, C. and Morris, S., 2016. Database systems: design, implementation, & management. Cengage Learning.

Harrington, J.L., 2016. Relational database design and implementation. Morgan Kaufmann.

Hsieh, W.C.Y., Lloyd, A. and Veach, E.H., Google Inc., 2017. Systems and methods of increasing database access concurrency using granular timestamps. U.S. Patent 9,747,310.

Kinser, A.S., Hammerle, P.P., Kinser, E.P., Lending, D.P. and Nightingale-Massart, J.P., 2013. Your Office: Microsoft Access 2013, Comprehensive. Prentice Hall Press.

OR

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2019). ASS Database Design And Development. Retrieved from https://myassignmenthelp.com/free-samples/ass-database-design-and-development.

"ASS Database Design And Development." My Assignment Help, 2019, https://myassignmenthelp.com/free-samples/ass-database-design-and-development.

My Assignment Help (2019) ASS Database Design And Development [Online]. Available from: https://myassignmenthelp.com/free-samples/ass-database-design-and-development
[Accessed 31 May 2020].

My Assignment Help. 'ASS Database Design And Development' (My Assignment Help, 2019) <https://myassignmenthelp.com/free-samples/ass-database-design-and-development> accessed 31 May 2020.

My Assignment Help. ASS Database Design And Development [Internet]. My Assignment Help. 2019 [cited 31 May 2020]. Available from: https://myassignmenthelp.com/free-samples/ass-database-design-and-development.


MyAssignmenthelp.com is the perfect solution to render quality solution for all sort of academic issues. We have hired professionals from different fields of study to provide assistance with different subjects. We successfully have provided different types of assignment solutions on 100+ subjects. We have hired industry experts to deliver nursing assignment, hr assignment and finance assignment help. To offer quality content with IT assignments, we have hired IT professionals to render programming language assignment help and IT assignment help for other types of IT assignments as well.

Latest Database Samples

COIT20247 Database Design And Development 3

Download : 1 | Pages : 2

Answer: Entity Relationship Diagram   (Smartdraw, 2016) Assumptions and Business Rules Following business rules and assumptions are put into practice into the CQI database- A customer can insure more than one property. Each property should be attached with addresses. Each claim should be belonged to one customer. The policy premium will be on yearly basis in CQI. The policy types available at CQI are- ‘Home’, &lsquo...

Read More arrow

TCC 233 Database Management Systems

Download : 0 | Pages : 7
  • Course Code: TCC 233
  • University: Wawasan Open University
  • Country: Malaysia

Answer: About Attributes and Tuples:  In the Student Relation of figure 1, tuple is a row. Here, it has 5 tuples with 6 values that is called as 6 tuples. In general, n- tuples has a list ordered of values n.  If t1 is refer to first tuple variable for the relation STUDENT, then t1 = <S10010, Chan Wai Yee, 56A, Jalan 2/14, Taman Midah, kuala Lampur, 012-3256780, F, wai99@yahoo.com>, similarly for the other.  Tuples may ap...

Read More arrow

OIT20247 Database Design And Development

Download : 0 | Pages : 2

Answer: Business Rules Every Entity Relationship Model must have a strong set of business rules. For the CQ Insurance company’s database adaptation, the business rules that have been implemented into the ER Diagram are as follows: A customer can apply for only one of the insurance policies. He can buy the insurance for either a building policy or a home-contents policy for a particular property of his interest, or may be a building-c...

Read More arrow

ISYS616 Systems Analysis And Design

Download : 0 | Pages : 4

Answer: Reflective Journal System Analysis & Design is one of the most significant aspects of the system development projects. There are several concepts that are defined under system analysis & design. The application of these concepts shall be done to design and develop a flexible, scalable, and reliable system. I got an opportunity to apply these concepts and my understanding of the methods on Waiters on call meal-delivery system t...

Read More arrow

ISY00243 System Analysis And Design

Download : 1 | Pages : 14
  • Course Code: ISY00243
  • University: Southern Cross University
  • Country: Australia

Answer: Introduction: The information system can be considered as the set of several pieces of software application that are involved in information dissemination. A typical information system is a collection of software, hardware, computer network, human resources and more. An information system can be of many types like management information system, transaction processing system, knowledge management system, office automation system and ma...

Read More arrow
Next
watch

Save Time & improve Grade

Just share Requriment and get customize Solution.

question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

1,324,980

Orders

4.9/5

Overall Rating

5,075

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 4/5

1309 Order Completed

100% Response Time

Gemmie Chen

MSc in Nursing

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

529 Order Completed

95% Response Time

Ivan Blank

PhD in Functional Human Biology

Wellington, New Zealand

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

248 Order Completed

100% Response Time

Lloyd Bernabe

MSc in Accounting

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

610 Order Completed

100% Response Time

Cheryl Zhao

PhD in Statistics

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

I would recommend it to my friends, easy to contact. always on time and offering good prices

flag

User Id: 412828 - 31 May 2020

Australia

student rating student rating student rating student rating student rating

The work was phenomenally done, and it was even praised. I highly recommend this site, the service and help, altogether, I would not have passed any classes if it weren\'t for you guys and gals

flag

User Id: 260056 - 31 May 2020

Australia

student rating student rating student rating student rating student rating

The assignment was very well written, and the teacher was very pleased and praised the work.

flag

User Id: 260056 - 31 May 2020

Australia

student rating student rating student rating student rating student rating

For once, what I asked for was delivered without any hassle and going back and forth. Whichever writer did the assignment, thank you so much for revamping my assignment based on the feedback that was provided.

flag

User Id: 423899 - 31 May 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?