ITC556 Introduction Of Database Systems

Task:

Learning Outcomes

Upon successful completion of this subject, students should:

• be able to model complex business rules using Entity Relationship Diagrams (ERDs);

• be able to apply normalisation techniques to optimise a database design;

Save your time - order a paper!

Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines

Order Paper Now

• be able to use complex SQL commands to query a database;

• be able to research a recent development in the field of database technology.

Assessment: Research And Data Modelling

Part A: Database Research Discussion Forum

Note: you are expected to conduct research about current and future Database technologies and participate on online interact 2 discussion forum. Copy time, date and content of your response to this post and include it as part a in assessment a document. Your minimum repose posts should be two.

Post Topic: Discuss future of database technologies 

Part B: Data Modelling

Create an ERD for each of the above statements that describe the current business rules for JCBC:

Use Crows Foot notations and include all of the following in each part:

• All entities with Primary key and any foreign key attributes; 

• The relationships between entities; 

• Identify the cardinality between teams and players and between teams and city

• Draw the Crow’s Foot ERDs to represent the JCBC database