7003ICT | Designing a Database for WareMart | Database

Home Recent Questions 7003ICT | Designing a Database for WareMart | Database

Assessable Tasks

a)  Group Submission

From the WareMart business requirements specified above, prepare a document according to the followings:

1. Use the supplied template for your Assignment submission.
2. An appropriate title page that includes the signatures of all students in the group and an acknowledgement of all students and staff you have spoken to about the assignment.
3. A table of contents and page numbers.


4. An ERD using Crow’s Foot notation. The diagram should include:
a) all entities, attributes, and relationships (including names) ;
b) primary keys (underlined) and foreign keys (italic) identified;
c) cardinality and modality (optional / mandatory) symbols; and
d) assumptions you have made, e.g., how you arrived at the cardinality and/or participation for those not mentioned or clear in the business description, etc.


5. Normalisation of the relations which identifies:
a) dependency diagram for each relation
b) the level of Normalisation achieved for each relation
c) the reasons for any relation that is NOT maintained in 3NF.


6. Relational database schema that translate your ERD and include:
a) relation (table) names,
b) attribute (column ) names and data types (as required by XAMPP or UwAmp),
c) length of each field & its description (e.g., if it is a primary key, a foreign key referring to another table or format, etc.)
d) primary and foreign keys identified;

7. A bibliography, containing all resources used to complete the assignment. If no resources have been used please indicate this appropriately.

b) Individual Presentation / Viva


In the week of the submission due date, students in each group will be required to attend the workshop/lab in-person. The tutor will assess each student via a brief presentation / viva.

Search Here

Latest Reviews

  • Kannon
    13 Jul, 2019

    I asked for essay help from Assignment Help 4 Me and I am happy that the essay writers completed my task on time. The prices they asked for are worth in comparison to the services rendered.

  • Liam
    13 Jul, 2019

    Assignment Help 4 Me is the best help provider. I took assistance to get my essay completed and I am glad that the writers delivered the quality content as they promised within the time committed.

  • Silas
    12 Jul, 2019

    Accounting is a very interesting subject but when it comes to assignment writing, I feel hard to get through the same. But, since the assignments have to be completed somehow, I preferred to avail online help from Assignment Help 4 Me. All thanks to them that they helped me complete my work on time at reasonable prices.

View All Reviews

Facebook

Assignment Help 4 Me