Using your own words and NOT SQL syntax what does line 45 ensure will happen 3

Using your own words and not sql syntax what does

This preview shows page 3 - 6 out of 6 pages.

Using your own words and NOT SQL syntax, what does line 45 ensure will happen? 3 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153
Image of page 3
Write a proper SQL join query to retrieve all dog names for the dog owner with phone number 1-415-338-6240. Data in a data warehouses is considered “time-variant”; what does this mean? Time-variant: o can study trends and changes across time Describe two organizational problems/issues associated with data warehouses. What is one advantage and one disadvantage of storing periodic data (and not storing transient data)? Periodic data are never physically altered or deleted once they have been added to the store With transient data, changes to existing records are written over previous records, thus destroying the previous data content (state) 4 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204
Image of page 4
For a typical retail transaction, suggest one star schema dimension table name and two attributes in it. Advantages of Partitioning: Efficiency : Records used together are grouped together Local optimization : Each partition can be optimized for performance Security : data not relevant to users are segregated Recovery and uptime : smaller files take less time to back up Load balancing : Partitions stored on different disks, reduces contention Disadvantages of Partitioning: Inconsistent access speed : Slow retrievals across partitions Complexity : Non-transparent partitioning Extra space or update time : Duplicate data; access from multiple partitions SQL Statements (page 5) CREATE TABLE DOG_OWNER (OWNER_ID INTEGER, OWNER_FIRST_NAME VARCHAR2(30) NOT NULL, OWNER_LAST_NAME VARCHAR2(30) NOT NULL, OWNER_PHONE VARCHAR2(15) NOT NULL, EMP_ID INTEGER NOT NULL, PRIMARY KEY (OWNER_ID), FOREIGN KEY (EMP_ID) REFERENCES DOG_OWNER (OWNER_ID)); CREATE TABLE DOG (DOG_NAME VARCHAR2(30) NOT NULL, DOG_BREED_ID INTEGER NOT NULL,
Image of page 5
Image of page 6

You've reached the end of your free preview.

Want to read all 6 pages?

  • Spring '14
  • B MAK

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes