Browse Over 3 Million Questions

Let Our Professionals Assist You With Research and Writing. 

student_PNG181-2.png

Critically analyse, manage and present inmeaningful ways information and data, andTo act as an ethical practitioner while demonstrating skillsin data analysis, database design, system design, webdesign and software development and testing

a)b)c)To gather, critically analyse, manage and present inmeaningful ways information and data, andTo act as an ethical practitioner while demonstrating skillsin data analysis, database design, system design, webdesign and software development and testing.To implement and document user experience analysis,design and testing.a)b)c)Design and build relational databases.Define views and formulate efficient queries using a querylanguage, andBe knowledgeable about issues relating to data access andretrieval, storage, ethics and privacy.ASSESSMENT DESCRIPTION:This assessment is an individual Project.International Parcel Service (IPS) has asked you to design and implement their system. Thecompany wants to store the records of customers, employees, retail centres and items being shipped.The heart of IPS system is the item being shipped.DescriptionThe shipment process starts when items are received into the system at a single retail centre.Retail centres are characterized by their type, uniqueID, address and employees that are working inthat centre. The system records the name of the employee who has received the item at the retailE.g. a task marked out of 40 will incur a 2 mark penalty .Student Policies and FormsKent Institute Australia Pty. Ltd.Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458Version: as atTEQSA Provider Number: PRV12051centre. Shipped items can be characterized by item number (unique), weight, dimensions, insuranceamount, destination, final delivery date and any special instructions given by the customerregarding handling of the item.Once an item is received, a receipt is generated which is given to the customer. The receipt containsthe information such as item number, date on which item is received, and the charges paid. Shippeditems make their way to their destination using many transportation modes such as flights or trucks.The transportation of every single item is recorded with transportation events which arecharacterized by a unique scheduleNumber, a type (e.g, flight, truck), and a deliveryRoute.Tasks to be completedGiven the above information:1. Create a complete ERD with all entities and relationships to support the IPS needs asdescribed above. The entities should have appropriate attributes and suitable data types.Every relationships should have appropriate connectivity and cardinalities.2. Convert the ERD to a set Relational tables in at least 3NF and draw a dependency diagram.3. Create a database using MS ACCESS – with primary keys, foreign keys and other attributesmentioned for each entity using proper constraints.4. Create a form to input/update data for ITEMS.5. Input some significant data in each table showing your understanding of the scenario.6. Create three queries – SELECT, JOIN and one NUMERIC Function query; you can use anytables and any fields.7. Create a report using any one of the above queries.List any additional business rules that you may assume to submit the ERD and database as completeas possible.ASSESSMENT SUBMISSION:The assignment must be submitted online in Moodle. All materials MUST be submittedelectronically in Microsoft Word format. Other formats (e.g., pdf or MAC file) may not bereadable by markers. Please be aware that any assessments submitted in other formats will beconsidered LATE and will lose marks until it is presented in MS Word. No paper based orhardcopy submission will be accepted.

Order a similar paper and get 15% discount on your first order with us (Coupon Code: SAVE15)

Dr. Thea Watson
98% Success Rate
Read More
“Hello, I deliver nursing papers on time following instructions from the client. My primary goal is customer satisfaction. Welcome for plagiarism free papers”
Ivan L. Myers
98% Success Rate
Read More
Hi! I am an English Language and Literature graduate; I have written many academic essays, including argumentative essays, research papers, and literary analysis.
Dr. Evelyn Dougherty
98% Success Rate
Read More
"Hi, count on me to deliver quality papers that meet your expectations. I write well researched papers in the fields of nursing and medicine".
Dr. Paul P. Klug
99% Success Rate
Read More
"A top writer with proven reliability and experience. I have a 99% success rate, overall rating of 10. Hire me for quality custom written nursing papers. Thank you"

We Offer the Custom Writing Service with 3 Key Benefits

Affordable Writing Service

We guarantee a perfect price-quality balance to all students. The more pages you order, the less you pay.

The Best Support Service

Get 24⁄7 help with proofreading and editing your draft – fixing your grammar, spelling, or formatting.

Quality Essay Help

Our team of professional writers guarantees top-quality essay writing results.

Stay In Touch!

Leave your email and get discount promo codes and the best essay samples from our writers!
Chat With Us
Chat With Us