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;

• 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