Information Technology 3 Assignment Help
If you are looking for Information Technology 3 Assignment Questions and Answers Help? Get quality and unique online writing services at an affordable price. Enhance your grades by hiring MBA assignment writers from Assignment Help AUS. Our 24/7 Live Service always guide your Information Technology 3 Assignment Help. Hurry up place your order now!
Assignment 1
QUESTION ONE
Note this section is research based and requires you to consult other resources beyond the module guide such as internet sources.
ENTITY RELATIONSHIP DIAGRAM
Pet Mart has requested you to design a database to store information on sales on animals and merchandises. The sales form is shown in the figure below:
- With the use of a relevant table identify all entities and attributes for each entity from the sales form in the figure above and provide your answer in the following format.
ENTITY | ATTRIBUTE |
XXXX | XXXXXX |
- Using the answers in the question above, construct a complete conceptual Entity Relationship Model (ERM) to model the data in the Sales Form. Multiplicities and primary keys must be depicted in your model.
- An IT Training Company has 30 instructors and can handle up to 100 trainees per training session.
The Company currently offers five advanced technology courses, each of which is taught by a teaching team of two or more instructors. Each instructor is assigned to a maximum of two teaching teams or may be assigned to do research. Each trainee undertakes one advanced technology course per training session.
Using the information above construct a entity relationship diagramme that shows the main entity types, relationships and data requirements for the company.
QUESTION TWO
- A DBMS performs several important functions that guarantee the integrity and consistency of the data in the database.
With regards to the above information elaborate on how a database management system secures the integrity and consistency of data.
- Examine why the object orientated model is best suited for today’s complex data environments.
QUESTION THREE
- Assess the concepts connectivity and cardinality with reference to relationship classification in database design.
- Elaborate on the design challenges and conflicting goals that database designers
Assignment 2
QUESTION ONE
Note this section is research based and requires you to consult other resources beyond the module guide such as internet sources.
Read the following information and answer the questions that follow:
Full Names | Physical Address | Movies Rented | Salutation | Category |
Janet Jones | First Street Plot no 4 | Pirates of the Caribbean Clash of the Titans | Ms. | Action Action |
Robert Phil | 3rd Street 34 | Forgetting Sarah Marshal, Daddy’s Little Girls | Mr. | Romance Romance |
Robert Phil | 5th Avenue | Clash of the Titans | Mr. | Action |
- Convert the above database table into the first normal form (1Nf).
- Using your answer to the question above, convert the database to the second normal form, (2NF).
- Convert your answer in question 1.2 to the third normal form, (3NF).
QUESTION TWO
- Assess the role of each of the different types of attributes in database design.
- Elaborate on the challenges associated with database design
QUESTION THREE
- Determine the role of normalisation in ensuring that database design is efficient.
- Examine the advantages off the network model as compared to the hierarchical database model.
- Elaborate on how data and information influences database creation.
For REF… Use: #getanswers2002100 J