This is an open-book, graded assignment. You may use online resources for reference purposes only to help with the assignment.
computer science
Description
This Assignment is worth 15% of the Web Information Processing CA Component.
This is an open-book, graded assignment. You may use online resources for reference purposes only to help with the assignment. Please cite all references as comments in your submissions. You cannot directly reuse HTML/CSS/JS solution code from online sources. You must not engage with another student, in person or electronically (phone, social media, etc.) to secure assistance with this assignment. If you do so you will receive an automatic fail (0%). We will perform similarity checks on submitted assignments to check for collaborative efforts. A reasonable attempt at this assignment will gain you 15% of your continual assignment marks.
1. Personal details for customers of a hypothetical online mobile-phone store. The database should contain entities that record customer personal information [Title, First Name(s)*, Surname*, Mobile*, Email Address*], and both home and shipping addresses [Address Line 1*, Address Line 2, Town*, County/City*, EIRCODE]. The fields marked * are required fields, i.e. they must contain values.
2. Item details for mobile phones sold by the online store (from a random selection of phone items; 10 maximum) which contain the following phone details: [Manufacturer*, Model*, Price*]. The fields marked * are required fields, i.e. they must contain values.
3. Order details for customer purchases. Orders contain a list of items (phones) that have been purchased by customers. Customers may purchase more than one item in a single order. Customers
may make multiple orders containing multiple items. The system should record item purchasers;
or it should be possible to establish this information using queries.
