this question related to data base management system. i wrote all specification in file.

 

OverviewFor this assignment you will implement and query a database from a supplied ERDiagram and Schema.You will be required to write the SQL statements to create thedatabase structures, to fill the database with data and to run queries on the data.Learning Outcomes AssessedThe following course learning outcomes are assessed by completing this assessment:ï‚·A1.design and implement a relational database using a database management systemï‚·A2.utilise a query language tools and techniques to obtain data and information from adatabaseï‚·K5.describe relational algebra and its relationship to Structured Query Language (SQL)ï‚·S1.interpret entity-relationship diagrams to implement a relational databaseï‚·S2.demonstrate skills in designing and building a database application using a commerciallyavailable database management system development toolï‚·S3.use a query language for data manipulationAssessment DetailsFHTS Incorporated has provided you with a standard solution for the conceptual datamodel (the ER diagram).You have been commissioned to continue your role (in yourcapacity as a Database Management System consultant) and to write the SQLstatements to create the database and its tables, add data, and to provide SQL solutionsto some of their everyday queries.The database should be created based on the ERdiagram provided at the end of this document.Some sample data are also provided to beused for inserting data into tables.However, you are also required to insert sufficient datato test the reports given below.To implement the database1.Translate the ER diagram provided into a relational schema using the correctnotations and standards for this course.It should include:a.Table namesb.Attribute names and field types (as required by XAMPP)c.Primary and foreign keys identified2.Create a text file called nnnnnnnn-create.sql (wherennnnnnnnis your studentnumber).The file should include:a.The SQL statements to create a database called FHTSnnnnnnnn(wherennnnnnnnis your student ID - e.g. FHTS30011111)b.The SQL statements to create the tables, including their primary keys,foreign keys and the relationships of the tables.3.Create a text file callednnnnnnnn_insert.sql (wherennnnnnnnis your studentnumber).The file should include:

• 1495184384-ITECH 1006-5006 Assignment 2 Sem2 2016 2.docx

ComputerScienceExpert

(11)

Status NEW Posted 19 May 2017 08:05 AM My Price 9.00

-----------

Attachments

file 1495184385-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer