Chat with us, powered by LiveChat Imagine that you have been hired to work as a database designer in an electricity company? | acewriters
+1(978)310-4246 credencewriters@gmail.com
  

1. Imagine that you have been hired to work as a database designer in an electricity company. Your manager asks you to design a database for the billing system. Billing system is responsible to store data for following entities: Branches, Customers, Billing transactions.Define tables related to the entities above-mentioned and the attributes for each table? Create those tables with primary keys using Create SQL Statements? (10 points)b. Insert 5 records in each table with Insert Statements? (5 points)Explain, why could the following statements lead to problem: (25 points)Select Student_name from Student A Where Stud_id=5 Where Age=20;Select All from Student;Select *, [student name] where Stud_id=1Select * from Student order by stud_id where student_name=’Frank’;Select from Student order by stud_id where student_name=Frank;

error: Content is protected !!