Riyadh Metro is considered to be one of the leading project in the region. It connects the city districts through a huge transportation system that contains metros and buses. Riyadh citizens will be able to travel around the city easily. For more information about the project visit the website http://riyadhmetro.sa/en/.
You are part of a team which is responsible for application design and development of a tracking and planning system that involves mobile application. The system should provide customers the metro schedule information. Your role is to design and develop a database for the application. The metro system needs to model the following: Trains, Stations, Routes, Tracks, Train schedule. For simplicity you can assume that:
-Only one track exists between any two stations.
-Every train runs every day
-Each train, for each station on its route has a Time in and Time out (NULL if the train does not stop in the station).
Each train must have a name, route color and uniquely identified by an ID. Each station has a name, location and identified by an ID. Each route must have a color, starting and ending stations and a unique ID. A sequence number is needed to connect and order the tracks of each route. Train schedule stores what time a train passes through each station on its route. You can make any other additional assumptions that make sense in the real world.
Project Additional instructions:
The Project is a group activity. Group Size = Min 2 and Max 3. Each group member must submit the project individually with all group member names mentioned in the cover page. Read the project scenario carefully and visit the website http://riyadhmetro.sa/en/ to be able to answer the following questions.
Design an Entity-Relationship diagram for Riyadh Metro database.
for their dry cleaning press pads since the 1950s. In 1989, Jacobson Products Co. started using a very similar shade of green-gold on its own press pads. Qualitex Co. got it’s shade of green-gold trademarked and also sued Jacobson for infringement. Another issue faced by colour marks is the possibility of there being litigation over shades of the same colour. A solution to this problem is designation of a colour using an internationally recognised identification code like Pantone as such codes are deemed to be precise and stable. The Pantone is a commercial system that designates specific shades numerically and categorises over thousand such shades by unique codes. Tiffany and Co.’s unique shade of blue ‘Tiffany Blue’ has been a registered trademark since 1998 and also has its own custom Pantone number – 1837, the year the company was founded. T-Mobile’s colour ‘Magenta’, Mattel’s ‘Barbie Pink’, UPS’s ‘Pullman Brown’ are some more examples of colour marks. India is yet to set precedence as far as colour marks are concerned. Smell Mark Smell marks or Olfactory marks rely on their distinct smell to remind the consumers of the source i.e. the brand or the manufacturer of the product. Once distinctive, a smell is one of the most powerful manners to differentiate the goods of one merchant from those of the other. Smell marks are one of the most difficult kind of marks to get registered. However, smell being so subjective, may be perceived differently by different people. The subjectivity of smell acts as a hindrance in its distinctiveness. Another issue is the difficulty in graphically representing smells. One way to represent a smell could be to orally describe it so precisely that it doesn’t get confused with any other smell, but this is quite an arduous task. Writing the chemical formula for the substance is problematic as the formula represents the substance and not the smell itself. Samples of the smell could be stored but these may either vanish over time or change their nature when exposed to certain external factors like heat and humidity. Another important thing to note is that the scent must neither originate from the goods itself nor be functional. Functionality Doctrine again plays a role here and if any smell has a functional use, the registration of which could lead to significant disadvantage to competitors, such smell may be disbarred from registration. However, there is no clear-cut definition for functionality. For example, the smell of lemon for garbage plastic bags; the smell itself can be distinctive, but it can also be functional because it can mask the smell of waste and garbage. Fashion house Chanel’s application to get its ico>GET ANSWER