Programming Exercise IV Construction (Cont.)

  1. Oracle 12c Relational Database Design
  2. The following three tables show sample values of a relational bus itinerary database, of which rid, rsid, and sid are the primary keys of the tables route (or r), route_stop (or rs), and stop (or s), respectively. The begin and end are the foreign keys of the table route, and rid and sid are the foreign keys of the table route_stop. The ord is the sequence order number of the bus stop in the route starting from 0.


    Relational database design uses either one of the two methods:

    • Entity-relationship modeling, dividing your database in two logical parts, entities (such as “customer” and “product”) and relations (such as “buys” and “pays for”).

    • Normalization, a series of steps followed to obtain a database design that allows for efficient access and storage of data in a relational database.
Review: Unix/Linux Operating Systems
    Which statement is NOT true about Unix/Linux operating system?

      One of the Unix shell is Y shell and its startup configuration file is .yshrc.
      .profile is the shell startup file and gets executed whenever you login.
      The source command reads and executes commands from the given file.
      Unix shell is the command interpreter used to pass commands to an OS.
        Result:




      Teacher: Which is the best month for studies?    
      Student: Octembruary…    
      Teacher: There is no such month…    
      Student: Exactly.